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 in native noSQL store APIs rather than using MapReduceenabling 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 has Higher Level, well Understood, SQL language. Originally It was open-sourced it GitHub [3] and est devenu a top-level Apache project is 22 May 2014. [4] Apache Phoenix is included in the Hortonworks distribution for HDP 2.1 and above, [5] is available as share 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

References

  1. Jump up^ James Taylor. “Apache Phoenix Transforming HBase into a SQL database”, HadoopSummit , 4 June 2014.
  2. Jump up^ Istvan Szegedi. “Apache Phoenix – an SQL Driver for HBase”, BigHadoop , 17 May 2014.
  3. Jump up^ Abel Avram. “Phoenix: Running SQL Queries on Apache HBase”, InfoQ , 31 January 2013.
  4. Jump up^ Adam Seligman. “Apache Phoenix: A small step for big data”, Salesforce.com Developer , 28 May 2014.
  5. Jump up^ Hortonworks. “Chapter 7. Installing Phoenix”, Hortonworks , 2 July 2014.
  6. Jump up^ Srikanth Srungarapu. “Apache Joins Cloudera Phoenix Labs”, Cloudera , May 6, 2015.
  7. Jump up^ Serdar Yegulalp. “10 ways to query Hadoop with SQL”, “[1]”, 16 September 2014.

Leave a Reply

Your email address will not be published. Required fields are marked *