Anonymous UserCo-Founder at a tech services company
We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
"The best thing about this solution is that it is very powerful and very cheap."
"What comes with the standard setup is what we mostly use, but Ambari is the most important."
"The ability to add multiple nodes without any restriction is the solution's most valuable aspect."
"It's good for storing historical data and handling analytics on a huge amount of data."
"The most valuable feature is the database."
"The most valuable features are powerful tools for ingestion, as data is in multiple systems."
"The solution is easy to expand. We haven't seen any issues with it in that sense. We've added 10 servers, and we've added two nodes. We've been expanding since we started using it since we started out so small. Companies that need to scale shouldn't have a problem doing so."
"The performance is pretty good."
"Unbeatable speed and compression with a colummn-structured relational database."
"The upgrade path should be improved because it is not as easy as it should be."
"In the next release, I would like to see Hive more responsive for smaller queries and to reduce the latency."
"There is a lack of virtualization and presentation layers, so you can't take it and implement it like a radio solution."
"The solution could use a better user interface. It needs a more effective GUI in order to create a better user environment."
"It would be good to have more advanced analytics tools."
"It would be helpful to have more information on how to best apply this solution to smaller organizations, with less data, and grow the data lake."
"The solution needs a better tutorial. There are only documents available currently. There's a lot of YouTube videos available. However, in terms of learning, we didn't have great success trying to learn that way. There needs to be better self-paced learning."
"The solution is very expensive."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
Earn 20 points
SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.
Apache Hadoop is ranked 3rd in Data Warehouse with 9 reviews while SAP IQ is ranked 11th in Data Warehouse with 1 review. Apache Hadoop is rated 7.6, while SAP IQ is rated 8.0. The top reviewer of Apache Hadoop writes "Great micro-partitions, helpful technical support and quite stable". On the other hand, the top reviewer of SAP IQ writes "An excellent column-based, enterprise relational database solution with good speed and compression". Apache Hadoop is most compared with Snowflake, Microsoft Azure Synapse Analytics, VMware Tanzu Greenplum, Oracle Exadata and Oracle Big Data Appliance, whereas SAP IQ is most compared with SAP Adaptive Server Enterprise, SAP HANA, Oracle Database, Snowflake and SQL Server.
We monitor all 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.