What users are saying about
70 Ratings
Top Rated
103 Ratings
70 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 100
Top Rated
103 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100

Likelihood to Recommend

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.
Anonymous | TrustRadius Reviewer

Google BigQuery

BigQuery is unlike anything we've used as a big data tool. It is perfectly suited to query large data sets quickly and to store those large data sets for any time use. It's perfect for storing data and using it for reports. Logging data is the perfect application for BigQuery, but transactional data is possible as well
Tristan Dobbs | TrustRadius Reviewer

Feature Rating Comparison

Database-as-a-Service

Apache Hive
Google BigQuery
9.0
Automatic software patching
Apache Hive
Google BigQuery
9.3
Database scalability
Apache Hive
Google BigQuery
9.3
Automated backups
Apache Hive
Google BigQuery
8.7
Database security provisions
Apache Hive
Google BigQuery
8.9
Monitoring and metrics
Apache Hive
Google BigQuery
8.8
Automatic host deployment
Apache Hive
Google BigQuery
9.0

Pros

Apache Hive

  • Hive syntax is almost like SQL, so for someone already familiar with SQL it takes almost no effort to pick up Hive.
  • To be able to run map reduce jobs using json parsing and generate dynamic partitions in parquet file format.
  • Simplifies your experience with Hadoop especially for non-technical/coding partners.
Bharadwaj (Brad) Chivukula | TrustRadius Reviewer

Google BigQuery

  • How many pros can a person type? This storage program gives workers and students the reality of unlimited storage space. I have never came close to overfilling my google cloud storage because it's huge and the best. I can view anything I save on there from any of my internet devices which is very important.
  • Depending on how you have the program set up - either online or through an application that lives on your desktop, dragging and dropping files to and from Cloud Storage couldn't be any more uncomplicated. Plus, new users who meet certain criteria - like updating personal security, or share the program receive additional free online storage.
  • The array of tools is very impressive, intuitive to use, and well organized in the sense that you don't have to go looking for individual apps. They're all easily accessed via a single dropdown.
Sam Lepak | TrustRadius Reviewer

Cons

Apache Hive

  • 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.
Anonymous | TrustRadius Reviewer

Google BigQuery

  • Though it is SQL some syntax are different but they are getting used to after you use for some time.
  • The legacy SQL is in beta state but can be used and you can run the query with simple SQL.
  • More documentation is needed for using User-defined functions in Big Query.
Anonymous | TrustRadius Reviewer

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

Google BigQuery

No score
No answers yet
No answers on this topic

Usability

Apache Hive

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

Google BigQuery

Google BigQuery 9.0
Based on 1 answer
BigQuery is a little bit difficult to learn at first. The tools are all there but it takes a few hours of practice and trial and error to be comfortable processing a large dataset. It can handle quite a bit and the cloud storage makes those experimental practice hours much easier to do in your spare time. The software is capable of doing a lot, it's just a matter of being patient and learning the ways of BigQuery.
Anonymous | TrustRadius Reviewer

Support Rating

Apache Hive

No score
No answers yet
No answers on this topic

Google BigQuery

Google BigQuery 8.5
Based on 8 answers
I rated the overall support for Google BigQuery as a mediocre five because it has limited support from Google. Instead, it is heavily dependent on an organization's IT resources such as SQL analysts and Data Architects to run big data reports or maintain data quality. Additionally, if errors occur during a run of complex SQL queries or when sending data to Google BigQuery from other sources, Google provides basic email support which needs to be complemented with internal data warehouse support to fix the root cause of the database errors. Finally, due to constraints on the amount of data an analyst can query or pay the additional cost when exceeding the limit, basic Google support is not sufficient to meet data needs without interruption.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Apache Hive

I wasn't part of the evaluation process for Apache Hive. This was already implemented when I joined the company. I have worked with other big data plaftforms and I personally thinks most of them are quite comporable to one another. It really depends on what the company is going for. For exampel Google Cloud makes a ton of sense for a user if they developed their application on Google App Engine.
Sameer Gupta | TrustRadius Reviewer

Google BigQuery

Spinning up, provisioning, maintaining and debugging a Hadoop solution can be non-trivial, painful. I'm talking about both GCE based or HDInsight clusters. It requires expertise (+ employee hire, costs). With BigQuery if someone has a good SQL knowledge (and maybe a little programming), can already start to test and develop. All of the infrastructure and platform services are taken care of. Google BigQuery is a magnitudes simpler to use than Hadoop, but you have to evaluate the costs. BigQuery billing is dependent on your data size and how much data your query touches.
Csaba Toth | TrustRadius Reviewer

Return on Investment

Apache Hive

  • 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 | TrustRadius Reviewer

Google BigQuery

  • Google BigQuery has had enormous impact in terms of ROI to our business, as it has allowed us to ease our dependence on our physical servers, which we pay for monthly from another hosting service. We have been able to run multiple enterprise scale data processing applications with almost no investment
  • Since our business is highly client focused, Google Cloud Platform, and BigQuery specifically, has allowed us to get very granular in how our usage should be attributed to different projects, clients, and teams.
  • Plain and simple, I believe the meager investments that we have made in Google BigQuery have paid themselves back hundreds of times over.
Alex Andrews | TrustRadius Reviewer

Pricing Details

Apache Hive

General

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

Google BigQuery

General

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

Rating Summary

Likelihood to Recommend

Apache Hive
8.4
Google BigQuery
8.3

Likelihood to Renew

Apache Hive
10.0
Google BigQuery

Usability

Apache Hive
9.0
Google BigQuery
9.0

Support Rating

Apache Hive
Google BigQuery
8.5

Add comparison