Apache Phoenix

Apache Phoenix

What is Apache Phoenix?

Apache Phoenix is an SQL skin for interactive queries on HBase. It compiles SQL queries into a series of HBase scans and produces JDBC result sets.

Apache Phoenix is open source software that makes the NoSQL database HBase usable like a relational database. It provides standard SQL, the JDBC API, ACID transactions, and other features.

Keep in mind that Phoenix must either be built from scratch or maintain a mapped schema on existing HBase tables. Phoenix also does not support some features, including full transaction support, derived tables, some relational operators such as Intersect and Minus, and other built-in functions, although these can be added manually. The project is mainly maintained by Salesforce, Intel, and Hortonworks.

Official Site

https://phoenix.apache.org

GitHub

https://github.com/apache/phoenix