Installing Apache Hive: A Step-by-Step Guide

Apache Hive is a data warehousing infrastructure built on top of Hadoop. It provides a mechanism to query and analyze large datasets stored in Hadoop's distributed file system (HDFS) using a SQL-like language called HiveQL. In this blog post, we'll walk through the installation process for Apache Hive on a Unix-based system.


link to this section

Before installing Apache Hive, ensure you have the following prerequisites:

  • Java Development Kit (JDK) installed (version 8 or higher recommended)
  • Hadoop installed and configured

Step 1: Download Apache Hive

link to this section

First, download the latest version of Apache Hive from the official Apache Hive website or using a package manager like wget . Extract the downloaded archive to a directory of your choice.

tar -xzvf apache-hive-x.y.z-bin.tar.gz 

Step 2: Configure Environment Variables

link to this section

Set the following environment variables in your .bashrc or .bash_profile file:

export HIVE_HOME=/path/to/hive 
export PATH=$PATH:$HIVE_HOME/bin 

Replace /path/to/hive with the actual path where you extracted Apache Hive.

Step 3: Configure Hive Configuration Files

link to this section

Navigate to the conf directory inside the Hive installation directory and make a copy of the hive-default.xml.template file as hive-site.xml .

cd /path/to/hive/conf 
cp hive-default.xml.template hive-site.xml 

Edit hive-site.xml and configure the necessary properties such as javax.jdo.option.ConnectionURL , javax.jdo.option.ConnectionDriverName , javax.jdo.option.ConnectionUserName , and javax.jdo.option.ConnectionPassword to connect to the metastore database. You may also need to set hive.metastore.uris if you're using a remote metastore.

Step 4: Start Hadoop Services (if necessary)

link to this section

If you haven't already started Hadoop services, start them using the following commands: 

Step 5: Initialize Hive Metastore

link to this section

Run the following command to initialize the Hive metastore:

schematool -initSchema -dbType <database_type> 

Replace <database_type> with the type of database you're using for the metastore (e.g., mysql , derby , postgresql , etc.).

Step 6: Start Hive Server

link to this section

You can start the Hive server by running the following command:

hive --service hiveserver2 & 

Step 7: Verify Installation

link to this section

Once the Hive server is started, you can verify the installation by accessing the Hive shell:


You should see the Hive shell prompt, indicating that Hive is installed and running successfully.


link to this section

In this blog post, we walked through the step-by-step process of installing Apache Hive on a Unix-based system. By following these instructions, you can set up Apache Hive and start using it to query and analyze large datasets stored in Hadoop. Apache Hive provides a powerful SQL-like interface for interacting with Hadoop data, making it a valuable tool for big data analytics and data warehousing tasks.