Apache Hive vs Azure Synapse Analytics (Azure SQL Data Warehouse) | TrustRadius

What users are saying about

Score 7.9 out of 10

Based on 81 reviews and ratings

Score 8.4 out of 10

Based on 15 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

It is very cost-effective
Development time needed was much less in comparison to other systems
Played very nicely with our ETL and OLAP reporting tools

Read full review

Samir Patel, PMP

SQL Development Team Lead

Allianz Asset ManagementInvestment Management, 1001-5000 employees

View all 4 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

Limited T-SQL query library
It is not suitable for OLTP environment
Doesn't support cross-database queries

Read full review

Prabhu Sundararaj

Associate - Project

CognizantInformation Technology & Services, 10,001+ employees

View all 4 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

Azure Synapse Analytics (Azure SQL Data Warehouse) 8.0

Based on 1 answer

It helps us to provide data just in time to our clients. With help of massively parallel processing, it consumes less time for both loading and querying the data and it also helps us to plan a more precise budget to our business and send just-in-time alerts in case of any outrage.

Read full review

Prabhu Sundararaj

Associate - Project

CognizantInformation Technology & Services, 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

Azure Synapse Analytics (Azure SQL Data Warehouse) 8.1

Based on 3 answers

I like their Support team

Read full review

Verified User

Consultant in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 3 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

SQL Data Warehousing is much easier to manage if you already have SQL Server experience and analysts who are familiar with its interface. We are currently piloting using NoSQL and Hadoop type databases but it is difficult to get set up properly. Additionally, we have to re-train our users to learn how to create python scripts and use spark to query the data

Read full review

Verified User

Contributor in Information Technology

Information Technology and Services Company, 10,001+ employees

View all 4 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

We have had an improvement in our overall processing time
Cost was much lower than most of its competitors
Our reporting needs have grown and housing the data here has been great

Read full review

Samir Patel, PMP

SQL Development Team Lead

Allianz Asset ManagementInvestment Management, 1001-5000 employees

View all 4 answers on this topic

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

—

Entry-level set up fee?

No

Add comparison