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]
 | |||||
| Developer(s) | Apache Software Foundation | ||||
|---|---|---|---|---|---|
| Initial release | 15 April 2014 | ||||
| Stable release |
| ||||
| Repository | Phoenix Repository | ||||
| Written in | Java, SQL | ||||
| Operating system | Cross-platform | ||||
| Type | SQL database | ||||
| License | Apache License 2.0 | ||||
| Website | phoenix | ||||
History
editPhoenix 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
editReferences
edit- ^ James Taylor. "Apache Phoenix Transforming HBase into a SQL database", HadoopSummit Archived 10 October 2016 at the Wayback Machine, 4 June 2014.
- ^ Istvan Szegedi. "Apache Phoenix – an SQL Driver for HBase", BigHadoop, 17 May 2014.
- ^ Abel Avram. "Phoenix: Running SQL Queries on Apache HBase", InfoQ, 31 January 2013.
- ^ Adam Seligman. "Apache Phoenix: A small step for big data", Salesforce.com Developer, 28 May 2014.
- ^ Cloudera. "Overview of Apache Phoenix". docs.cloudera.com. Archived from the original on 24 January 2021. Retrieved 10 February 2021.
- ^ Hortonworks. "Chapter 7. Installing Phoenix", Hortonworks, 2 July 2014.
- ^ Srikanth Srungarapu. "Apache Phoenix Joins Cloudera Labs" Archived 11 July 2015 at the Wayback Machine, Cloudera, 6 May 2015.
- ^ Serdar Yegulalp. "10 ways to query Hadoop with SQL", "[1]", 16 September 2014.