What users are saying about
238 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
59 Ratings
238 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.3 out of 100

Snowflake

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener noreferrer'>Customer Verified: Read more.</a>
Top Rated
59 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.1 out of 100

Likelihood to Recommend

Hadoop

  • Less appropriate for small data sets
  • Works well for scenarios with bulk amount of data. They can surely go for Hadoop file system, having offline applications
  • It's not an instant querying software like SQL; so if your application can wait on the crunching of data, then use it
  • Not for real-time applications
Bharadwaj (Brad) Chivukula | TrustRadius Reviewer

Snowflake

Snowflake is great when you need to store large amounts of data while retaining the ability to query that data quickly. It is very reliable and allows for auto-scaling on large queries meaning that you're only paying for the power you actually use. It's taken queries that took 20+ minutes to run on redshift down to 2 minutes on Snowflake.
Jake Schlingman | TrustRadius Reviewer

Pros

Hadoop

  • Hadoop is a very cost effective storage solution for businesses’ exploding data sets.
  • Hadoop can store and distribute very large data sets across hundreds of servers that operate, therefore it is a highly scalable storage platform.
  • Hadoop can process terabytes of data in minutes and faster as compared to other data processors.
  • Hadoop File System can store all types of data, structured and unstructured, in nodes across many servers
Anonymous | TrustRadius Reviewer

Snowflake

  • Impressive data retrieval and data compression ratio.
  • Semi-structured data (JSON, XML) can be loaded as is and retrieved in a tabular structure on the fly using the flatten function.
  • Zero-copy cloning is an excellent feature which saves hours to refresh latest data in development instance.
  • Extensive usages documentation with examples makes development easy.
Anonymous | TrustRadius Reviewer

Cons

Hadoop

  • Hadoop is a batch oriented processing framework, it lacks real time or stream processing.
  • Hadoop's HDFS file system is not a POSIX compliant file system and does not work well with small files, especially smaller than the default block size.
  • Hadoop cannot be used for running interactive jobs or analytics.
Mrugen Deshmukh | TrustRadius Reviewer

Snowflake

  • Very limited amount of tabs - saved queries, which requires us to store the code somewhere else and re-use existing queries.
  • Performance can really be a problem if there are many users on the system at the same time.
  • SnowFlake support sometimes can be hard to reach.
Anonymous | TrustRadius Reviewer

Likelihood to Renew

Hadoop

Hadoop 9.6
Based on 8 answers
Hadoop is organization-independent and can be used for various purposes ranging from archiving to reporting and can make use of economic, commodity hardware. There is also a lot of saving in terms of licensing costs - since most of the Hadoop ecosystem is available as open-source and is free
Bhushan Lakhe | TrustRadius Reviewer

Snowflake

Snowflake 8.0
Based on 1 answer
SnowFlake is very cost effective and we also like the fact we can stop, start and spin up additional processing engines as we need to. We also like the fact that it's easy to connect our SQL IDEs to Snowflake and write our queries in the environment that we are used to
Anonymous | TrustRadius Reviewer

Usability

Hadoop

Hadoop 9.0
Based on 3 answers
I found it really useful during my academic projects. Data handling for large data sets was easy with Hadoop. It used to work really fast for bigger data sets. I found it reliable.
Tushar Kulkarni | TrustRadius Reviewer

Snowflake

Snowflake 8.8
Based on 11 answers
The web front end is OK, but they could improve the product with a front end GUI. We have connected DBEAVER to snowflake with an ODBC driver, but the queries are a lot slower from DBEAVER, compared to the web front end. SSIS also has an ODBC connection, but it is also a slower to pull data from snowflake. Overall the usability is good.
Wicks Justin | TrustRadius Reviewer

Support Rating

Hadoop

Hadoop 6.0
Based on 3 answers
Hadoop support is just average based on our experience. This is one area where it would be nice to see some improvement. Granted, we haven't had many issues with Hadoop that have required support.
Mark McCully | TrustRadius Reviewer

Snowflake

Snowflake 8.4
Based on 5 answers
Overall, the support from Snowflake has been very good. Since we are one of the major users for Snowflake and have a dedicated tech team to solve all the technical problem on our way. On the side of the technical problem, any sql related questions can be found from everywhere online.
Anonymous | TrustRadius Reviewer

Online Training

Hadoop

Hadoop 6.1
Based on 2 answers
Hadoop is a complex topic and best suited for classrom training. Online training are a waste of time and money.
Bhushan Lakhe | TrustRadius Reviewer

Snowflake

No score
No answers yet
No answers on this topic

Alternatives Considered

Hadoop

We considered using Relationship database with Oracle Database and Java applications to process our data but ended up with Hadoop despite it being almost new. However, it proved to be the correct solution, we just need a little time to get started with Hadoop and it allows it to save cost on license and EC2 cost as we configure DataNode to be on-demand or spot instance, it also provides high performance and easy to implement as Map-Reduce function is quite simple.
Hung Vu | TrustRadius Reviewer

Snowflake

The average percentage of time that a data warehouse is actually doing something is around 20%. Given this, the price by query estimate becomes an important pricing consideration. For this, Snowflake crucially decouples of storage and compute. With Snowflake you pay for 1) storage space used and 2) amount of time spent querying data. Snowflake also has a notion of a “logical warehouse” which is the “compute” aspect of the database. These warehouses can be scaled up or down to deliver different grades of performance. You can also configure the number of compute nodes to parallelize query execution. These warehouses can be configured to “pause” when you’re not using them for cost efficiency. As a result, you can have a super beefy warehouse for BI queries that’s only running when people are using your BI tools, while your background batch jobs can use cheaper hardware.
Andrew Goss | TrustRadius Reviewer

Return on Investment

Hadoop

  • Hadoop was thought to be cheap, but it is actually a very expensive proposition.
  • Support is required for Hadoop, so it is not free from a support perspective.
  • The overall benefit of Hadoop is extensive scale out storage and processing, but it is difficult to tie it to ROI in a major corporation.
Anonymous | TrustRadius Reviewer

Snowflake

  • Quick installation/setup for a data warehouse solution.
  • Make easy to handle/manage the various type of semi-structured data using the native solutions and provided new data modeling concepts such as schema-read data model and schema-write data model.
  • Make easy and simplified the workload management using virtual warehouses and materialized views.
Jacob Biguvu | TrustRadius Reviewer

Pricing Details

Hadoop

General

Free Trial
Free/Freemium Version
Yes
Premium Consulting/Integration Services
Entry-level set up fee?
No

Snowflake

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Add comparison