Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Azure HDInsight
Score 8.9 out of 10
N/A
HDInsight is an implementation of the Apache Hadoop technology stack on the Microsoft Azure cloud platform: It is based on the Hortonworks Hadoop distribution. Microsoft Azure HDInsight includes implementations of Apache Spark, HBase, Storm, Pig, Hive, Sqoop, Oozie, Ambari, etc. It also integrates with with business intelligence (BI) tools such as Power BI, Excel, SQL Server Analysis Services, and SQL Server Reporting Services.N/A
Google BigQuery
Score 8.7 out of 10
N/A
Google's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.
$0
per month
Pricing
Azure HDInsightGoogle BigQuery
Editions & Modules
No answers on this topic
Standard edition
$0.04 / slot hour
Enterprise edition
$0.06 / slot hour
Enterprise Plus edition
$0.10 / slot hour
Offerings
Pricing Offerings
Azure HDInsightGoogle BigQuery
Free Trial
NoYes
Free/Freemium Version
NoYes
Premium Consulting/Integration Services
NoNo
Entry-level Setup FeeNo setup feeNo setup fee
Additional Details
More Pricing Information
Community Pulse
Azure HDInsightGoogle BigQuery
Top Pros
Top Cons
Features
Azure HDInsightGoogle BigQuery
Database-as-a-Service
Comparison of Database-as-a-Service features of Product A and Product B
Azure HDInsight
-
Ratings
Google BigQuery
8.4
30 Ratings
3% below category average
Automatic software patching00 Ratings8.117 Ratings
Database scalability00 Ratings8.830 Ratings
Automated backups00 Ratings8.524 Ratings
Database security provisions00 Ratings8.924 Ratings
Monitoring and metrics00 Ratings7.726 Ratings
Automatic host deployment00 Ratings8.113 Ratings
Best Alternatives
Azure HDInsightGoogle BigQuery
Small Businesses

No answers on this topic

IBM Cloudant
IBM Cloudant
Score 9.5 out of 10
Medium-sized Companies
Cloudera Manager
Cloudera Manager
Score 9.7 out of 10
IBM Cloudant
IBM Cloudant
Score 9.5 out of 10
Enterprises
IBM Analytics Engine
IBM Analytics Engine
Score 9.3 out of 10
IBM Cloudant
IBM Cloudant
Score 9.5 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Azure HDInsightGoogle BigQuery
Likelihood to Recommend
9.1
(5 ratings)
8.6
(30 ratings)
Usability
8.9
(4 ratings)
9.4
(3 ratings)
Support Rating
8.9
(4 ratings)
10.0
(9 ratings)
Contract Terms and Pricing Model
-
(0 ratings)
10.0
(1 ratings)
Professional Services
-
(0 ratings)
8.2
(2 ratings)
User Testimonials
Azure HDInsightGoogle BigQuery
Likelihood to Recommend
Microsoft
If you want to save costs and just pay for what you use, I highly recommend it. It will help you also to work with data for your reports and analytics. on the other hand I think it could be the subscription you have but high volume of data make it slow but not so much. anyway I think it's really good because it's from Microsoft which always is friendly to use it as all the suit they have.
Read full review
Google
One of the most important aspects while working with data warehousing solutions and analytics is the ability to handle large datasets. Google BigQuery is the best in business for that particular aspect. It is ridiculously fast while handling large data sets. Another aspect where it is well suited is the ability to integrate it with data visualization tools like Data Studio. It is fast, easy to use, and very reliable. The only aspect where I feel it is less appropriate where you have to pay more of inefficient scripts and that can hamper the growth of the company a bit.
Read full review
Pros
Microsoft
  • Data is presented without interfering others (IT or other dept).
  • Data is managed properly and is available for retrievable any time.
  • Legacy use of CD/DVD and Pendrive are not required.
Read full review
Google
  • BigQuery is ridiculously fast and has the ability to query absurdly large data sets to return results immediately.
  • BigQuery allows for storage of a massive amount of data for relatively low prices.
  • Easy to learn. BiqQuery uses SQL-like queries and is easy to transfer your existing skills to use.
Read full review
Cons
Microsoft
  • The only problem I have come across is when loading large volumes of data I sometimes get an error message, I assume this means something is corrupt from within. I would love a way for this to be resolved without having to start over.
Read full review
Google
  • One issue with Google Cloud Storage is its price. For one to have that premium Google Cloud Storage, for the purpose of massive storage, he/she must have adequate cash. Otherwise, Google Cloud Storage is a safe and perfect online storage platform.
  • The only thing that can come to mind that would be annoying with this software was that sometimes when trying to share files on the Cloud with coworkers, it would just not share at all, or there would be a massive delay in when I shared them and when they received them. Other than that though, everything is perfect with this.
Read full review
Usability
Microsoft
Azure HDInsight is usable on the top of Azure Data Lake and gives us the benefit of analyzing large scale data workload in Hadoop. Usability and support from Microsoft are outstanding.
Read full review
Google
web UI is easy and convenient. Many RDBMS clients such as aqua data studio, Dbeaver data grid, and others connect. Range of well-documented APIs available. The range of features keeps expanding, increasing similar features to traditional RDBMS such as Oracle and DB2
Read full review
Support Rating
Microsoft
I highly recommend it.
Read full review
Google
It’s Google, they’re big and well organized, the documentation is abundant and the scalability is amazing. The UX is good too, considering it’s a professional tool expected to be used by people with a specific technical background. Overall, it makes me feels good and secure that we know where to store the data, how to use that data and that the data is handled with utmost security and performance practices.
Read full review
Alternatives Considered
Microsoft
At this time I have not used any other similar products... I am open to it but Azure HDInsight and its components really work well for our organization.
Read full review
Google
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.
Read full review
Contract Terms and Pricing Model
Microsoft
No answers on this topic
Google
None so far. Very satisfied with the transparency on contract terms and pricing model.
Read full review
Professional Services
Microsoft
No answers on this topic
Google
Google Support has kindly provide individual support and consultants to assist with the integration work. In the circumstance where the consultants are not present to support with the work, Google Support Helpline will always be available to answer to the queries without having to wait for more than 3 days.
Read full review
Return on Investment
Microsoft
  • Less implementation cost.
  • No hosting services cost.
  • Faster data retrieval.
Read full review
Google
  • 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.
Read full review
ScreenShots