Apache Hive vs. SAP BW/4HANA

Overview
ProductRatingMost Used ByProduct SummaryStarting Price
Apache Hive
Score 8.2 out of 10
N/A
Apache Hive is database/data warehouse software that supports data querying and analysis of large datasets stored in the Hadoop distributed file system (HDFS) and other compatible systems, and is distributed under an open source license.N/A
SAP BW/4HANA
Score 8.4 out of 10
N/A
SAP BW/4HANA is a next-generation data warehouse solution. It is specifically designed to use the advanced in-memory capabilities of the SAP HANA platform. For example, SAP BW/HANA can integrate many different data sources to provide a single, logical view of all the data. This could include data contained in SAP and non-SAP applications running on-premise or in the cloud, and data lakes, such as those contained in the Apache Hadoop open-source software framework. With SAP BW/4HANA,…N/A
Pricing
Apache HiveSAP BW/4HANA
Editions & Modules
No answers on this topic
No answers on this topic
Offerings
Pricing Offerings
Apache HiveSAP BW/4HANA
Free Trial
NoNo
Free/Freemium Version
NoNo
Premium Consulting/Integration Services
NoYes
Entry-level Setup FeeNo setup feeOptional
Additional Details
More Pricing Information
Community Pulse
Apache HiveSAP BW/4HANA
Top Pros
Top Cons
Features
Apache HiveSAP BW/4HANA
Access Control and Security
Comparison of Access Control and Security features of Product A and Product B
Apache Hive
-
Ratings
SAP BW/4HANA
8.8
1 Ratings
2% above category average
Multi-User Support (named login)00 Ratings9.01 Ratings
Multiple Access Permission Levels (Create, Read, Delete)00 Ratings9.01 Ratings
Single Sign-On (SSO)00 Ratings9.01 Ratings
Location-Based Data Governance00 Ratings8.01 Ratings
Data Modeling
Comparison of Data Modeling features of Product A and Product B
Apache Hive
-
Ratings
SAP BW/4HANA
7.0
1 Ratings
13% below category average
Data model creation00 Ratings7.01 Ratings
Data Exploration
Comparison of Data Exploration features of Product A and Product B
Apache Hive
-
Ratings
SAP BW/4HANA
4.0
1 Ratings
30% below category average
Visualization00 Ratings4.01 Ratings
Data Warehouse
Comparison of Data Warehouse features of Product A and Product B
Apache Hive
-
Ratings
SAP BW/4HANA
6.0
1 Ratings
18% below category average
High-Volume Data Processing00 Ratings8.01 Ratings
Data Warehouse Management00 Ratings8.01 Ratings
Administrative Automation00 Ratings5.01 Ratings
Self-Optimization00 Ratings3.01 Ratings
Best Alternatives
Apache HiveSAP BW/4HANA
Small Businesses
Google BigQuery
Google BigQuery
Score 8.6 out of 10
Google BigQuery
Google BigQuery
Score 8.6 out of 10
Medium-sized Companies
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
Cloudera Enterprise Data Hub
Cloudera Enterprise Data Hub
Score 9.0 out of 10
Enterprises
Oracle Exadata
Oracle Exadata
Score 8.0 out of 10
Oracle Exadata
Oracle Exadata
Score 8.0 out of 10
All AlternativesView all alternativesView all alternatives
User Ratings
Apache HiveSAP BW/4HANA
Likelihood to Recommend
8.0
(35 ratings)
8.0
(9 ratings)
Likelihood to Renew
10.0
(1 ratings)
-
(0 ratings)
Usability
8.5
(7 ratings)
8.0
(2 ratings)
Support Rating
7.0
(6 ratings)
9.7
(7 ratings)
User Testimonials
Apache HiveSAP BW/4HANA
Likelihood to Recommend
Apache
Software work execution is on a large scale, it is good to use for new projects or organizational changes, data lineage mapping has always been dubious but this one has had good results. You can store and synchronize data from different departments, the storage process can be manual but it is best automated.
Read full review
SAP
Some scenarios where SAP BW/4HANA is well suited are retail industry, supply chain, finance, warehouse, stocking processes, BI, [and] some finance analytics reporting. Some scenarios where SAP BW/4HANA is less appropriate [is when] relational queries are needed [and] in some small business with infrastructure limitations. Another scenario that is less appropriate is for ABAP processes requirements.
Read full review
Pros
Apache
  • Apache Hive allows use to write expressive solutions to complex problems thanks to its SQL-like syntax.
  • Relatively easy to set up and start using.
  • Very little ramp-up to start using the actual product, documentation is very thorough, there is an active community, and the code base is constantly being improved.
Read full review
SAP
  • High speed data warehouse regardless of data volumes.
  • Excellent integration with SAP systems and Data sets.
  • Simplified data modelling due to columnar data base.
Read full review
Cons
Apache
  • Some queries, particularly complex joins, are still quite slow and can take hours
  • Previous jobs and queries are not stored sometimes
  • Switching to Impala can sometimes be time-consuming (i.e. the system hangs, or is slow to respond).
  • Sometimes, directories and tables don't load properly which causes confusion
Read full review
SAP
  • Enterprise license pricing is very expensive and run-time license limits the usefulness of the tool.
  • Integration with SAP Analytics cloud for write-back to BW/4HANA. Live connection is only read from SAC.
  • Make run-time licenses more useful.
Read full review
Likelihood to Renew
Apache
Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.
Read full review
SAP
No answers on this topic
Usability
Apache
Hive is a very good big data analysis and ad-hoc query platform, which supports scaling also. The BI processes can be easily integrated with Hadoop via the Hive. It can deal with a much larger data set that traditional RDBMS can not. It is a "must-have" component of the big data domain.
Read full review
SAP
SAP BW/4HANA requires specialized skillsets around data warehouse modeling and the access to data, however the modeling capabilities are intuitive and have now become accessible to both SAP and non-SAP data warehouse specialists. This new model allows for Interchangeable skillsets and access to a broader pool of experts throughout the industry, as well as easier access to data.
Read full review
Support Rating
Apache
Apache Hive is a FOSS project and its open source. We need not definitely comment on anything about the support of open source and its developer community. But, it has got tremendous developer support, awesome documentation. I would justify the fact that much support can be gathered from the community backup.
Read full review
SAP
SAP Max Attention and general support for SAP BW/4HANA is broadly available. Truth to be told, MaxAttention has a premium cost but brings great engineers. So this being an enterprise capability and extremely critical, we did not consider cost as the main factor since support works well. Just keep that in mind when making your selection.
Read full review
Alternatives Considered
Apache
Besides Hive, I have used Google BigQuery, which is costly but have very high computation speed. Amazon Redshift is the another product, I used in my recent organisation. Both Redshift and BigQuery are managed solution whereas Hive needs to be managed
Read full review
SAP
SAP Analytics Cloud is complemented by SAP BW/4 HANA through connectors that work in real-time and allow the display of indicator information in interactive and user-friendly visualizations. SAP Data Services integrates with BW/4 HANA allowing to automate the loading of information in the system taking as a data source a wide variety of platforms.
Read full review
Return on Investment
Apache
  • Apache hive is secured and scalable solution that helps in increasing the overall organization productivity.
  • Apache hive can handle and process large amount of data in a sufficient time manner.
  • It simplifies writing SQL queries, hence helping the organization as most companies use SQL for all query jobs.
Read full review
SAP
  • Faster turn-around to enhancements
  • End users can query structures that are not limited to multi-dimensional models.
  • Performance improvements means that business user can do more in the same time compared to traditional BW
Read full review
ScreenShots

SAP BW/4HANA Screenshots

Screenshot of Next generation data warehousing with SAP BW/4HANA.Screenshot of SAP BW/4HANA user cockpit.Screenshot of Geolocation analytics in SAP BW/4HANA.Screenshot of Data modeling in SAP BW/4HANA.Screenshot of Modern user experience in SAP BW/4HANA.Screenshot of Monitor the performance of your business in real-time with SAP BW/4HANA.