A SQL query engine over Apache HBase tables that supports a subset of SQL 92 (including joins), and comes with a JDBC driver. Supports a range of features including ACID transactions (via Apache Tephra), user defined functions, secondary indexes, atomic upserts, views, multi tenancy tables (where each user or tenant can only see their data) and dynamic columns (which are only specified at query time). Supports a range of SQL DDL commands, creating and modifying underlying HBase tables as required, or can run over existing HBase tables in a read only mode. Comes with connectors to allow Spark, Hive, Pig, Flume and MapReduce to read and write Phoenix tables, and a number of utilities, including a bulk loader and a command line SQL tool. Open sourced by SalesForce in January 2013 at v1.0, donated to the Apache foundation in December 2013, before graduating in May 2014. Commercial support available through Hortonworks as part of HDP, with Cloudera making it available via Cloudera Labs without support. Active project with a range of contributors, including many from SalesForce and Hortonworks.
Other Names Phoenix Vendors The Apache Software Foundation Type Commercial Open Source Last Updated July 2018 - v5.0
Is packaged by Apache Bigtop, Hortonworks Data Platform, Amazon EMR
version release date release links release comment 4.10 2017-03-23 announcement 4.11 2017-07-07 announcement 4.12 2017-10-11 announcement 4.13 2017-11-12 announcement 4.14 2018-06-12 announcement 5.0 2018-07-14 announcement Hadoop 3.0 and HBase 2.0 compatibility