Software:Apache Phoenix

From HandWiki
Short description: Relational database engine for Apache Hadoop
Apache Phoenix
Apache Phoenix logo.svg
Developer(s)Apache Software Foundation
Initial release15 April 2014; 9 years ago (2014-04-15)
Stable release
4.x4.16.1 / 22 May 2021; 2 years ago (2021-05-22)
5.x5.1.2 / 8 June 2021; 2 years ago (2021-06-08)
RepositoryPhoenix Repository
Written inJava, SQL
Operating systemCross-platform
TypeSQL database
LicenseApache License 2.0
Websitephoenix.apache.org

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] 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

External links