What users are saying about

Amazon EMR

24 Ratings

Apache Hive

62 Ratings

Amazon EMR

24 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.3 out of 101

Apache Hive

62 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.1 out of 101

Add comparison

Likelihood to Recommend

Amazon EMR

If you don't have big data ..i.e petabytes of data with terabytes of data generating every day, then don't use Hadoop. Relational databases are enough for terabytes of data. Hadoop is not well suited for transactional systems or data.
No photo available

Apache Hive

Apache Hive shines for ad-hoc analysis and plugging into BI tools. Its SQL-like syntax allows for ease of use not for only for engineers but also for data analysts. Through our experience, there are probably more desirable tools to use if you are planning on integrating Hive into your processing pipeline.
No photo available

Pros

  • Ease of use and ease to setup
  • Autoscaling functionality
  • Integrated into the AWS environment
No photo available
  • It's Fast!
  • You can store a different kind of data structures here other than the standard ones
  • Good scalability
  • Good redundancy too
No photo available

Cons

  • Cost overhead is a bit high
  • Limited versions of frameworks that can be used
No photo available
  • Hive doesn't support many features that traditional RDBMS SQL has; so it may not be an easier transformation as one would presume.
  • Being OpenSource, it has its share of problems and lack of support; need to explore community groups to get some clarifications if you are not using any of the big distribution providers like Cloudera or HW.
  • Hive is comparatively slower than its competitors. It's easy to use but that comes with the cost of processing. If you are using it just for batch processing then Hive is well and fine.
Bharadwaj (Brad) Chivukula profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Apache Hive10.0
Based on 1 answer
Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.
Yinghua Hu profile photo

Usability

No score
No answers yet
No answers on this topic
Apache Hive9.0
Based on 1 answer
Hive's support SQL like queries improves its usability since almost every potential user of Hive would have had experience with SQL.
Tom Thomas profile photo

Alternatives Considered

The alternatives to EMR are mainly hadoop distributions owned by the 3 companies above. I have not used the other distributions so it is difficult to comment, but the general tradeoff is, at the cost of a longer setup time and more infra management, you get more flexible versioning and potentially faster access to newer versions of some frameworks such as Spark.
No photo available
Hive is SQL compliant which makes it easy for the data folks compared to Pig
No photo available

Return on Investment

  • It was easy to set up initial versions of Spark on this
  • Still used as our compute platform as its easy to manage
  • Certain times we forgot to shut down clusters and were overcharged
No photo available
  • Reduced learning curve for new trainees and users
  • Support for other client server databases provided improved compatibility of systems
Tom Thomas profile photo

Pricing Details

Amazon EMR

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

Apache Hive

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