We performed a comparison between Apache Hadoop and BigQuery based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Apache Hadoop is crucial in projects that save and retrieve data daily. Its valuable features are scalability and stability. It is easy to integrate with the existing infrastructure."
"Two valuable features are its scalability and parallel processing. There are jobs that cannot be done unless you have massively parallel processing."
"Hadoop is extensible — it's elastic."
"High throughput and low latency. We start with data mashing on Hive and finally use this for KPI visualization."
"Since both Apache Hadoop and Amazon EC2 are elastic in nature, we can scale and expand on demand for a specific PoC, and scale down when it's done."
"The most valuable features are powerful tools for ingestion, as data is in multiple systems."
"The ability to add multiple nodes without any restriction is the solution's most valuable aspect."
"It's open-source, so it's very cost-effective."
"BigQuery is a powerful tool for managing and analyzing large datasets. The versatility of BigQuery extends to its compatibility with external data visualization tools like Power BI and Tableau. This means you not only get query results but can also seamlessly integrate and visualize your data for better insights."
"It has a proprietary way of storing and accessing data in its own data store and is 100% managed without you needing to install anything. There is no need to arrange for any infrastructure to be able to use this solution."
"The product is serverless. We only need to write SQL queries to analyze the data. We need to pay based on the number of queries. The retrieval time is very less. Even if you write large queries, the tool is able to bring back data in a few seconds."
"The initial setup process is easy."
"We basically used it to store server data and generate reports for enterprise architects. It was a valuable tool for our enterprise design architect."
"The most valuable features of BigQuery is that it supports standard SQL and provides good performance."
"The query tool is scalable and allows for petabytes of data."
"It's similar to a Hadoop cluster, except it's managed by Google."
"There is a lack of virtualization and presentation layers, so you can't take it and implement it like a radio solution."
"We would like to have more dynamics in merging this machine data with other internal data to make more meaning out of it."
"The upgrade path should be improved because it is not as easy as it should be."
"I think more of the solution needs to be focused around the panel processing and retrieval of data."
"The key shortcoming is its inability to handle queries when there is insufficient memory. This limitation can be bypassed by processing the data in chunks."
"It could be more user-friendly."
"The solution is very expensive."
"Real-time data processing is weak. This solution is very difficult to run and implement."
"The main challenges are in the areas of performance and cost optimizations."
"We'd like to have more integrations with other technologies."
"They could enhance the platform's user accessibility."
"The solution hinges on Google patterns so continued improvement is important."
"The primary hurdle in this migration lies in the initial phase of moving substantial volumes of data to cloud-based platforms."
"It would be helpful if they could provide some dashboards where you can easily view charts and information."
"The initial setup could be improved making it easier to deploy."
"As a product, BigQuery still requires a lot of maturity to accommodate other use cases and to be widely acceptable across other organizations."
Apache Hadoop is ranked 6th in Data Warehouse with 34 reviews while BigQuery is ranked 5th in Cloud Data Warehouse with 31 reviews. Apache Hadoop is rated 7.8, while BigQuery is rated 8.2. The top reviewer of Apache Hadoop writes "Handles huge data volumes and create your own workflows and tables but you need to have deeper knowledge". On the other hand, the top reviewer of BigQuery writes "Expandable and easy to set up but needs more local data residency". Apache Hadoop is most compared with Azure Data Factory, Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake and VMware Tanzu Data Services, whereas BigQuery is most compared with Snowflake, Teradata, Oracle Autonomous Data Warehouse, Vertica and AWS Lake Formation. See our Apache Hadoop vs. BigQuery report.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.