--- 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) ![Aritra N.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Aritra N.") AN Aritra N. Senior Software Development Engineer in Test Mid-Market (51-1000 emp.) 2/25/2021 "Not very developer friendly" 2.5/5 What do you like best about Apache Phoenix? SQL like syntax is the only thing positive Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? Apache Phoenix is still very primitive and does not offer easy SQL syntaxes. The errors/ exceptions are hard to understand, and development is slow. Review collected by and hosted on G2.com. Recommendations to others considering Apache Phoenix: Do not expect much support from the community. Have created a ticket for over one and a half years and still it is unattended. Would have been great for the ticket to be solved as it would have solved a very common problem in big data loading into HBase tables via Apache Phoenix's Hadoop Map-Reduce program. Have provided detailed screenshots, steps to reproduce, etc. But when checked a few days ago, the ticket has not been picked up. Hence, I think it will be very painful for anyone to do advanced stuff with Apache Phoenix in the long run. Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? Was trying to process our OLTP big data store. The only benefits are the SQL-like syntaxes and the that it can talk to HBase easily. The most positive point is that HBase and Apache Phoenix go hand in hand and so it is fairly easy to integrate your HBase tables with Apache Phoenix. The upsert statements are also helpful and there is a handly Hadoop Map Reduce program that you can execute from your Java program to load gigabytes of data to your HBase tables. This Map Reduce feature is the most beneficial aspect I have found off of Apache Phoenix. Note that, you can also use the command line to do the same operation. Review collected by and hosted on G2.com. Show More 3/3/2021 Current UserValidated ReviewerIncentivizedSource: G2 invite ![Yashasvi D.](/assets/transparent-ad5be28fbcd25b7b08d2cebe1d957125437fb5407d75ee717965ad22c8808791.gif "Yashasvi D.") YD Yashasvi D. Software Developer - Advanced Enterprise (\> 1000 emp.) 12/8/2020 "Apache Phoenix : A dual edged sword for Apache HBase" 3/5 What do you like best about Apache Phoenix? Through documentation is available which makes it easy to start and setup. One gets to work with the comfortable SQL syntax without being bothered to crawl through HBase help docs for shell syntax. Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? Tables created from HBase shell have to be mapped separately in Phoenix. Bulk loading data to tables created via Phoenix is not as straight forward as for tables created from HBase shell. Apache Phoenix's capabilities depends heavily on HBase coprocessors making it tightly coupled to HBase Architecture, which is a challenge as Phoenix needs to be revamped with every Major release of Apache HBase, and due to this fact Apache Phoenix is less reliant in Production environment. Switching through Index (Global to Local and vice versa)on a table becomes a pain point. Integration with Apache Spark needs to be improved on. Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? HBase is the product is being used as Unique data repository, Apache Phoenix is used to perform Data Steward operation before being consumed by down stream system. 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 Enterprise (\> 1000 emp.) 1/25/2021 "Very good sql based data access for Apache HBase" 2.5/5 What do you like best about Apache Phoenix? Well documented and easy to start with SQL knowledge for Hbase Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? 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. What problems is Apache Phoenix solving and how is that benefiting you? time-series data stored in HBase will be accessed using apache phoenix for data analytics. Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Verified User in Financial Services](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Financial Services") UF Verified User in Financial Services Enterprise (\> 1000 emp.) 3/8/2021 "Apache Phoenix" 3/5 What do you like best about Apache Phoenix? 1.SQL Language 2.Secondary indexes 3.Hints Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? Performance of read queries when data is stored and accessed cross regions Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? I was trying to read data stored in Hbase in an optimal cost effective manner Review collected by and hosted on G2.com. Show More Validated ReviewerIncentivizedSource: G2 invite ![Verified User in Hospital & Health Care](/assets/icons/anonymous-avatar-purple-4ae1032bdb50ee5682003170c8184aee790d25958bd397abbd384ba52c596a7b.svg "Verified User in Hospital & Health Care") UH Verified User in Hospital & Health Care Enterprise (\> 1000 emp.) 4/13/2020 "Slow on spark" 2.5/5 What do you like best about Apache Phoenix? Best part is the ability to perfom sql on hbase Review collected by and hosted on G2.com. What do you dislike about Apache Phoenix? Cant handle huge volumes of data.Could see issues when loading spark dataframe into phoenix db Review collected by and hosted on G2.com. Recommendations to others considering Apache Phoenix: Best to query data Review collected by and hosted on G2.com. What problems is Apache Phoenix solving and how is that benefiting you? When trying to write into hbase from spark using hbase connector it expects the catalog to be pre defiend,since most of our code is a dynamic process,we opted for phoenix.But it takes time for huge volumes of data. 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 FTP client app for Windows is easy enough for a non-technical person to use reliably without reading documentation?](https://www.g2.com/discussions/what-ftp-client-app-for-windows-is-easy-enough-for-a-non-technical-person-to-use-reliably-without-reading-documentation)[What are the highest rated AR content management systems for interior and architectural designers accelerating project timelines?](https://www.g2.com/discussions/what-are-the-highest-rated-ar-content-management-systems-for-interior-and-architectural-designers-accelerating-project-timelines)[Which retail media advertising platforms have the best Amazon Marketing Cloud integration and advanced analytics for brands that want to go beyond last-click attribution?](https://www.g2.com/discussions/which-retail-media-advertising-platforms-have-the-best-amazon-marketing-cloud-integration-and-advanced-analytics-for-brands-that-want-to-go-beyond-last-click-attribution) [Which Google Workspace utilities simplify email delegation, permission changes, and account management for distributed teams?](https://www.g2.com/discussions/which-google-workspace-utilities-simplify-email-delegation-permission-changes-and-account-management-for-distributed-teams)[Which theater venue management platforms have the strongest operational case studies from major performing arts organizations?](https://www.g2.com/discussions/which-theater-venue-management-platforms-have-the-strongest-operational-case-studies-from-major-performing-arts-organizations)[What are the best food safety management software platforms for small teams managing tight timelines?](https://www.g2.com/discussions/what-are-the-best-food-safety-management-software-platforms-for-small-teams-managing-tight-timelines) [Show MoreShow Less](javascript:void(0);)