Apache Phoenix
{{Short description|Relational database engine for Apache Hadoop}}
{{Use dmy dates|date=December 2020}}
{{Infobox software
| name = Apache Phoenix
| logo = Apache Phoenix logo.svg
| screenshot =
| caption =
| developer = Apache Software Foundation
| released = {{Start date and age|df=yes|2014|04|15}}
| latest release version = {{Multiple releases
|branch1 = 4.x
|version1 = 4.16.1
|date1 = {{Start date and age|df=yes|2021|05|22}}
|branch2 = 5.x
|version2 = 5.2.1
|date2 = {{Start date and age|df=yes|2024|11|12}}
}}
| latest release date =
| latest preview version =
| latest preview date =
| operating system = Cross-platform
| repo = {{URL|https://gitbox.apache.org/repos/asf?p{{=}}phoenix.git|Phoenix Repository}}
| programming language = Java, SQL
| genre = SQL database
| license = Apache License 2.0
| website = {{URL|http://phoenix.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.James Taylor. [https://www.youtube.com/watch?v=f4Nmh5KM6gI "Apache Phoenix Transforming HBase into a SQL database"], [http://hadoopsummit.org/ HadoopSummit] {{Webarchive|url=https://web.archive.org/web/20161010022924/http://hadoopsummit.org/ |date=10 October 2016 }}, 4 June 2014. 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.Istvan Szegedi. [http://bighadoop.wordpress.com/2014/05/17/apache-phoenix-an-sql-driver-for-hbase/ "Apache Phoenix – an SQL Driver for HBase"], [http://bighadoop.wordpress.com/ BigHadoop], 17 May 2014.
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 GitHubAbel Avram. [http://www.infoq.com/news/2013/01/Phoenix-HBase-SQL "Phoenix: Running SQL Queries on Apache HBase"], [http://www.infoq.com/ InfoQ], 31 January 2013. on 28 Jan 2014 and became a top-level Apache project on 22 May 2014.Adam Seligman. [https://developer.salesforce.com/blogs/developer-relations/2014/05/apache-phoenix-small-step-big-data.html "Apache Phoenix: A small step for big data"], [https://developer.salesforce.com/ Salesforce.com Developer], 28 May 2014. Apache Phoenix is included in the Cloudera Data Platform 7.0 and above,{{Cite web|last=Cloudera|date=|title=Overview of Apache Phoenix|url=https://docs.cloudera.com/cdp-private-cloud-base/7.1.5/phoenix-overview/topics/phoenix-overview.html|url-status=live|archive-url=https://web.archive.org/web/20210124174536/https://docs.cloudera.com/cdp-private-cloud-base/7.1.5/phoenix-overview/topics/phoenix-overview.html |archive-date=24 January 2021 |access-date=2021-02-10|website=docs.cloudera.com}} Hortonworks distribution for HDP 2.1 and above,Hortonworks. [http://docs.hortonworks.com/HDPDocuments/HDP2/HDP-2.1.3/bk_installing_manually_book/content/rpm-chap-phoenix.html "Chapter 7. Installing Phoenix"], [http://hortonworks.com/ Hortonworks], 2 July 2014. is available as part of Cloudera labs,Srikanth Srungarapu. [http://blog.cloudera.com/blog/2015/05/apache-phoenix-joins-cloudera-labs "Apache Phoenix Joins Cloudera Labs"] {{Webarchive|url=https://web.archive.org/web/20150711143900/http://blog.cloudera.com/blog/2015/05/apache-phoenix-joins-cloudera-labs/ |date=11 July 2015 }}, [http://www.cloudera.com/ Cloudera], 6 May 2015. and is part of the Hadoop ecosystem.Serdar Yegulalp. [http://www.infoworld.com/article/2683729/hadoop/10-ways-to-query-hadoop-with-sql.html "10 ways to query Hadoop with SQL"], "[http://www.infoworld.com/blog/infoworld-tech-watch/]", 16 September 2014.
See also
<span lang="Rel" dir="ltr">References</span>
{{Reflist}}
External links
- [http://phoenix.apache.org/ Official Apache Phoenix homepage]
- [http://blogs.apache.org/phoenix/ Official Apache Phoenix blog]
{{Apache Software Foundation}}
Category:Relational database management systems
Category:Free software programmed in Java (programming language)