Apache Phoenix
 | |
| Developer(s) | Apache Software Foundation |
|---|---|
| Stable release | 4.8.1
/ 28 September 2016 |
| Repository | |
| Written in | Java |
| Operating system | Cross-platform |
| Type | SQL database |
| License | Apache License 2.0 |
| Website | 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]
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] and became a top-level Apache project on 22 May 2014.[4] Apache Phoenix is included in the Hortonworks distribution for HDP 2.1 and above,[5] is available as part of Cloudera labs,[6] and is part of the Hadoop ecosystem.[7]
See also
- Apache HBase
- Apache Hadoop
- Apache Accumulo
- Apache Cassandra
- Apache Hive
- Apache Drill
- Cloudera Impala
- Teradata
External links
- Official Apache Phoenix homepage
- Official Apache Phoenix blog
- Official Apache HBase homepage
- Official Apache Hadoop homepage
References
- ^ James Taylor. "Apache Phoenix Transforming HBase into a SQL database", HadoopSummit, 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.
- ^ Hortonworks. "Chapter 7. Installing Phoenix", Hortonworks, 2 July 2014.
- ^ Srikanth Srungarapu. "Apache Phoenix Joins Cloudera Labs", Cloudera, 6 May 2015.
- ^ Serdar Yegulalp. "10 ways to query Hadoop with SQL", "[1]", 16 September 2014.
