What is the biggest difference between Apache Hadoop and Snowflake?

One of the most popular comparisons on IT Central Station is Apache Hadoop vs Snowflake.

People like you are trying to decide which one is best for their company. Can you help them out?

What is the biggest difference between Apache Hadoop and Snowflake? Which of these two solutions would you recommend to a colleague evaluating data warehouse systems and why?

Thanks for helping your peers make the best decision!

Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot
  • 1
  • 14
PeerSpot user
2 Answers
it_user1108338 - PeerSpot reviewer
Consultant at Tata Consultancy Services
Real User
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
Director at a tech services company with 10,001+ employees
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: May 2023.
708,243 professionals have used our research since 2012.
Related Questions
reviewer2162229 - PeerSpot reviewer
User at NAVER Corp
Apr 26, 2023
Hello community,  I work for a large tech services company. I am currently researching data warehouse solutions. Which solution do you prefer: Oracle Exadata or Snowflake? Which solution performs better and has more cost savings? Thank you for your help.
See 2 answers
CEO at WInterCorp LLC
Apr 21, 2023
This is a large and complex question and depends on the use case and scale. Each platform has its advantages and there are significant pros and cons for each platform. I am an independent consultant; I teach courses about these platforms and how to select one; and I advise clients.  If you would like to have a discussion about your requirements, the tradeoffs, and how to go about getting the best platform for your business, please email me at richard@wintercorp.com or book me online (no charge) at solvethepuzzle.biz
Chief Technology Officer at Triana Business Solutions Lda
Apr 26, 2023
Exadata is by far the most appropriate fit-for-purpose solution for Dataware House, although it is expansive. But performance, scalability, and availability is the key you must consider when going to Oracle Exadata. Also, a good Field Deliver Support team to attend when needed. And you can run your business on-premise cloud or a public one.
Tomasz Rabong - PeerSpot reviewer
Client Engagement Leader at Sanmargar Team
Apr 20, 2022
Hello peers, I am looking for a data catalog vendor or open-source with the following DB data sources: Teradata MS SQL HANA Hadoop/Hive and BI data sources: SAP BO 4.0 Tableau Server 2022.1 Can you please advise? I appreciate the help.
2 out of 6 answers
Director of Community at PeerSpot (formerly IT Central Station)
Apr 18, 2022
Hi @Delmar Assis, @Angel Pineda, @reviewer1318779, @George McGeachie, @Carel Van Der Merwe and @Moorthy Natarajan, Can you please assist @Tomasz Rabong ​with their question?​​ ​ ​ ​ ​
Leandro Sodré - PeerSpot reviewer
Data Governance Specialist at Keyrus
Apr 18, 2022
Hi Tomasz Rabong,  I believe that if you have a developer team in Amundsen it would be possible.  Alternatively, you can look at Informatica EDC or at Data Virtualization Data Catalog (from Denodo).
Related Articles
Content Manager at PeerSpot (formerly IT Central Station)
Apr 26, 2022
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to better connect with peers and other independent experts who provide advice without vendor bias. Our users have ranked these solutions according to their valuable features, and discuss which features they like most and why. You can read user reviews for the Top 5 Data Warehouse Tools to help you d...
Product Comparisons
Related Articles
Content Manager at PeerSpot (formerly IT Central Station)
Apr 26, 2022
Top 5 Data Warehouse Tools 2022
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to...
Download Free Report
Download our FREE report comparing Apache Hadoop and Snowflake based on reviews, features, and more! Updated: May 2023.
708,243 professionals have used our research since 2012.