Apache Hive vs SAP BW/4HANA | TrustRadius

What users are saying about

Score 7.9 out of 10

Based on 81 reviews and ratings

Score 8.9 out of 10

Based on 28 reviews and ratings

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.

Read full review

Bharadwaj (Brad) Chivukula

Sr.Technical Manager/Delivery Manager

Nisum Technologies, Inc.Retail, 10,001+ employees

View all 25 answers on this topic

Near real-time data replication from HANA databases.
Strong BW functionality.
A host of cloud reporting tools can seamlessly connect to it.

Read full review

Product Owner - Management Reporting SAP S4 / HANA

HP IncInformation Technology and Services, 10,001+ employees

View all 7 answers on this topic

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.

Read full review

Verified User

Analyst in Engineering

Hospital & Health Care Company, 501-1000 employees

View all 25 answers on this topic

ETL implementation can be complicated
Integration with non-SAP systems can take a long time
Cost to implement and maintain can be high, even in Cloud

Read full review

Verified User

Executive in Information Technology

Consumer Goods Company, 10,001+ employees

View all 7 answers on this topic

Likelihood to Renew

Apache Hive 10.0

Based on 1 answer

Since I do not know the second data warehouse solution that integrate with HDFS as well as Hive.

Read full review

Senior Data Scientist

CARD.comFinancial Services, 11-50 employees

View all 1 answers on this topic

No score

No answers yet

No answers on this topic

Usability

Apache Hive 8.5

Based on 9 answers

Thanks to its high usability Apache Hive enables users to craft extensive queries really efficiently and at the same time to how to hold response times very low. HiveQL simplicity makes it super easy to manage large datasets, what was almost an impossible task before introduction of Apache Hive data warehousing platform in our company.

Read full review

Verified User

Team Lead in Information Technology

Internet Company, 10,001+ employees

View all 9 answers on this topic

SAP BW/4HANA 9.0

Based on 1 answer

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

Verified User

Director in Information Technology

Telecommunications Company, 10,001+ employees

View all 1 answers on this topic

Support Rating

Apache Hive 7.1

Based on 8 answers

Hive also has a community platform of its own just like other Hadoop frameworks. Most of the queries/problems are resolved in the community itself. We can just post our problems or get in touch with a specific user and get the issue resolved. Otherwise there is always the product support team for any resolution.

Read full review

Partha Protim Pegu

Domain Consultant

InfosysInformation Technology & Services, 10,001+ employees

View all 8 answers on this topic

SAP BW/4HANA 9.3

Based on 9 answers

SAP offers specialized support since it is a relatively new product and it is necessary to be able to push the platform.

Read full review

Gerente de Consultoría

SEIDOR AnalyticsInformation Technology and Services, 201-500 employees

View all 9 answers on this topic

Alternatives Considered

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

Senior Manager - Engineering

Hike MessengerInternet, 51-200 employees

View all 25 answers on this topic

Unfortunately I never had the chance to work with other tools similar to SAP BW/4HANA. In the different companies I've worked for during the past 4 years, they all used SAP, and in particular I worked in SAP BW during the last year.

Read full review

Verified User

Employee in Marketing

Electrical & Electronic Manufacturing Company, 5001-10,000 employees

View all 7 answers on this topic

Return on Investment

It exposes the distributed calculation world (Hadoop) to the users but doesn't require the user to have the in-depth understanding of boilerplate details, it reduces the time of learning and let the data analyst can focus their efforts on the core business.

Read full review

Verified User

Strategist in Information Technology

Package/Freight Delivery Company, 10,001+ employees

View all 25 answers on this topic

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

Senior Technical Specialist

Rio TintoMining & Metals, 10,001+ employees

View all 7 answers on this topic

Screenshots

—

See All (6) SAP BW/4HANA Screenshots

Pricing Details

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

—

Entry-level set up fee?

No

General

Free Trial

—

Free/Freemium Version

—

Premium Consulting/Integration Services

Yes

Entry-level set up fee?

Optional

Add comparison