Google BigQuery vs Hive

Likelihood to Recommend

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

Read full review

Tristan Dobbs

Vice President of Shared Services

CloudbakersComputer Software, 51-200 employees

View all 22 answers on this topic

Hive will fit right in to any workflow that manages multiple projects. It's also a great fit for collaboration on a per-project basis as external users can collaborate with paid users. Across a very large team it would take more planning on how to fit multiple workflows and groups into the workspace but it can be done.

Read full review

Verified User

Project Manager in Marketing

Higher Education Company, 501-1000 employees

View all 7 answers on this topic

Feature Rating Comparison

Google BigQuery

Hive

Automatic software patching

Database scalability

Automated backups

Database security provisions

Monitoring and metrics

Automatic host deployment

Google BigQuery

Hive

Task Management

Resource Management

Gantt Charts

Scheduling

Workflow Automation

Team Collaboration

Support for Agile Methodology

Support for Waterfall Methodology

Document Management

Email integration

Mobile Access

Timesheet Tracking

Change request and Case Management

Budget and Expense Management

Google BigQuery

Hive

Quotes/estimates

Invoicing

Project & financial reporting

Integration with accounting software

Pros

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.

Read full review

Sam Lepak

Head of Digital Marketing

YachtLifeInternet, 11-50 employees

View all 22 answers on this topic

Very intuitive user interface that makes project management, tracking and collaboration easy. Multiple project visualisation options (Gantt, Kanban, calendars, tables)
Great integration with a large number of tools

Read full review

Verified User

C-Level Executive in Corporate

Computer Software Company, 11-50 employees

View all 7 answers on this topic

Cons

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.

Read full review

Verified User

Analyst in Information Technology

Internet Company, 11-50 employees

View all 22 answers on this topic

You can't move urgent actions to the top.
It takes a little too much time to load up on the desktop version.
There's definitely room for improvement in keyboard shortcuts.

Read full review

Verified User

Employee in Sales

Hospital & Health Care Company, 11-50 employees

View all 7 answers on this topic

Usability

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.

Read full review

Verified User

Employee in Professional Services

Environmental Services Company, 1-10 employees

View all 1 answers on this topic

Hive 9.0

Based on 1 answer

I love Hive so much because it has made a huge difference regarding team communication and project management at the same time. We experienced almost no bugs and in the few cases that we did have some trouble, the customer service team was very responsive and solved our problems very quickly.

Read full review

Verified User

Employee in Sales

Hospital & Health Care Company, 11-50 employees

View all 1 answers on this topic

Support Rating

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.

Read full review

Verified User

Analyst in Marketing

Food & Beverages Company, 10,001+ employees

View all 16 answers on this topic

Hive 9.1

Based on 5 answers

Our CSR is easily accessible and they have support built into the app itself. They also have a pretty robust support site. We also took advantage of the free trial and learned so much by putting Hive through the paces and figuring out the best way to mold it to our needs.

Read full review

Verified User

Project Manager in Marketing

Higher Education Company, 501-1000 employees

View all 5 answers on this topic

Alternatives Considered

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

Csaba Toth

Software Engineer

SportsBoard Mobile Player Assessment SolutionsResearch, 1-10 employees

View all 22 answers on this topic

I would say that in comparison to Asana, Hive is a better interface an UI. I think Asana is more robust in terms of what it can do in conjunction with Confluence but I think Hive is a better entry-level model for new employees. Hive is much simpler and more straight forward and its integration with Slack is preferred.

Read full review

John Bianchi

Director of Accounts

Business Optimization SpecialistsMarketing and Advertising, 11-50 employees

View all 7 answers on this topic

Return on Investment

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

Alex Andrews

Solution Architect

Ovative/groupMarketing and Advertising, 51-200 employees

View all 22 answers on this topic

Positive ROI comes from our whole team being on the same board. We used to have separate boards for each group.

Read full review

Cameron Michael Rhoads

Content Supervisor

AceableE-Learning, 51-200 employees

View all 7 answers on this topic

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Google BigQuery Editions & Modules

Edition

Queries (On-Demand)	$5¹
Queries (Hourly Flex Slots)	$4²
Queries (Monthly Flat Rate)	$2000²
Queries (Annual Flat Rate)	$1,700²

per TB
per 100 slots

Additional Pricing Details

—

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

Hive Editions & Modules

—

Additional Pricing Details

—

Rating Summary

Google BigQuery

Hive

Google BigQuery

Hive

Google BigQuery

Hive

Likelihood to Recommend

Google BigQuery

Hive

Feature Rating Comparison

Automatic software patching

Database scalability

Automated backups

Database security provisions

Monitoring and metrics

Automatic host deployment

Task Management

Resource Management

Gantt Charts

Scheduling

Workflow Automation

Team Collaboration

Support for Agile Methodology

Support for Waterfall Methodology

Document Management

Email integration

Mobile Access

Timesheet Tracking

Change request and Case Management

Budget and Expense Management

Quotes/estimates

Invoicing

Project & financial reporting

Integration with accounting software

Pros

Google BigQuery

Hive

Cons

Google BigQuery

Hive

Usability

Google BigQuery

Hive

Support Rating

Google BigQuery

Hive

Alternatives Considered

Google BigQuery

Hive

Return on Investment

Google BigQuery

Hive

Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Google BigQuery Editions & Modules

Edition

Additional Pricing Details

General

Free Trial

Free/Freemium Version

Premium Consulting/Integration Services

Entry-level set up fee?

Hive Editions & Modules

Additional Pricing Details

Rating Summary

Add comparison