2019-06-25T10:55:00Z

What is the biggest difference between Apache Hadoop and Snowflake?

Miriam Tover - PeerSpot reviewer
  • 1
  • 12
PeerSpot user
2

2 Answers

it_user1108338 - PeerSpot reviewer
Real User
2019-06-26T09:07:59Z
Jun 26, 2019

Interactive querying as a consumption pattern is something Snowflake handles much better than Hadoop and related query engine options - Impala, Presto, Drill etc. Heavy data scientists query workload can be an expensive query pattern on Snowflake and Hadoop can provide a more cost-efficient solution. Hadoop is also still relevant as a back-end data processing engine, instead of leveraging Snowflake for data transformation due to higher cost as well as limited procedural language capabilities (javascript based stored procedures). Snowflake fares much better than Hadoop in terms of administrative complexity.

Product comparison that may be of interest to you
it_user1274238 - PeerSpot reviewer
User
2020-02-03T21:29:06Z
Feb 3, 2020

Apache Hadoop is for data lake use cases. But getting data out of Hadoop for meaningful analytics is indeed need quite an amount of work. by either using spark/Hive/presto and so on. The way i look at Snowflake and Hadoop is they complement each other. For data lake you can use hadoop and then for datawarehouse companies can use snowflake. Depending on the size of the company you can turn snowflake into a data lake use case too. Snowflake is SQL friendly and you don't need to carry out any circus to get the data in and out of snowflake.

Find out what your peers are saying about Apache Hadoop vs. Snowflake and other solutions. Updated: March 2024.
763,955 professionals have used our research since 2012.
Apache Hadoop vs. Snowflake comparison
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
Download Apache Hadoop vs. Snowflake comparison ReportRead more

Related Q&As

Related articles