Apache Phoenix
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
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
References
- 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", "", 16 September 2014.