Pros and Cons of Apache Hive 2025

Overview

What is Apache Hive?

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.

Learn from top reviewers

Best Distributed Database in the market

Rating: 6 out of 10

April 19, 2022

IncentivizedVetted ReviewVerified User

We use Apache Hive to store a large set of data, which are huge documents such as problem statements and its answer, not only submitted by the site owners but also by the user...

Prasanna Kumar TR

Contributor - Research & Development

Developer and Site Contributor

ForgetCode.com

2 years of experience

This system makes active data of value.

Rating: 8 out of 10

April 9, 2022

IncentivizedVetted ReviewVerified User

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 differe...

Camilo Palacios

Administrator - Marketing

Administrador informático.

Logitech

2 years of experience

Best query platform for ETL.

Rating: 6 out of 10

April 8, 2022

IncentivizedVetted ReviewVerified User

I used Apache Hive on top of Hadoop for filtering and cleaning data using SQL. It was the part of the project which I was working on. Apache Hive gives SQL-like a platform whe...

Omkar Marne

Employee - Information Technology

Research Application Software Engineer

University of North Carolina at Charlotte

1 year of experience

It is an advance to the ease of the processes

Rating: 8 out of 10

April 8, 2022

IncentivizedVetted ReviewVerified User

The software is intuitive from the first steps, one of the first features we take into account for the software does not allow duplicate files to be stored. It is advanced sof...

Pablo Gonzalez

Manager - Marketing

Internet Marketing Manager

MKTi México

2 years of experience

Apache Hive

Rating: 9 out of 10

November 24, 2021

IncentivizedVetted ReviewVerified User

1. Used Apache Hive to create external and internal tables in Hadoop / BigData projects on Cloudera and Azure platforms. 2. Apache Hive supports different file formats to crea...

Surendranatha Reddy Chappidi

Engineer - Information Technology

Senior Data Engineer

Maersk

5 years of experience

Log in with LinkedIn to see content from your network

Return to navigation

Pricing

View all pricing

Apache Hive

N/A

Unavailable

What is Apache Hive?

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.

Entry-level set up fee?

No setup fee

Offerings

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

26 people also want pricing

Alternatives Pricing

ClicData

$79

per month

What is ClicData?

ClicData is a 100% cloud-based business intelligence platform that allows users to connect, process, blend, visualize and share data from a single place. As an automated platform, users are able to rely on the latest version of company data, to ensure users make the right decisions. Hundreds of…

retailMetrix

$399

per month per installation

What is retailMetrix?

RetailMetrix is a data analytics platform for retailers with the mission of enabling retailers to get value from their data. RetailMatrix processes and stores sales, labor and customer data using data warehouse technologies. Its dashboards and reports allows team to find the data that matters to…

Return to navigation

Product Demos

Apache Hive Hadoop Ecosystem - Big Data Analytics Tutorial by Mahesh Huddar

YouTube

Connecting Microsoft Power BI to Apache Hive using Simba Hive ODBC driver

YouTube

Discover HDP 2.1: Interactive SQL Query in Hadoop with Apache Hive

YouTube

Return to navigation

Product Details

About
Tech Details
FAQs

What is Apache Hive?

Apache Hive Technical Details

Operating Systems	Unspecified
Mobile Application	No

Frequently Asked Questions

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.

Reviewers rate Usability highest, with a score of 8.5.

The most common users of Apache Hive are from Enterprises (1,001+ employees).

Return to navigation

Comparisons

View all alternatives

Compare with

Reviews From Top Reviewers

View all reviews

(1-5 of 35)

Sort By *

This system makes active data of value.

Rating: 8 out of 10

Incentivized

April 09, 2022

CP

Camilo Palacios

Administrador informático.

Logitech (Marketing & Advertising, 51-200 employees)

Vetted Review

Verified User

2 years of experience

View profile

Pros

Please provide some detailed examples of things that Apache Hive does particularly well.
Migration to the cloud is modern and very secure.

Cons

The best way to do this is to schedule the extraction at times established by hours and quantities.
So that it can be used normally in daily use, it must be taken into account that the maintenance management of the system so that it works effectively.