What users are saying about
8 Ratings
9 Ratings
8 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101
9 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.8 out of 101

Likelihood to Recommend

Hive

Hive is very well suited for those looking for a team communication app that has Kanban board support and you don't want to use two different apps for project management and communication. It fails a little bit when some of your team members or bosses don't have much time to read all emails, so we still haven't found a way for them to get only important notification emails.
No photo available

Presto

Presto is for interactive simple queries, where Hive is for reliable processing. If you have a fact-dim join, presto is great..however for fact-fact joins presto is not the solution.. Presto is a great replacement for proprietary technology like Vertica
Praveen Murugesan profile photo

Feature Rating Comparison

Project Management

Hive
7.0
Presto
Task Management
Hive
8.6
Presto
Resource Management
Hive
7.2
Presto
Gantt Charts
Hive
7.4
Presto
Scheduling
Hive
8.2
Presto
Workflow Automation
Hive
7.8
Presto
Team Collaboration
Hive
7.4
Presto
Support for Agile Methodology
Hive
7.7
Presto
Support for Waterfall Methodology
Hive
7.5
Presto
Document Management
Hive
8.3
Presto
Email integration
Hive
5.3
Presto
Mobile Access
Hive
5.7
Presto
Timesheet Tracking
Hive
5.7
Presto
Change request and Case Management
Hive
5.3
Presto
Budget and Expense Management
Hive
6.0
Presto

Professional Services Automation

Hive
5.5
Presto
Quotes/estimates
Hive
6.0
Presto
Invoicing
Hive
5.3
Presto
Project & financial reporting
Hive
5.7
Presto
Integration with accounting software
Hive
5.0
Presto

Pros

Hive

  • Very good design.
  • Google Drive and Dropbox integration.
  • Very easy to use. It does a great job with project organization.
No photo available

Presto

  • Fast - Presto, is incredibly fast due to its optimized query engine and is well suited for interactive analysis.
  • Flexible - Presto is highly flexible as it operates with a plug and play model for data sources. Joining and query across different data sources is very easy with presto (eg. HDFS, MySQL, Kafka).
  • ANSI Sql - Presto follows ANSI SQL which is the recognized SQL language and hence helps allow easy query migration without much overhead.
  • Large Fact + Small Dimension table joins made fast - By design presto excels most distributed query engines out there in this type of queries.
Praveen Murugesan profile photo

Cons

Hive

  • You can't move urgent actions to the top.
  • It takes a little too much time to load up on the desktop version.
  • There's definitely room for improvement in keyboard shortcuts.
No photo available

Presto

  • Presto was not designed for large fact fact joins. This is by design as presto does not leverage disk and used memory for processing which in turn makes it fast.. However, this is a tradeoff..in an ideal world, people would like to use one system for all their use cases, and presto should get exhaustive by solving this problem.
  • Resource allocation is not similar to YARN and presto has a priority queue based query resource allocation..so a query that takes long takes longer...this might be alleviated by giving some more control back to the user to define priority/override.
  • UDF Support is not available in presto. You will have to write your own functions..while this is good for performance, it comes at a huge overhead of building exclusively for presto and not being interoperable with other systems like Hive, SparkSQL etc.
Praveen Murugesan profile photo

Usability

Hive

Hive 9.0
Based on 1 answer
I love Hive so much because it has made a huge difference regarding team communication and project management at the same time. We experienced almost no bugs and in the few cases that we did have some trouble, the customer service team was very responsive and solved our problems very quickly.
No photo available

Presto

No score
No answers yet
No answers on this topic

Support

Hive

Hive 10.0
Based on 2 answers
We really had very little contact with the customer service team, because we only had a couple of different instances with bugs. In both cases, the team answered very quickly and solved our problems showing a great deal of expertise not only regarding our specific software situation but also were very kind.
No photo available

Presto

No score
No answers yet
No answers on this topic

Alternatives Considered

Hive

We used Microsoft Project for a very long time and, while we still consider it superior to Hive, it lacks a lot of Hive's features. Maybe it also can be one of its cons, because all of those features can increase bugs and load times. But Hive is a relatively new platform and I'm sure they'll overcome that as long as they keep on this trail.
No photo available

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 if they are able to make presto work without the need for Hive, solving all the gaps it could be game changing and can be a direct threat to spark
Praveen Murugesan profile photo

Return on Investment

Hive

  • Productivity improvement when some of your teammates are spread across the country.
  • Has saved us a ton of time due to how easy it has become to find the project you're looking for.
  • Tagging people to certain tasks lets you keep track of each others responsibilities.
No photo available

Presto

  • Presto has helped scale Uber's interactive data needs. We have migrated a lot out of proprietary tech like Vertica.
  • Presto has helped build data driven applications on its stack than maintain a separate online/offline stack.
  • Presto has helped us build data exploration tools by leveraging it's power of interactive and is immensely valuable for data scientists.
Praveen Murugesan profile photo

Pricing Details

Hive

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Presto

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison