Apache Hive vs. SAP Business Warehouse

Apache Hive

SAP Business Warehouse

Overview
Product	Rating	Most Used By	Product Summary	Starting Price
Apache Hive	Score 8.0 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	Score 8.6 out of 10	N/A	SAP Business Warehouse, or SAP BW (formerly SAP NetWeaver Business Warehouse) is SAP's legacy data warehouse solution, now superseded by SAP BW/4HANA, and the SAP Data Warehouse Cloud which was launched in 2019. SAP BW versions up to 7.4 have reached end of maintenance. SAP BW 7.5 support is extended to align with SAP Business Suite with NetWeaver components. For existing customers maintenance is scheduled to continue through 2027, with extended support available through 2030.	N/A

Pricing

Apache Hive

SAP Business Warehouse

Editions & Modules

No answers on this topic

Offerings

Pricing Offerings
Apache Hive	SAP BW
Free Trial
No	No
Free/Freemium Version
No	No
Premium Consulting/Integration Services
No	No

Entry-level Setup Fee

No setup fee

Additional Details

—

More Pricing Information

Community Pulse
	Apache Hive	SAP Business Warehouse
Considered Both Products	Apache Hive Verified User Anonymous Chose Apache Hive To query a huge, distributed dataset, Apache Hive was built by Facebook. Unlike Apache Hive, Apache Spark is an in-memory computation engine, which is why it is significantly quicker than Apache Hive at querying large amounts of data. In contrast to Apache HBase, Apache Hive is … Incentivized Helpful? Prasanna Kumar TR Developer and Site Contributor Chose Apache Hive Apache hive gave more flexible than MS SQL server. ElasticSearch was little complex. GoogleBigQuery cost more. Incentivized Helpful? Verified User Anonymous Chose Apache Hive Community support and ease of use -not deployment. It enables querying and analyzing large amounts of data stored in HDFS, on the petabyte scale. It has a query language called HQL that transforms SQL queries into MapReduce jobs that run on Hadoop, and it is wonderful for the … Incentivized Helpful? Verified User Anonymous Chose Apache Hive Apache Spark is similar in the sense that it too can be used to query and process large amounts of data through its Dataframe interface. Hive is better for short-term querying while Spark is better for persistent and long-term analysis. Another product is Impala. For our … Incentivized Helpful? Camilo Palacios Administrador informático. Chose Apache Hive We have used a simple but necessary function such as merging certain data tables, which although they may be from different areas, complement each other or are necessary, you can use metadata if what you need is to validate the origin of your information and what impact it has, … Incentivized Helpful? Omkar Marne Research Application Software Engineer Chose Apache Hive Apache Hadoop is built on top of the Hadoop File system so it gives its best when integrated with Hadoop. Data analysis and query optimization become very easy when used with Hadoop to perform Extract transform load operations. As Hadoop is a big data system and handles large … Incentivized Helpful? Pablo Gonzalez Internet Marketing Manager Chose Apache Hive We have used the system to migrate data either for new versions or because we will use another operating program, the software helps us to synchronize programs between different operating systems, a history of information can be kept constant, it can be sent to third parties … Incentivized Helpful? Verified User Anonymous Chose Apache Hive Queries are easy to write and interface is similar to SQL so learning overhead is reduced. Multi user and data type support is provided. Can be easily scaled for very large amount of analytics. It is very flexible in terms of using file formats. Incentivized Helpful? Verified User Anonymous Chose Apache Hive Snowflake, Splunk Cloud, Talend Open Studio, Azure Data Factory and Apache Spark Incentivized Helpful? Verified User Anonymous Chose Apache Hive Due to effective queries resolved time and the performance and user-friendly framework compared to other products. Incentivized Helpful? Surendranatha Reddy Chappidi Senior Data Engineer Chose Apache Hive Azure Synapse Analytics (Azure SQL Data Warehouse) and Databricks Lakehouse Platform (Unified Analytics Platform) Incentivized Helpful? akshay kashyap CONSULTANT Chose Apache Hive Apache Hive is a query language developed by Facebook to query over a large distributed dataset. Apache is a query engine that runs on top of HDFS, so it utilizes the resources of HDFS Hadoop setup, while Apache Spark is an in memory compute engine, and that's why [it is] much … Incentivized Helpful? Manjeet Singh Senior Manager - Engineering Chose Apache Hive 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 Incentivized Helpful? Verified User Anonymous Chose Apache Hive Hive and Spark have the same parent company hence they share a lot of common features. Hive follows SQL syntax while Spark has support for RDD, DataFrame API. DataFrame API supports both SQL syntax and has custom functions to perform the same functionality. Spark is faster and … Incentivized Helpful? Verified User Anonymous Chose Apache Hive Apache Hive decouples the query layer from the storage layer, it is more flexible and expandable. Incentivized Helpful? Ananth Gouri Assistant Professor Chose Apache Hive One of the major advantages of using Presto or the main reason why people use Presto (Teradata) is due to that fact it can support multiple data sources - which is lacking as in the case of Apache Hive. But still, most people who come from a Structured data-based background … Incentivized Helpful? Nicolas Hubert Machine Learning Engineer Chose Apache Hive Easy to understand, well supported by the community, good documentation. However, it is possible that SAP Business Warehouse could be a good fit, too, even maybe better. I did not have the chance to try it though. We selected Apache Hive because it was far less expensive and … Incentivized Helpful? Kartik Chavan Data Science Trainee Chose Apache Hive I considered Hive because it is the best suited option when it comes to larger data access. Besides, learning HiveQL is comparatively easy. Incentivized Helpful? Verified User Anonymous Chose Apache Hive I have used Storm for real-time processing, but that only addresses a few data points. But for a larger access to data, Hive is well suited. Incentivized Helpful? Verified User Anonymous Chose Apache Hive [We selected Apache Hive because] It's from apache and opensource. So it's free. Incentivized Helpful? Tejaswar Rao Associate Consultant Chose Apache Hive Faster response time and also can handle complex analytical queries Can able to write custom function using python and hive Able to connect using hadoop components and also using R Incentivized Helpful? Bharadwaj (Brad) Chivukula Sr.Technical Manager/Delivery Manager Chose Apache Hive For storing bulk amount of data in a tabular manner, and where there's no need need of primary key, or just in case, if redundant data is received, it will not cause a problem. For small amounts of data, it does run MR, so beware. If your intention is to use it as a … Incentivized Helpful? Sameer Gupta Senior Data Analyst Chose Apache Hive I wasn't part of the evaluation process for Apache Hive. This was already implemented when I joined the company. I have worked with other big data plaftforms and I personally thinks most of them are quite comporable to one another. It really depends on what the company is going … Incentivized Helpful? Verified User Anonymous Chose Apache Hive Hive is SQL compliant which makes it easy for the data folks compared to Pig Incentivized Helpful? Verified User Anonymous Chose Apache Hive Apache Pig is probably the most direct technology to compare to Hive and has several different use cases to Hive. If you want to simplify processing tasks that run using MapReduce then Apache Pig may be a better tool for the job. However if you are going to be running many … Incentivized Helpful?	SAP BW Juan Carlos Crespo Rojas Senior SAP Consultant Chose SAP BW The word "against" would not be the right word to describe this question. These applications coexist and interact, as all of them play a specific role in the SAP landscape. The use of any of these applications should be aligned with the data strategy in an Organization. Incentivized Helpful? Parijatam S Lead Consultant Chose SAP BW Its good for data modelling and ease of reporting capabilities. Even designing base master data models is complex but once done it makes life very easy for any reporting that involves hierarchies/ text & direct/indirect attributes even. It does not have capabilities for … Incentivized Helpful? Niloofar Keshvari Nia IT Operations and Support Specialist Chose SAP BW Coordination and integration with other SAP software and products, as well as its speed and simplicity in reporting, make it one of our current choices Incentivized Helpful? Kartik Chavan Business Data Analyst Chose SAP BW The main reason we chose SAP was the price. SAP Business Warehouse was relatively cheaper compared to other alternatives. SAP Business Warehouse is very popular software for reporting purposes and data storage. But also, it is hard to shift to a newer software once the roots … Incentivized Helpful? Verified User Anonymous Chose SAP BW None Incentivized Helpful? Julius Shen Senior System Analyst Chose SAP BW SAP Business Warehouse scores higher in data warehouse functionalities for integration to SAP ERP and other SAP solutions such as SAP CRM, SAP APO, and SAP SRM. Standard SAP data source extractors which are available in SAP ERP can be used immediately for full or delta … Incentivized Helpful? BB Brandi Brown-Lang Sales and Purchasing Administrator Chose SAP BW SAP Business Warehouse just has better visibility on warehouse flows than some of the other SAP software. I think it is easier to use, and it makes some really great reports that are able to export to excel without much effort. This makes it easy to send customers as well as … Incentivized Helpful? Gustavo Porporato Daher CFO (Chief Financial Officer) Chose SAP BW We evaluated against Microsoft and database systems. SAP stands out due to simplicity to get the data coming from SAP ERP. Incentivized Helpful? Sam Figueroa Associate Staff Systems Specialist Chose SAP BW SAP business warehouse was chosen years ago along with our current ERP software. It currently doesn't stack up well against newer software such as IBM Cognos, or SAS Business Intelligence. The positive side, is that the software has been around for many years and it is easy to … Incentivized Helpful? Vivek Gupta BI Consultant Chose SAP BW My client was an SAP shop client where they have SAP ECC. Using SAP BW helps them to save development time on extractors which are readily available in SAP BW. Also, the tight integration with SAP ECC helps to further reduce the time. The users here were Excel friendly so they … Incentivized Helpful? Mark Liston Solutions Architect Chose SAP BW I have previously used Microstrategy Analytics for reporting and I can confidentially say this is a better option. First, we can do all ETL in the system and not have to rely on another tool. Second, it is easy to integrate with the SAP Lumira platform which seems to be much … Incentivized Helpful? SP Sandesh Pasari Marketing manager Chose SAP BW Zoho Analytics and Tableau Prep Incentivized Helpful?

Features

Apache Hive

SAP Business Warehouse

Access Control and Security

Comparison of Access Control and Security features of Product A and Product B
	Apache Hive - Ratings	SAP Business Warehouse 8.5 Ratings 3% below category average
Multi-User Support (named login)	00 Ratings	9.50 Ratings
Multiple Access Permission Levels (Create, Read, Delete)	00 Ratings	8.50 Ratings
Single Sign-On (SSO)	00 Ratings	9.50 Ratings
Location-Based Data Governance	00 Ratings	6.40 Ratings

Data Modeling

Comparison of Data Modeling features of Product A and Product B
	Apache Hive - Ratings	SAP Business Warehouse 8.7 Ratings 10% above category average
Data model creation	00 Ratings	8.70 Ratings

Data Exploration

Comparison of Data Exploration features of Product A and Product B
	Apache Hive - Ratings	SAP Business Warehouse 5.4 Ratings 3% above category average
Visualization	00 Ratings	5.40 Ratings

Data Warehouse

Comparison of Data Warehouse features of Product A and Product B
	Apache Hive - Ratings	SAP Business Warehouse 7.5 Ratings 2% below category average
High-Volume Data Processing	00 Ratings	7.90 Ratings
Data Warehouse Management	00 Ratings	9.00 Ratings
Administrative Automation	00 Ratings	7.50 Ratings
Self-Optimization	00 Ratings	5.60 Ratings

Best Alternatives
	Apache Hive	SAP Business Warehouse
Small Businesses	Google BigQuery Score 8.4 out of 10	Google BigQuery Score 8.4 out of 10
Medium-sized Companies	Cloudera Enterprise Data Hub Score 9.0 out of 10	Cloudera Enterprise Data Hub Score 9.0 out of 10
Enterprises	Oracle Exadata Score 10.0 out of 10	Oracle Exadata Score 10.0 out of 10
All Alternatives	View all alternatives	View all alternatives

User Ratings
	Apache Hive	SAP Business Warehouse
Likelihood to Recommend	8.0 (0 ratings)	8.4 (0 ratings)
Likelihood to Renew	10.0 (0 ratings)	- (0 ratings)
Usability	8.5 (0 ratings)	- (0 ratings)
Support Rating	7.0 (0 ratings)	- (0 ratings)

User Testimonials
	Apache Hive	SAP Business Warehouse
Likelihood to Recommend	Apache Hive shines for ad-hoc analysis and plugging into BI tools. Its SQL-like syntax allows for ease of use not for only for engineers but also for data analysts. Through our experience, there are probably more desirable tools to use if you are planning on integrating Hive into your processing pipeline. Incentivized Verified User Anonymous Read full review	SAP BW is best for: 1. Large enterprises 2. Enterprises with 3+ legacy systems with entrenched users (politically difficult to merge) 3. Enterprises with employees who can understand both the technical capabilities of SAP BW and the needs of the business users - ability to speak both languages, otherwise the program could be unwieldy and potentially underutilized (it's not particularly inexpensive) SAP BW is less appropriate for: 1. Small enterprises 2. Enterprises who have well established, same location, CRM and UFS - the integration of data analysis will be easier and less expensive with other solutions 3. HANA Incentivized Jeff Looby, CPA Associate Read full review
Pros	Hive syntax is almost like SQL, so for someone already familiar with SQL it takes almost no effort to pick up Hive. To be able to run map reduce jobs using json parsing and generate dynamic partitions in parquet file format. Simplifies your experience with Hadoop especially for non-technical/coding partners. Incentivized Bharadwaj (Brad) Chivukula Sr.Technical Manager/Delivery Manager Read full review	ETL, great at taking data from OLTP source, flat file, etc... Easy drag and drop for transformations. Great reporting possibilities, easy to connect with BO, BPC, etc... Great Master Data Management (MDM )for BPC - helps us maintain master data for BPC. Incentivized Mark Liston Solutions Architect Read full review
Cons	Use Hive for analytical work loads. Write once and read many scenarios. Do not prefer updates and deletes. Behind scenes Hive creates map reduce jobs. Hive performance is slow compared to Apache Spark. Map reduce writes the intermediate outputs to dial whereas Spark operates in in-memory and uses DAG. Incentivized Verified User Anonymous Read full review	Age of software is showing as it struggles with very large data modules, which were not as prevalent in its early years Querying performance at times can be very slow Support and development for BEx has been discontinued or hard to find. Incentivized Sam Figueroa Associate Staff Systems Specialist Read full review
Likelihood to Renew	Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive. Yinghua Hu Senior Data Scientist Read full review	No answers on this topic
Usability	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. Incentivized Verified User Anonymous Read full review	It needs minimal trainings and can perform tasks of data management and reporting. Incentivized Sandesh Pasari Marketing manager Read full review
Support Rating	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. Incentivized Ananth Gouri Assistant Professor Read full review	No answers on this topic
Alternatives Considered	We have used a simple but necessary function such as merging certain data tables, which although they may be from different areas, complement each other or are necessary, you can use metadata if what you need is to validate the origin of your information and what impact it has, is also feasible. Incentivized Camilo Palacios Administrador informático. Read full review	SAP Business Warehouse scores higher in data warehouse functionalities for integration to SAP ERP and other SAP solutions such as SAP CRM, SAP APO, and SAP SRM. Standard SAP data source extractors which are available in SAP ERP can be used immediately for full or delta replication into SAP Business Warehouse. System governance in SAP Business Warehouse is top-notch with change management support for migration between system landscape from the development system to production system. Incentivized Julius Shen Senior System Analyst Read full review
Return on Investment	Good ROI for being able to access data easily across the network, we have large amounts of data and this is a good system to access it Good ROI for being easy to learn how to use for new employees, not much time spent which saves costs Good ROI for being able to integrate with Spark and other applications, hence data can be analyzed through programs Incentivized Verified User Anonymous Read full review	It has helped cut down on parts shortages with the minimum stock flags. People are able to track down parts easier because they can see where they were last used. Our sales team has better visibility on lead times so they can accurately quote our customers. Incentivized BB Brandi Brown-Lang Sales and Purchasing Administrator Read full review
ScreenShots