246 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 8.4 out of 100
Based on 246 reviews and ratings
23 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>Score 7.9 out of 100
Based on 23 reviews and ratings
Likelihood to Recommend
Hadoop
Apache Hadoop (and its subsequent add-ons) are well-suited to larger, unstructured data flows, such as aggregation of web traffic or advertising. Geospatial algorithms and their outputs are well-suited for this kind of aggregation as structuring that data is challenging, but leaving it unstructured and performing queries as-needed is a better fit for most business models. With the advent of data science, I would expect Hadoop fits a LOT of their initial outputs quite well.
Senior DevOps Engineer
Simpli.fiOnline Media, 201-500 employees
Vertica
Vertica as a data warehouse to deliver analytics in-house and even to your client base on scale is not rivaled anywhere in the market. Frankly, in my experience it is not even close to equaled. Because it is such a powerful data warehouse, some people attempt to use it as a transactional database. It certainly is not one of those. Individual row inserts are slow and do not perform well. Deletes are a whole other story. RDBMS it is definitely not. OLAP it rocks.
Business Intelligence Manager
iContactMarketing and Advertising, 51-200 employees
Pros
Hadoop
- HDFS is reliable and solid, and in my experience with it, there are very few problems using it
- Enterprise support from different vendors makes it easier to 'sell' inside an enterprise
- It provides High Scalability and Redundancy
- Horizontal scaling and distributed architecture
Sr. Engineering Manager/Delivery Manager
Nisum Technologies, Inc.Retail, 10,001+ employees
Vertica
- Extremely fast query performance - Vertica is one of the fastest query engines out there.
- Scales to TBs - Scales reasonably well up to 10-20 nodes and 10 - 100s of TB of data.
- Easy to Use - Fairly easy to user, we made quite some headway with just 1 person running it for a while.
Engineering Manager - Ride Experience
UberInternet, 5001-10,000 employees
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.
Senior Software Engineer
San Jose State UniversityComputer Software, 51-200 employees
Vertica
- Could use some work on better integrating with cloud providers and open source technologies. For AWS you will find an AMI in the marketplace and recently a connector for loading data from S3 directly was created. With last release, integration with Kafka was added that can help.
- Managing large workloads (concurrent queries) is a bit challenging.
- Having a way to provide an estimate on the duration for currently executing queries / etc. can be helpful. Vertica provides some counters for the query execution engine that are helpful but some may find confusing.
- Unloading data over JDBC is very slow. We've had to come up with alternatives based on vsql, etc. Not a very clean, official on how to unload data.
Big Data Technical Director
CircleBack, Inc.Computer Software, 11-50 employees
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
Senior Vice President
IpsosInformation Technology and Services, 10,001+ employees
Vertica
No score
No answers yet
No answers on this topic
Usability
Hadoop
Hadoop 8.5
Based on 5 answers
Great! Hadoop has an easy to use interface that mimics most other data warehouses. You can access your data via SQL and have it display in a terminal before exporting it to your business intelligence platform of choice. Of course, for smaller data sets, you can also export it to Microsoft Excel.
Senior Financial Analyst
Lowe's Companies, Inc.Retail, 10,001+ employees
Vertica
No score
No answers yet
No answers on this topic
Support Rating
Hadoop
Hadoop 6.9
Based on 6 answers
We went with a third party for support, i.e., consultant. Had we gone with Azure or Cloudera, we would have obtained support directly from the vendor. my rating is more on the third party we selected and doesn't reflect the overall support available for Hadoop. I think we could have done better in our selection process, however, we were trying to use an already approved vendor within our organization. There is plenty of self-help available for Hadoop online.
Vice President, Chief Architect, Development Manager and Software Engineer
WySTAR Global Retirement Solutions, a Wells Fargo CompanyFinancial Services, 10,001+ employees
Vertica
Vertica 7.6
Based on 2 answers
I haven't had any recent opportunity to reach out to Vertica support. From what I remember, I believe whenever I reached out to them the experience was smooth.

Verified User
Administrator in Information Technology
Entertainment Company, 1001-5000 employeesOnline 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.
Senior Vice President
IpsosInformation Technology and Services, 10,001+ employees
Vertica
No score
No answers yet
No answers on this topic
Alternatives Considered
Hadoop
Not used any other product than Hadoop and I don't think our company will switch to any other product, as Hadoop is providing excellent results. Our company is growing rapidly, Hadoop helps to keep up our performance and meet customer expectations. We also use HDFS which provides very high bandwidth to support MapReduce workloads.

Verified User
Engineer in Engineering
Computer Software Company, 51-200 employeesVertica
SAP HANA, Oracle, MySQL, and PostgreSQL are too heavyweight for achieving real-time latency requirements. Google BigQuery is limited to Cloud that makes hard to integrate with a large ingestion pipeline that may have both Cloud-based and on-prem components. Hadoop is much more complex to setup. Snowflake is again Cloud-based and is a new player so its reputation is not well known.

Verified User
Analyst in Information Technology
Airlines/Aviation Company, 51-200 employeesReturn on Investment
Hadoop
- Hadoop has allowed us to scale out a few of our tier-1, customer facing applications to provide very fast access to reports and analytics.
- Hadoop was easily implemented by our Linux team and onboarded by our Hadoop Admins.
- Hadoop has been a very stable platform and only goes down due to server patching or other maintenance.
Senior Network Administrator
Vizient, Inc.Hospital & Health Care, 1001-5000 employees
Vertica
- The ROI on fast, interactive querying is very high.
- Table size limitations force us to use other tools, slowing things down.
- Relatively expensive pricing forces us to regularly upgrade our Vertica subscription and database. Each upgrade leads to a downtime of a few days.

Verified User
Analyst in Marketing
Internet Company, 501-1000 employeesPricing Details
Hadoop
General
Free Trial
—Free/Freemium Version
Yes
Premium Consulting/Integration Services
—Entry-level set up fee?
No
Vertica
General
Free Trial
—Free/Freemium Version
—Premium Consulting/Integration Services
—Entry-level set up fee?
No