Phoenix allows us simple and quick invention playing with it’s SQL interface while keeping HBase overall performance and throughput
- multi-tenant dining tables having customization and you will scale away across the the varied customers schemas
- aggregation to create move-upwards descriptions
- supplementary indexes to alter performance
“Apache Phoenix ‘s the first step toward our big studies stack, allowing me to run interactive inquiries up against HBase investigation from inside the an excellent efficace styles.”
On Bloomberg, designs of accessibility financial datasets was diverse and you will advanced. HBase contains the scalability and you will strong texture which our fool around with circumstances consult. But not, we want over a key-worth shop. We need ANSI SQL to minimize the latest traps to adoption, we want has for example secondary indices to help with searches along multiple axes and you will cursors to cope with UI pagination.