Apache_Phoenix

Apache Phoenix

Apache Phoenix

Relational database engine for Apache Hadoop

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]

Quick Facts Developer(s), Initial release ...

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

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

This article uses material from the Wikipedia article Apache_Phoenix, and is written by contributors. Text is available under a CC BY-SA 4.0 International License; additional terms may apply. Images, videos and audio are available under their respective licenses.