We performed a comparison between Actian Ingres and Apache Hadoop based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server."
"Most valuable features are HDFS and Kafka: Ingestion of huge volumes and variety of unstructured/semi-structured data is feasible, and it helps us to quickly onboard a new Big Data analytics prospect."
"It's good for storing historical data and handling analytics on a huge amount of data."
"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."
"Initially, with RDBMS alone, we had a lot of work and few servers running on-premise and on cloud for the PoC and incubation. With the use of Hadoop and ecosystem components and tools, and managing it in Amazon EC2, we have created a Big Data "lab" which helps us to centralize all our work and solutions into a single repository. This has cut down the time in terms of maintenance, development and, especially, data processing challenges."
"The performance is pretty good."
"Since both Apache Hadoop and Amazon EC2 are elastic in nature, we can scale and expand on demand for a specific PoC, and scale down when it's done."
"It is a file system for data collection. There are nodes in this cluster that contain all the information, directories, and other files. The nodes are based on the MySQL database."
"The ability to reset the log file without stopping the DBMS would be helpful for us."
"I would like to see more direct integration of visualization applications."
"I think more of the solution needs to be focused around the panel processing and retrieval of data."
"It would be good to have more advanced analytics tools."
"In the next release, I would like to see Hive more responsive for smaller queries and to reduce the latency."
"It requires a great deal of learning curve to understand. The overall Hadoop ecosystem has a large number of sub-products. There is ZooKeeper, and there are a whole lot of other things that are connected. In many cases, their functionalities are overlapping, and for a newcomer or our clients, it is very difficult to decide which of them to buy and which of them they don't really need. They require a consulting organization for it, which is good for organizations such as ours because that's what we do, but it is not easy for the end customers to gain so much knowledge and optimally use it."
"The integration with Apache Hadoop with lots of different techniques within your business can be a challenge."
"The load optimization capabilities of the product are an area of concern where improvements are required."
"General installation/dependency issues were there, but were not a major, complex issue. While migrating data from MySQL to Hive, things are a little challenging, but we were able to get through that with support from forums and a little trial and error."
Earn 20 points
Actian Ingres is ranked 22nd in Data Warehouse while Apache Hadoop is ranked 5th in Data Warehouse with 33 reviews. Actian Ingres is rated 9.0, while Apache Hadoop is rated 7.8. The top reviewer of Actian Ingres writes "Good multi-platform SQL compatibility, as well as performance and data integrity". On the other hand, the top reviewer of Apache Hadoop writes "A file system for data collection that contains needed information and files". Actian Ingres is most compared with Snowflake, Oracle Database Appliance, Databricks and Teradata, whereas Apache Hadoop is most compared with Azure Data Factory, Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake and Teradata.
See our list of best Data Warehouse vendors.
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.