What users are saying about

1010data

5 Ratings

Apache Hive

63 Ratings

1010data

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

Apache Hive

63 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

1010data

The software is excellent for any application which is too large for Excel. The visual interface surpasses that of most SQL platforms. It is quite useful for data mining in an exploratory way but less useful in statistical and regression analysis.
Marc Gilbert profile photo

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

  • Crunches huge datasets
  • Has versatility in functionality and grouping capabilities
  • Native XML macro language is easy to master
  • The platform has great visualization tools
Marc Gilbert profile photo
  • 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.
No photo available

Cons

  • The ten.do interface could use more detailed documentation
Marc Gilbert profile photo
  • Use Hive for analytical work loads. Write once and read many scenarios. Do not prefer updates and deletes.
  • Behind scenes Hive creates map reduce jobs. Hive performance is slow compared to Apache Spark.
  • Map reduce writes the intermediate outputs to dial whereas Spark operates in in-memory and uses DAG.
No photo available

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

1010data8.0
Based on 1 answer
That's votes by our team.
Henry PAN profile photo
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

While we have used SQL, 1010data is really the only industry standard product available for our use.
Marc Gilbert profile photo
Hive is SQL compliant which makes it easy for the data folks compared to Pig
No photo available

Return on Investment

  • This has sped up the process of analysis.
  • We can now automate process which were performed manually.
  • Analysis can be performed more frequently.
Marc Gilbert profile photo
  • Hive Metastore is great as all other query engines plug into it. I'd tell the hive community to invest more into the metastore as it's one of the strong points of hive.
  • Overall, we first started with Hadoop, then Hive and then Presto. These are all core components of data in our business and it's highly critical for our business.
  • We use Hive extensively to compute daily/weekly reports which are essential to run the business.
Praveen Murugesan profile photo

Pricing Details

1010data

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