Apache Phoenix

From Wikipedia, the free encyclopedia

Apache Phoenix
Developer(s)Apache Software Foundation
Initial release15 April 2014; 8 years ago (2014-04-15)
Stable release
4.x4.16.1 / 22 May 2021; 22 months ago (2021-05-22)
5.x5.1.2 / 8 June 2021; 21 months ago (2021-06-08)
RepositoryPhoenix Repository
Written inJava, SQL
Operating systemCross-platform
TypeSQL database
LicenseApache License 2.0

Apache Phoenix is an open source, massively parallel, relational database engine supporting OLTP for Hadoop using Apache HBase as its backing store. Phoenix provides a JDBC driver that hides the intricacies of the NoSQL store enabling users to create, delete, and alter SQL tables, views, indexes, and sequences; insert and delete rows singly and in bulk; and query data through SQL.[1] Phoenix compiles queries and other statements into native NoSQL store APIs rather than using MapReduce enabling the building of low latency applications on top of NoSQL stores.[2]


Phoenix began as an internal project by the company salesforce.com out of a need to support a higher level, well understood, SQL language. It was originally open-sourced on GitHub[3] on 28 Jan 2014 and became a top-level Apache project on 22 May 2014.[4] Apache Phoenix is included in the Cloudera Data Platform 7.0 and above,[5] Hortonworks distribution for HDP 2.1 and above,[6] is available as part of Cloudera labs,[7] and is part of the Hadoop ecosystem.[8]

See also[edit]


  1. ^ James Taylor. "Apache Phoenix Transforming HBase into a SQL database", HadoopSummit Archived 10 October 2016 at the Wayback Machine, 4 June 2014.
  2. ^ Istvan Szegedi. "Apache Phoenix – an SQL Driver for HBase", BigHadoop, 17 May 2014.
  3. ^ Abel Avram. "Phoenix: Running SQL Queries on Apache HBase", InfoQ, 31 January 2013.
  4. ^ Adam Seligman. "Apache Phoenix: A small step for big data", Salesforce.com Developer, 28 May 2014.
  5. ^ Cloudera. "Overview of Apache Phoenix". docs.cloudera.com. Archived from the original on 24 January 2021. Retrieved 10 February 2021.
  6. ^ Hortonworks. "Chapter 7. Installing Phoenix", Hortonworks, 2 July 2014.
  7. ^ Srikanth Srungarapu. "Apache Phoenix Joins Cloudera Labs" Archived 11 July 2015 at the Wayback Machine, Cloudera, 6 May 2015.
  8. ^ Serdar Yegulalp. "10 ways to query Hadoop with SQL", "[1]", 16 September 2014.

External links[edit]