Apache Hive vs. Presto

Apache Hive

95 Reviews and Ratings

Presto

18 Reviews and Ratings

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Apache Hive	Score8 out of 10	N/A	Apache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.	N/A
Presto	Score2.6 out of 10	N/A	Presto is an open source SQL query engine designed to run queries on data stored in Hadoop or in traditional databases. Teradata supported development of Presto followed the acquisition of Hadapt and Revelytix.	N/A

Pricing

Apache Hive

Presto

No answers on this topic

No answers on this topic

Pricing Offerings
Apache Hive	Presto
Free Trial
No	No
Free/Freemium Version
No	No
Premium Consulting/Integration Services
No	No

No setup fee

No setup fee

—

—

Community Pulse
Key User Insights
	Apache Hive	Presto
Considered Both Products	Apache Ananth Gouri Assistant Professor in Engineering at The National Institute of Engineering, Mysuru (Education Management, 501-1000 employees) Chose Apache Hive One of the major advantages of using Presto or the main reason why people use Presto (Teradata) is due to that fact it can support multiple data sources - which is lacking as in the case of Apache Hive. But still, most people who come from a Structured data-based background … Incentivized Helpful? Praveen Murugesan Engineering Manager - Ride Experience in Engineering at Uber (Internet, 5001-10,000 employees) Chose Apache Hive We selected Hive because it supports SQL, schema and provides structure on top of hadoop. Having data structured has its benefits, especially if there are thousands of users processing on the same data over and over again. Pig provides the ability to process unstructured data. … Incentivized Helpful? Verified User Chose Apache Hive Presto is slightly less reliable but much faster for interactive querying. These tools would not be replacements for each other, but rather complements. Incentivized Helpful? Verified User Chose Apache Hive Community support and ease of use -not deployment. It enables querying and analyzing large amounts of data stored in HDFS, on the petabyte scale. It has a query language called HQL that transforms SQL queries into MapReduce jobs that run on Hadoop, and it is wonderful for the … Incentivized Helpful? Verified User Chose Apache Hive Due to effective queries resolved time and the performance and user-friendly framework compared to other products. Incentivized Helpful? Jordan Moore Staff Consultant in Information Technology at Avalon Consulting, LLC (Information Technology and Services, 51-200 employees) Chose Apache Hive Hive was one of the first SQL on Hadoop technologies, and it comes bundled with the main Hadoop distributions of HDP and CDH. Since its release, it has gained good improvements, but selecting the right SQL on Hadoop technology requires a good understanding of the strengths and … Incentivized Helpful?	Open Source Praveen Murugesan Engineering Manager - Ride Experience in Engineering at Uber (Internet, 5001-10,000 employees) Chose Presto I think Presto is one of the best solutions out there today at the cutting edge for interactive query analysis. One of the challenges is presto is a niche tool for the interactive query use case and doesn't have the knobs and whistles as much as Spark. In the foreseeable future … Incentivized Helpful?
	Would buy again
	No answers on this topic	No answers on this topic
	Delivers good value for the price
	No answers on this topic	No answers on this topic
	Happy with the feature set
	No answers on this topic	No answers on this topic
	Lived up to sales and marketing promises
	No answers on this topic	No answers on this topic
	Implementation went as expected
No answers on this topic	No answers on this topic

TrustRadius Insights
	Apache Hive	Presto
Highlights	Research Team Insight Published August 21, 2020 Apache Hive and Presto are both analytics engines that businesses can use to generate insights and enable data analytics. Apache Hive is a data warehousing tool designed to easily output analytics results to Hadoop. In contrast, Presto is built to process SQL queries of any size at high speeds. Both tools are most popular with mid sized businesses and larger enterprises that perform a large volume of SQL queries. Features Apache Hive and Presto both enable organizations to perform queries on business data, but they also have some standout features that set them apart from each other. Apache Hive is designed to facilitate analytics on large amounts of data, while also providing storage for the results in the form of tables. Businesses using Hadoop will appreciate that Apache Hive is built on top of the Hadoop File System, making it easy to integrate Apache Hive into their existing infrastructure. Businesses will get the most out of Apache Hive if they are performing ad-hoc queries on large datasets. Presto is an open source sql query engine that can manage and run both simple, small queries, as well as large, complex queries. Businesses will appreciate that Presto can run queries at high speeds, making it a good choice for businesses that want to run a lot of queries without being delayed. It is worth noting, that for businesses using Hadoop that want the high query speed offered by Presto, it does include an integration with Apache Hive. Limitations Apache Hive and Presto are both popular choices for businesses seeking analytics engines, with some even using both, but they also have some limitations that are important to consider. Apache Hive provides excellent support for large datasets and businesses that use Hadoop, but it can’t run SQL queries as fast as Presto. Businesses looking for the fastest option available may need to consider other options. Additionally, Apache Hive includes built in support for Hadoop, but businesses using other tools will not be able to take advantage of those benefits. Presto provides fast support for SQL queries, but it doesn’t include built in support for the Hadoop File System, and requires other tools to function for that use case. Businesses looking for a quick solution that works with Hadoop out of the box may prefer Apache Hive. Additionally, businesses less concerned with scalability and maximum query speed may prefer the support for large datasets provided by Apache Hive. Pricing Apache Hive and Presto are both open source tools, so the source code for each one is available for free.

User Ratings
	Apache Hive	Presto
Likelihood to Recommend	8.0 (35 ratings)	7.8 (2 ratings)
Likelihood to Renew	10.0 (1 ratings)	- (0 ratings)
Usability	8.5 (7 ratings)	- (0 ratings)
Support Rating	7.0 (6 ratings)	- (0 ratings)