Apache Phoenix Reviews & Product Details

Pheonix can actually create a layer of abstraction to hide the complexity. Review collected by and hosted on G2.com.

The lack of a GUI intruder to visualise and create an architectecture diagram. Review collected by and hosted on G2.com.

Well documented and easy to start with SQL knowledge for Hbase Review collected by and hosted on G2.com.

Always we need to create ddl in Apache phoenix and mapping from Hbase to access if we why the possibility to auto table creation with the hbase connection detail would be great. Review collected by and hosted on G2.com.

1.SQL Language

2.Secondary indexes

3.Hints Review collected by and hosted on G2.com.

Performance of read queries when data is stored and accessed cross regions Review collected by and hosted on G2.com.

I found Apache Phoenix very helpful in a Project where we shifted from SQL database to NoSQL database (HBase). So existing application was totally running on SQL queries and we wanted keep same interface for same SQL queries over HBase. Review collected by and hosted on G2.com.

Some of the syntax was not easily available. Had to try configurations to fit into our application. Review collected by and hosted on G2.com.

The only thing likable in Apache Phoenix is its SQL like feature Review collected by and hosted on G2.com.

Difficult to quickly write query, unnecessary requirement for single and double quotes. Review collected by and hosted on G2.com.

Response time for large data tables and flexibility to create external index,SQL interface Review collected by and hosted on G2.com.

Limited options on metadata, few abnormal index behaviour observed at higher environment Review collected by and hosted on G2.com.

Ability to create various views on top of hbase tables and performance improvements over Hive Review collected by and hosted on G2.com.

Query performance when multiple joins/ deeply nested queries are executed needs to be improved Review collected by and hosted on G2.com.

It provides an SQL interface to HBase. It is like an SQL layer on top of HBase architecture. It maps HBase data model to the relational world. Somewhat better than HIVE Review collected by and hosted on G2.com.

Some limitation of features in older versions like Limit keyword. Review collected by and hosted on G2.com.

Apache phoenix have helped us to integrate our hbase store with spark engine and also provided solution for region hotspot issues Review collected by and hosted on G2.com.

Integration with Kerberos and installation Review collected by and hosted on G2.com.

Apache Phonenix makes it very easy to query Hbase which is No sqp database. Review collected by and hosted on G2.com.

Sometimes the errors which we get are not properly stated by Phoenix . Hence it becomes difficult to debug the issue. Review collected by and hosted on G2.com.