Apache Phoenix is a relational database layer over Apache HBase, providing low-latency SQL queries over HBase data.
Installation
Required packages: phoenixdb
Connection String
phoenix://{hostname}:{port}/Supported Features
JOINsSubqueriesDynamic SchemaCatalog SupportDynamic CatalogSSH TunnelingQuery CancellationFile UploadUser ImpersonationCost EstimationSQL Validation
Time Grains
Common Time Grains:
SECONDMINUTEHOURDAYWEEKMONTHQUARTERYEAR
Notes
Phoenix provides a SQL interface to Apache HBase. The phoenixdb driver connects via the Phoenix Query Server and supports a subset of SQLAlchemy.