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

Likelihood to Recommend

Hadoop

Apache Hadoop (and its subsequent add-ons) are well-suited to larger, unstructured data flows, such as aggregation of web traffic or advertising. Geospatial algorithms and their outputs are well-suited for this kind of aggregation as structuring that data is challenging, but leaving it unstructured and performing queries as-needed is a better fit for most business models. With the advent of data science, I would expect Hadoop fits a LOT of their initial outputs quite well.
Joe Hughes | 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

Hadoop
Google BigQuery
9.0
Automatic software patching
Hadoop
Google BigQuery
9.3
Database scalability
Hadoop
Google BigQuery
9.4
Automated backups
Hadoop
Google BigQuery
8.8
Database security provisions
Hadoop
Google BigQuery
8.8
Monitoring and metrics
Hadoop
Google BigQuery
8.8
Automatic host deployment
Hadoop
Google BigQuery
8.8

Pros

Hadoop

  • HDFS is reliable and solid, and in my experience with it, there are very few problems using it
  • Enterprise support from different vendors makes it easier to 'sell' inside an enterprise
  • It provides High Scalability and Redundancy
  • Horizontal scaling and distributed architecture
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

Hadoop

  • Hadoop is a batch oriented processing framework, it lacks real time or stream processing.
  • Hadoop's HDFS file system is not a POSIX compliant file system and does not work well with small files, especially smaller than the default block size.
  • Hadoop cannot be used for running interactive jobs or analytics.
Mrugen Deshmukh | 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

Hadoop

Hadoop 9.6
Based on 8 answers
Hadoop is organization-independent and can be used for various purposes ranging from archiving to reporting and can make use of economic, commodity hardware. There is also a lot of saving in terms of licensing costs - since most of the Hadoop ecosystem is available as open-source and is free
Bhushan Lakhe | TrustRadius Reviewer

Google BigQuery

No score
No answers yet
No answers on this topic

Usability

Hadoop

Hadoop 8.5
Based on 5 answers
Great! Hadoop has an easy to use interface that mimics most other data warehouses. You can access your data via SQL and have it display in a terminal before exporting it to your business intelligence platform of choice. Of course, for smaller data sets, you can also export it to Microsoft Excel.
Blake Baron | 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

Hadoop

Hadoop 6.9
Based on 6 answers
We went with a third party for support, i.e., consultant. Had we gone with Azure or Cloudera, we would have obtained support directly from the vendor. my rating is more on the third party we selected and doesn't reflect the overall support available for Hadoop. I think we could have done better in our selection process, however, we were trying to use an already approved vendor within our organization. There is plenty of self-help available for Hadoop online.
Gene Baker | TrustRadius Reviewer

Google BigQuery

Google BigQuery 8.4
Based on 16 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

Online Training

Hadoop

Hadoop 6.1
Based on 2 answers
Hadoop is a complex topic and best suited for classrom training. Online training are a waste of time and money.
Bhushan Lakhe | TrustRadius Reviewer

Google BigQuery

No score
No answers yet
No answers on this topic

Alternatives Considered

Hadoop

Not used any other product than Hadoop and I don't think our company will switch to any other product, as Hadoop is providing excellent results. Our company is growing rapidly, Hadoop helps to keep up our performance and meet customer expectations. We also use HDFS which provides very high bandwidth to support MapReduce workloads.
Anonymous | 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

Hadoop

  • Hadoop has allowed us to scale out a few of our tier-1, customer facing applications to provide very fast access to reports and analytics.
  • Hadoop was easily implemented by our Linux team and onboarded by our Hadoop Admins.
  • Hadoop has been a very stable platform and only goes down due to server patching or other maintenance.
Mark McCully | 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

Hadoop

General

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

Hadoop Editions & Modules

Additional Pricing Details

Google BigQuery

General

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

Google BigQuery Editions & Modules

Edition
Queries (On-Demand)$51
Queries (Hourly Flex Slots)$42
Queries (Monthly Flat Rate)$20002
Queries (Annual Flat Rate)$1,7002
  1. per TB
  2. per 100 slots
Additional Pricing Details

Rating Summary

Likelihood to Recommend

Hadoop
8.2
Google BigQuery
8.7

Likelihood to Renew

Hadoop
9.6
Google BigQuery

Usability

Hadoop
8.5
Google BigQuery
9.0

Performance

Hadoop
8.0
Google BigQuery

Support Rating

Hadoop
6.9
Google BigQuery
8.4

Online Training

Hadoop
6.1
Google BigQuery

Add comparison