We performed a comparison between SAP HANA and Spark SQL based on real PeerSpot user reviews.
Find out in this report how the two Hadoop solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."SAP HANA's best features are its programmability and extensibility - you can size and shape the software however you need."
"The solution is extremely stable. That's the most important aspect of the solution, for our organization. There is no downtime, and the performance is very good."
"We appreciate that the current, redesigned version of this solution that is much more straightforward for new users, and has been well thought out with industry best practice standards in mind."
"Its in-memory capabilities are good, which is why many companies still use it."
"When we upgraded, we received more functions or more features."
"The main feature is that the processes are very flexible, they are able to be adapted to the business and their departments."
"The most valuable features I have found are speed, dashboard, and reporting."
"The speed at which it gets the data is great."
"Spark SQL's efficiency in managing distributed data and its simplicity in expressing complex operations make it an essential part of our data pipeline."
"Certain data sets that are very large are very difficult to process with Pandas and Python libraries. Spark SQL has helped us a lot with that."
"Offers a variety of methods to design queries and incorporates the regular SQL syntax within tasks."
"The performance is one of the most important features. It has an API to process the data in a functional manner."
"The speed of getting data."
"I find the Thrift connection valuable."
"One of Spark SQL's most beautiful features is running parallel queries to go through enormous data."
"Data validation and ease of use are the most valuable features."
"The documentation can be improved in the future."
"The initial setup of SAP HANA is complex. We did the implementation of one site, and a global deployment will take another three to four years."
"The solution's development platform should be more flexible and scalable to adapt to other solutions."
"There could be better management for faster updates, last year there were some changes in India to the e-invoicing feature."
"I would have rated the solution higher if this version was not missing some key features the newer version has."
"The worst thing about SAP HANA is the price; it's very expensive. The licensing cost, implementation cost, hosting cost, and appliance cost are all high."
"I think that the pricing is high and it needs improvement."
"The user experience should be better. Its user interface is not good. I also don't like the transition concept."
"It takes a bit of time to get used to using this solution versus Pandas as it has a steep learning curve."
"In the next update, we'd like to see better performance for small points of data. It is possible but there are better tools that are faster and cheaper."
"It would be beneficial for aggregate functions to include a code block or toolbox that explains its calculations or supported conditional statements."
"SparkUI could have more advanced versions of the performance and the queries and all."
"It would be useful if Spark SQL integrated with some data visualization tools."
"In terms of improvement, the only thing that could be enhanced is the stability aspect of Spark SQL."
"This solution could be improved by adding monitoring and integration for the EMR."
"There should be better integration with other solutions."
SAP HANA is ranked 1st in Embedded Database with 79 reviews while Spark SQL is ranked 4th in Hadoop with 14 reviews. SAP HANA is rated 8.4, while Spark SQL is rated 7.8. The top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". On the other hand, the top reviewer of Spark SQL writes "Offers the flexibility to handle large-scale data processing". SAP HANA is most compared with Oracle Database, SQL Server, MySQL, IBM Db2 Database and Apache Spark, whereas Spark SQL is most compared with Apache Spark, IBM Db2 Big SQL, HPE Ezmeral Data Fabric and Netezza Analytics. See our SAP HANA vs. Spark SQL report.
See our list of best Hadoop vendors.
We monitor all Hadoop 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.