Skip to main content
TrustRadius: an HG Insights Company
Apache Hive

Apache Hive

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.

Read more

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...
Continue reading
Prasanna Kumar TR
Contributor - Research & Development
Developer and Site Contributor
ForgetCode.com
Apache Hive2 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...
Continue reading
Camilo Palacios
Administrator - Marketing
Administrador informático.
Logitech
Apache Hive2 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...
Continue reading
Omkar Marne
Employee - Information Technology
Research Application Software Engineer
University of North Carolina at Charlotte
Apache Hive1 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...
Continue reading
Pablo Gonzalez
Manager - Marketing
Internet Marketing Manager
MKTi México
Apache Hive2 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...
Continue reading
Surendranatha Reddy Chappidi
Engineer - Information Technology
Senior Data Engineer
Maersk
Apache Hive5 years of experience
Log in with LinkedIn to see content from your network
Return to navigation

Pricing

View all pricing
Apache Hive

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

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

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

What is Apache Hive?

Apache Hive Technical Details

Operating SystemsUnspecified
Mobile ApplicationNo

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

Apache Spark

Apache Spark

Compare
Presto

Presto

Compare
PostgreSQL

PostgreSQL

Compare
ClickHouse

ClickHouse

Compare
Snowflake

Snowflake

Compare
Google BigQuery

Google BigQuery

Compare
Azure Data Lake Storage

Azure Data Lake Storage

Compare
Apache Kafka

Apache Kafka

Compare
Oracle Autonomous Data Warehouse

Oracle Autonomous Data Warehouse

Compare
Oracle Exadata

Oracle Exadata

Compare
SAP Business Warehouse

SAP Business Warehouse

Compare
SAP BW/4HANA

SAP BW/4HANA

Compare
Cloudera Enterprise Data Hub

Cloudera Enterprise Data Hub

Compare
IBM Netezza Performance Server

IBM Netezza Performance Server

Compare
OpenText Vertica

OpenText Vertica

Compare
Cloudera Data Platform

Cloudera Data Platform

Compare
1010data

1010data

Compare
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-5 of 35)

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
Apache Hive
2 years of experience
View profile
Use Cases and Deployment Scope
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, and it can be sent to third parties the information already transformed.

Best query platform for ETL.

Rating: 6 out of 10
Incentivized
April 08, 2022
OM
Omkar Marne
Research Application Software Engineer
University of North Carolina at Charlotte (Higher Education, 1001-5000 employees)
Vetted Review
Verified User
Apache Hive
1 year of experience
View profile
Use Cases and Deployment Scope
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 where we can fire SQL queries. Apache Hive was a perfect choice for cleaning data as we were using Apache Hadoop and both are Apache products.

It is an advance to the ease of the processes

Rating: 8 out of 10
Incentivized
April 08, 2022
PG
Pablo Gonzalez
Internet Marketing Manager
MKTi México (Marketing & Advertising, 51-200 employees)
Vetted Review
Verified User
Apache Hive
2 years of experience
View profile
Use Cases and Deployment Scope
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 software that through data the system constantly learns and develops. The first phase is very effective, the analysis and checking of the information are verified in detail.

Apache Hive

Rating: 9 out of 10
Incentivized
November 24, 2021
Use Cases and Deployment Scope
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 create tables. Supported file formats are CSV, Parquet, Avro, JSON. 3. Apache Hive can store billions of records in distributed storage and retrieve them efficiently. 4. Apache hive used spark/ Tez / MapReduce engines in the backend for computation.
Return to navigation