Apache Hive
Take advantage of Apache Hadoop ecosystem power with Hive, an SQL-friendly open-source data warehouse software.
Heavy machinery mines materials at a worksite


Mine data quicker with SQL intellect

Apache Hadoop is scalable and cost-effective when processing large data volumes, so it's a popular open-source framework for many organizations.

Unfortunately, enterprises with traditional data warehouses are usually based on Structured Query Language (SQL), making the Apache Hadoop ecosystem difficult for users and developers who have relied on SQL queries to extract data.

With Apache Hive's SQL intellect, you can write SQL-like queries called hive query language (HQL) to extract data from Hadoop without learning another language, taking advantage of Hadoop's power to save you time and money.


Apply structure to unstructured data Apache Hive helps you read, write and manage large datasets from distributed storage with speed and SQL ease. Gain insights faster and better

Because Hive is built on top of Hadoop, it offers the same speed, flexibility and scalability that Hadoop is known for.

Use the programming language you know

Using an SQL-like interface, developers can write HQL statements similar to standard SQL statements for data query and analysis, saving them the need to learn a new programming language.

Understand details about your data

Get to the bottom of data by extracting and viewing it in various dimensions-consolidated, drilled-down or sliced and diced-with online analytical processing (OLAP) capabilities.


Apache solutions from IBM Drive better, faster analytics with Apache through IBM analytics solutions. IBM Db2® Big SQL

IBM Db2 Big SQL is a hybrid SQL engine for Apache Hadoop. It can concurrently exploit Hive, HBase and Spark using a single database connection or query.

Explore Db2 Big SQL
IBM Open Data Analytics for z/OS

Optimize open-source technologies runtime-including Apache Spark, Anaconda and Python-and gain insights from data at its source.

Explore Open Data Analytics for z/OS
IBM InfoSphere® Classic Federation Server for z/OS

Access and integrate diverse data and content sources as a single resource regardless of where the information resides.

Explore IBM InfoSphere Classic Federation Server for z/OS
IBM and Cloudera

IBM and Cloudera have partnered to offer an industry-leading, enterprise-grade Hadoop distribution, including an integrated ecosystem of products and services to support faster analytics at scale.

See how IBM and Cloudera deliver better big data solutions

Use Cases

See Apache Hive in action Access Hive data faster and more securely with Db2 Big SQL. See results from 1 TB and 10 TB performance tests and highlights of security benefits. Watch the video (11:10)
Engage with an expert
Schedule a no-cost, one-on-one call with an IBM big data expert to learn how to extend data science and machine learning across the Apache Hadoop ecosystem.
Get connected Apache Hadoop community Explore Apache Hadoop Cognitive class Journey to AI blog