--- title: Apache Phoenix Reviews meta\_title: 'Apache Phoenix Reviews 2026: Details, Pricing, & Features | G2' meta\_description: Filter 27 reviews by the users' company size, role or industry to find out how Apache Phoenix works for a business like yours. aggregate\_rating: rating\_value: 3.7 review\_count: 27 scale: '5' date\_modified: '2026-08-09' parent\_category: name: Database Software url: https://www.g2.com/categories/database-software --- # Apache Phoenix Reviews & Product Details Apache Phoenix is an open source, massively parallel, relational database engine supporting OLTP for Hadoop using Apache HBase as its backing store. * * * Seller [The Apache Software Foundation](https://www.g2.com/sellers/the-apache-software-foundation) Discussions [Apache Phoenix Community](https://www.g2.com/products/apache-phoenix/discuss) Show More ## Top-Rated Alternatives [ ![MySQL](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "MySQL") MySQL 4.4/5(1,682) ](https://www.g2.com/products/mysql/reviews) [ ![Microsoft SQL Server](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Microsoft SQL Server") Microsoft SQL Server 4.4/5(2,286) ](https://www.g2.com/products/microsoft-sql-server/reviews) [ ![PostgreSQL](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "PostgreSQL") PostgreSQL 4.4/5(684) ](https://www.g2.com/products/postgresql/reviews) [ View All Alternatives ](https://www.g2.com/products/apache-phoenix/competitors/alternatives) ## User Insights Average based on 27 real user reviews. [Log in to unlock pricing and user insights](/login) ![Clif K.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Clif K.") CK Clif K. Mid-Market (51-1000 emp.) 1/9/2021 "Apache Phoenix is the fastest way to use SQL to access data in HBase" 4.5/5 What do you like best about Apache Phoenix? Apache Phoenix provides access to data that's stored in HBase which is a column oriented database. HBase doesn't natively support SQL or really any query language. The HBase shell has a scan command for accessing data but I find it extremely awkward to use. Phoenix "puts the SQL back in NoSQL" so that means if you know SQL you can query data in HBase using a language you know. While there are multiple ways to access data in HBase through SQL including Apache Hive, Impala and Drill, I think Apache Phoenix has a better design than any of the alternatives. Unlike most relational databases that require schema design before you can add data, HBase is essentially schemaless. However all of these tools require a schema, so that means in order to use them you have to fist map the fields in HBase (at least the ones you want to use) to a metadata layer. Hive/Impala, Drill and Phoenix each do this in their own unique way, but I think the way you do this in Phoenix is the most logical. Also in my experience Phoenix provides better throughput than any of the alternatives because it converts SQL queries into HBase scans. Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? You do have to create the Phoenix schema manually. Unlike the alternatives Phoenix can only access data stored in HBase, so if you want to combine data from different data sources, such as CSV or JSON files you need to use something else. Review collected by and hosted on G2.com. Recommendations to others considering Apache Phoenix: Remember one thing: even though Apache Phoenix makes HBase look like a relational database it does not turn it into one. Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? Providing access to business intelligence tools for data in HBase through JDBC. This makes HBase data appear the same as data in relational databases. Data in HBase can be combined with other data sources. Review collected by and hosted on G2.com. Show More Current UserValidated ReviewerIncentivizedSource: G2 invite ![Verified User in Retail](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Retail") UR Verified User in Retail Enterprise (\> 1000 emp.) 4/28/2020 "Apache Phoenix: A very powerful tool to deal with hbase" 4.5/5 What do you like best about Apache Phoenix? It helped me a lot in dealing with Hbase data. As i can't directly execute sql query on HBase, it enabled me to execute sql like query to deal with data. Also the support was easily available on internet if i get stuck somewhere. Configuring it with the application and setting it up was also very easy. It made the work with large amount of data very easy without any performance issue. Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? At one side it's strong point is that enables query execution and on the other side it's limitation is also with query. As it doesn't support update command in starting i faced a lot of issue. Upsert command is there but still in many scenarios i faced much difficulty to properly execute it. If we can have update command in this it would be a very good point so this can be improved. Review collected by and hosted on G2.com. Recommendations to others considering Apache Phoenix: It's a good tool to interact with Hbase. If you are using HBase in your application then i will say for sure you should go with Apache Phoenix. It will make your work a lot easier. Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? I am using it to interact with Hbase and handle large amount of data for our application. It makes the work easier which in absence of phoenix would be very difficult. Review collected by and hosted on G2.com. Show More 10/20/2020 Validated ReviewerIncentivizedSource: G2 invite ![Verified User in Retail](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Retail") UR Verified User in Retail Mid-Market (51-1000 emp.) 4/1/2020 Business partner of the seller or seller's competitor, not included in G2 scores. "Advance user of Apache Phoenix - Enterprise domain architect review" 4.5/5 What do you like best about Apache Phoenix? We use hortonworks with hbase as our back end system. we have Apache phoenix on top of it , which is used by our BI team. Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? Using ETL tools for more transformations, its not that easy as typical MSSQL Servers Review collected by and hosted on G2.com. Recommendations to others considering Apache Phoenix: If you have hbase then Apache phoenix is very good combination. Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? We have huge data - data keeps coming every day ( 10 to 20 GB of data ),is that it provides access to HBase using an interface that most programmers are familiar with, namely JDBC Review collected by and hosted on G2.com. Show More 1/25/2021 Validated ReviewerIncentivizedSource: G2 invite ![Subhankar B.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Subhankar B.") SB Subhankar B. Senior Technical Consultant Enterprise (\> 1000 emp.) 11/29/2020 Business partner of the seller or seller's competitor, not included in G2 scores. "I worked apache Phoenix on top of HBase while working on Spark" 4.5/5 What do you like best about Apache Phoenix? We can use SQl operations without knowing hbase query syntax. Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? The Phoenix JDBC driver normalizes column names, but the Phoenix-Spark integration does not perform this operation while loading data from Phoenix Table. Review collected by and hosted on G2.com. Recommendations to others considering Apache Phoenix: I will recommend Apache Phoenix who would like to integrate apache hbase with spark. Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? We have used apache Phoenix on top of hbase ,for that we didn't require to write hbase query simple sql query was efficient. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Rajat T.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Rajat T.") RT Rajat T. Data Scientist Enterprise (\> 1000 emp.) 7/23/2020 "Great help in migrating application from SQL to NoSQL seamlessly." 5/5 What do you like best about Apache Phoenix? 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. What do you dislike about Apache Phoenix? 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. Recommendations to others considering Apache Phoenix: The tool is useful and solves the purpose. The only thing is setting the configurations correctly and setting up JDBC connection and less availability of syntax and use-cases on google. Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? Run SQL queries on top of HBase. We successfully managed to migrate our application using Apache Phoenix. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Adithya K.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Adithya K.") AK Adithya K. Data Engineering | Data Analytics | MIS Expert Mid-Market (51-1000 emp.) 7/17/2020 "Performance benefits by creating views over hbase tables" 4.5/5 What do you like best about Apache Phoenix? Ability to create various views on top of hbase tables and performance improvements over Hive Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? Query performance when multiple joins/ deeply nested queries are executed needs to be improved Review collected by and hosted on G2.com. Recommendations to others considering Apache Phoenix: Understand your use case and decide on the framework to be used Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? Creating views on HBase tables and building aggregated tables on top of them and get insightful analysis of data. The performance of the queries are high compared to the hive on HBase and is highly scalable Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Ankit A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Ankit A.") AA Ankit A. Python Developer Enterprise (\> 1000 emp.) 7/21/2020 Business partner of the seller or seller's competitor, not included in G2 scores. "Querying HBase" 4.5/5 What do you like best about Apache Phoenix? 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. What do you dislike about Apache Phoenix? Some limitation of features in older versions like Limit keyword. Review collected by and hosted on G2.com. Recommendations to others considering Apache Phoenix: NA Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? We had a scenario where we had to read data from Hbase. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Neha A.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Neha A.") NA Neha A. Consultant Enterprise (\> 1000 emp.) 4/1/2020 "Ease of use" 4.5/5 What do you like best about Apache Phoenix? Apache Phonenix makes it very easy to query Hbase which is No sqp database. Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? 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. What problems is Apache Phoenix solving and how is that benefiting you? We are building a data lake and storing data in Hbase for Reproting Layer. We use Phonenix to build dashboard queries which helps us query no SQL database as a SQL interface Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Verified User in Information Technology and Services](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Information Technology and Services") UI Verified User in Information Technology and Services Small-Business (50 or fewer emp.) 7/14/2020 Business partner of the seller or seller's competitor, not included in G2 scores. "Best engine for big data" 5/5 What do you like best about Apache Phoenix? You can directly get the views from HBase tables. Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? Not lot of examples and sample videos or tutorials available online. Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? Reading data faster than regular Big data SQL. Fast and less memory consuming with low latency. Review collected by and hosted on G2.com. Show More 7/20/2020 Validated ReviewerSource: Seller invite ![Varun S.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Varun S.") VS Varun S. Data Engineer Computer Software Enterprise (\> 1000 emp.) 3/15/2019 "Apache Phoenix SQL on NoSQL" 5/5 What do you like best about Apache Phoenix? Apache Phoenix provides a great virtualization layer on Apache Hbase which is primarily a NoSQL database. It provides capabilities of transforming SQL queries into native Hbase API calls. It also supports parallel processing which makes data retrieval super efficient. It has other advantages like supporting secondary indexes and query optimizations along with providing stats on the query. It does a read-only view on Hbase so there's no additional storage needed. Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? Some of the limitations are it's still relatively new and no major online forums available for knowledge sharing. And there are some limitations for apache spark connectors. Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? This enables the business to have SQL like capabilities on Hbase data to make important business decisions. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ##### Pricing Pricing details for this product isn’t currently available. Visit the vendor’s website to learn more. [ View More Pricing Information ](https://www.g2.com/products/apache-phoenix/pricing) Apache Phoenix Comparisons ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_5f138cb8b255acf37ef126e6e9072788/apache-kudu.jpg "Product Avatar Image") Apache Kudu 4.1/5(13) [ Compare Now ](https://www.g2.com/compare/apache-kudu-vs-apache-phoenix) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_240340edca859994ec71e4490aa20022/mysql.png "Product Avatar Image") MySQL 4.4/5(1,682) [ Compare Now ](https://www.g2.com/compare/apache-phoenix-vs-mysql) ![Product Avatar Image](https://images.g2crowd.com/uploads/product/image/small_square/small_square_eb5a3f53f09daab3e54a6f0ac5e8b90d/druid.png "Product Avatar Image") Druid 4.3/5(31) [ Compare Now ](https://www.g2.com/compare/apache-phoenix-vs-druid) ## Work at The Apache Software Foundation? Claim this profile to respond to reviews, update product info, and reach in-market buyers. [ Claim this profile ](https://www.g2.com/products/apache-phoenix/claim_requests/new?utm_medium=profile-footer-claim-cta&utm_source=g2) ##### Categories on G2 [Relational Databases](https://www.g2.com/categories/relational-databases)[Other Analytics](https://www.g2.com/categories/other-analytics) ##### Explore More [What platform integrates PDF editing with cloud storage systems?](https://www.g2.com/discussions/what-platform-integrates-pdf-editing-with-cloud-storage-systems)[What's the leading collaboration app for remote teams](https://www.g2.com/discussions/what-s-the-leading-collaboration-app-for-remote-teams)[Which background check platforms have the fastest turnaround and simplest ordering process so HR does not have to chase down results or navigate a clunky portal?](https://www.g2.com/discussions/which-background-check-platforms-have-the-fastest-turnaround-and-simplest-ordering-process-so-hr-does-not-have-to-chase-down-results-or-navigate-a-clunky-portal%20) [Which recognition platforms actually help reduce manual admin work for HR teams running recognition programs at scale?](https://www.g2.com/discussions/which-recognition-platforms-actually-help-reduce-manual-admin-work-for-hr-teams-running-recognition-programs-at-scale)[Which PR analytics platforms have sentiment analysis that actually reflects how your audience feels rather than just counting mentions as positive or negative at random?](https://www.g2.com/discussions/which-pr-analytics-platforms-have-sentiment-analysis-that-actually-reflects-how-your-audience-feels-rather-than-just-counting-mentions-as-positive-or-negative-at-random)[What are the highest rated desktop publishing platforms for non-technical marketers who need to build professional collateral fast?](https://www.g2.com/discussions/what-are-the-highest-rated-desktop-publishing-platforms-for-non-technical-marketers-who-need-to-build-professional-collateral-fast) [Show MoreShow Less](javascript:void(0);)