What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
100 Ratings

Apache Hive

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
100 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
38 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100

Attribute Ratings

  • IBM Analytics Engine is rated higher in 1 area: Likelihood to Recommend

Likelihood to Recommend

8.3

Apache Hive

83%
37 Ratings
8.7

IBM Analytics Engine

87%
10 Ratings

Likelihood to Renew

10.0

Apache Hive

100%
1 Rating

IBM Analytics Engine

N/A
0 Ratings

Usability

8.7

Apache Hive

87%
8 Ratings

IBM Analytics Engine

N/A
0 Ratings

Support Rating

7.2

Apache Hive

72%
7 Ratings

IBM Analytics Engine

N/A
0 Ratings

Likelihood to Recommend

Apache Hive

Software work execution is on a large scale, it is good to use for new projects or organizational changes, data lineage mapping has always been dubious but this one has had good results. You can store and synchronize data from different departments, the storage process can be manual but it is best automated.
Camilo Palacios | TrustRadius Reviewer

IBM Analytics Engine

  • Well suited for my big data related project or a static data set analysis especially for uploading huge dataset to the cluster.
  • But had some issues with connecting IoT real-time data and feeding to Power BI. It might be my understanding please take it as a mere comment rather than a suggestion.
Prasanna Nattuthurai | TrustRadius Reviewer

Pros

Apache Hive

  • Apache Hive allows use to write expressive solutions to complex problems thanks to its SQL-like syntax.
  • Relatively easy to set up and start using.
  • Very little ramp-up to start using the actual product, documentation is very thorough, there is an active community, and the code base is constantly being improved.
Anonymous | TrustRadius Reviewer

IBM Analytics Engine

  • It integrates easily with other IBM Watson Data Platform services thus improving collaboration.
  • The use of object storage helps to protect data and improve availability.
  • Users can spin up Hadoop and Spark clusters within minutes and manage them from a single point of control.
Christopher Parker | TrustRadius Reviewer

Cons

Apache Hive

  • Some queries, particularly complex joins, are still quite slow and can take hours
  • Previous jobs and queries are not stored sometimes
  • Switching to Impala can sometimes be time-consuming (i.e. the system hangs, or is slow to respond).
  • Sometimes, directories and tables don't load properly which causes confusion
Anonymous | TrustRadius Reviewer

IBM Analytics Engine

  • I find most of the functions user friendly and most importantly best fits in multi business setup and users easily adapt to the system. Also, you get a lot done in a very short period of time.
Anonymous | TrustRadius Reviewer

Pricing Details

Apache Hive

General

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

Starting Price

IBM Analytics Engine

General

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

Starting Price

Likelihood to Renew

Apache Hive

Apache Hive 10.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 | TrustRadius Reviewer

IBM Analytics Engine

No score
No answers yet
No answers on this topic

Usability

Apache Hive

Apache Hive 8.7
Based on 8 answers
Thanks to its high usability Apache Hive enables users to craft extensive queries really efficiently and at the same time to how to hold response times very low. HiveQL simplicity makes it super easy to manage large datasets, what was almost an impossible task before introduction of Apache Hive data warehousing platform in our company.
Anonymous | TrustRadius Reviewer

IBM Analytics Engine

No score
No answers yet
No answers on this topic

Support Rating

Apache Hive

Apache Hive 7.2
Based on 7 answers
Apache Hive is a FOSS project and its open source. We need not definitely comment on anything about the support of open source and its developer community. But, it has got tremendous developer support, awesome documentation. I would justify the fact that much support can be gathered from the community backup.
Ananth Gouri | TrustRadius Reviewer

IBM Analytics Engine

No score
No answers yet
No answers on this topic

Alternatives Considered

Apache Hive

Apache Hives is a very effective tool. In contrast, we wanted our data warehouse to be the location for our file system data. We also wanted to avoid using Postgres. It's great for keeping track of logs when working on big data projects. It's very similar to SQL in how it works. Even though HQL has a limited command set, it can still be helpful. It provides a fantastic open-source MapReduce implementation.
Orin Mamun | TrustRadius Reviewer

IBM Analytics Engine

IBM Analytics is a great tool and a welcome addition to your overall IBM strategy. I think in cases of tools like this, you either go with what your platform works best with or you go completely different with a 3rd party, like Snowflake. We are an Azure shop and just happened to have a division on IBM and wanted to give it a try. Performance-wise it stacks up against the other platform-specific tools, so you should feel comfortable when your data strategy tips in favor of needing more organization.
Anonymous | TrustRadius Reviewer

Return on Investment

Apache Hive

  • Apache hive is secured and scalable solution that helps in increasing the overall organization productivity.
  • Apache hive can handle and process large amount of data in a sufficient time manner.
  • It simplifies writing SQL queries, hence helping the organization as most companies use SQL for all query jobs.
Anonymous | TrustRadius Reviewer

IBM Analytics Engine

  • The cost to implement was definitely a plus when it came to choosing the IBM Analytics Engine.
  • While sufficient, the overall support received from IBM was less than that for which we had planned.
  • We were able to separate storage and computing while paving the way for easier cluster administration.
Anonymous | TrustRadius Reviewer

Add comparison