TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Apache Hive

    Score8 out of 10
    N/AApache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.N/A

    Google BigQuery

    Score8.4 out of 10
    N/AGoogle's BigQuery is part of the Google Cloud Platform, a database-as-a-service (DBaaS) supporting the querying and rapid analysis of enterprise data.

    $6.25

    per TiB (after the 1st 1 TiB per month, which is free)

    Pricing
    Apache HiveGoogle 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
    Apache HiveGoogle 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
    Apache HiveGoogle BigQuery
    Considered Both Products
    Apache
    Chose Apache Hive
    Besides Hive, I have used Google BigQuery, which is costly but have very high computation speed.
    Amazon Redshift is the another product, I used in my recent organisation.
    Both Redshift and BigQuery are managed solution whereas Hive needs to be managed
    Incentivized
    Chose Apache Hive
    Apache hive gave more flexible than MS SQL server. Elasticsearch was little complex. GoogleBigQuery cost more.
    Incentivized
    Chose Apache Hive
    [We selected Apache Hive because] It's from apache and opensource. So it's free.
    Incentivized
    Chose 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 …
    Incentivized
    Google
    Chose Google BigQuery
    Other locally hosted solutions are capable of providing the required level of performance, but the administration requirements are significantly more involved than with BigQuery. Additionally, there are capacity and availability concerns with locally hosted platforms that are a …
    Incentivized
    Chose 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 …
    Incentivized
    Chose Google BigQuery
    Comparing to competitors, Google BigQuery has the lowest cost and most flexible pricing model. Definitely higher ROI.
    Incentivized
    Key User Insights
    Would buy again
    No answers on this topic
    No answers on this topic
    Delivers good value for the price
    No answers on this topic
    No answers on this topic
    Happy with the feature set
    No answers on this topic
    No answers on this topic
    Lived up to sales and marketing promises
    No answers on this topic
    No answers on this topic
    Implementation went as expected
    No answers on this topic
    No answers on this topic
    Features
    Apache HiveGoogle BigQuery
    Database-as-a-Service
    Comparison of Database-as-a-Service features of Apache Hive and Google BigQuery
    Feature
    Apache Hive
    -
    Ratings
    Google BigQuery
    8.4
    71 Ratings
    Automatic software patching00 Ratings8.017 Ratings
    Database scalability00 Ratings9.270 Ratings
    Automated backups00 Ratings8.524 Ratings
    Database security provisions00 Ratings8.664 Ratings
    Monitoring and metrics00 Ratings8.066 Ratings
    Automatic host deployment00 Ratings8.013 Ratings
    User Ratings
    Apache HiveGoogle BigQuery
    Likelihood to Recommend
    8.0
    (35 ratings)
    8.6
    (71 ratings)
    Likelihood to Renew
    10.0
    (1 ratings)
    8.1
    (3 ratings)
    Usability
    8.5
    (7 ratings)
    7.7
    (5 ratings)
    Support Rating
    7.0
    (6 ratings)
    7.3
    (10 ratings)
    Contract Terms and Pricing Model
    -
    (0 ratings)
    10.0
    (1 ratings)
    Professional Services
    -
    (0 ratings)
    8.2
    (2 ratings)