Cheap VPS & Xen Server

Residential Proxy Network - Hourly & Monthly Packages

HIVE Installation

Step 1: The JAVA and Hadoop must be preinstalled on your system.

Step 2: For Hive Download Hive from

It gets downloaded in /user/download folder.

Check for the files

  1. $ cd /usr/download

If the download is successful you will find the below file by typing ls command.

  1. $ ls
  2. apache-hive-0.14.0-bin.tar.gz

Unzip it

  1. $ tar zxvf apache-hive-0.14.0-bin.tar.gz

Copy File

Copy the file to /usr/local/hive directory with root user

  1. $ su –
  2. passwd:
  3. Copying files to /usr/local/hive directory
  4. $ mv /user/download/apache-hive-0.14.0-bin /usr/local/hive

Environment for Hive

Add the below line in ./bashrc file

  1. export HIVE_HOME=/usr/local/hive</br>
  2. export PATH=$PATH:$HIVE_HOME/bin</br>
  3. export CLASSPATH=$CLASSPATH:/usr/local/Hadoop/lib/*:.</br>
  4. export CLASSPATH=$CLASSPATH:/usr/local/hive/lib/*:.</br></br>

Now run the ./bashrc file to reflect those changes.

  1. $ source ~/.bashrc</br>

Configuring Hive

For Configuring Hive is edited. This file is present in HIVE_HOME/conf.

  1. $ cd $HIVE_HOME/conf
  2. $ cp

Add the below line to

  1. export HADOOP_HOME=/usr/local/hadoop

Step 3:Derby Database

Hive uses external Database server to configure Metastore.

Now Download and install Apache Derby

Follow the steps given below to download and install Apache Derby.

Downloading Apache Derby:

The following command is used to download Apache Derby. It takes some time to download.

  1. $ cd ~
  2. $ wget</br>

Unzip it:

  1. $tar zxvf db-derby-

Copy File:

Move file to /usr/local/derby directory

  1. $mv /user/download/db-derby- /usr/local/derby</br>

Set up the enironment

Add the below line to ./bashrc file

  1. export DERBY_HOME=/usr/local/derby
  2. export PATH=$PATH:$DERBY_HOME/bin
  3. Apache Hive
  4. 18
  5. export CLASSPATH=$CLASSPATH:$DERBY_HOME/lib/derby.jar:$DERBY_HOME/lib/derbytools.jar

To reflect the changes type

  1. $ source ~/.bashrc

Create a directory to store Metastore

Create a directory named data in $DERBY_HOME directory to store Metastore data.

  1. $ mkdir $DERBY_HOME/data</br>

Step 4:Configuring Metastore of Hive

Edit hive-site.xml and append the following lines between the <configuration> and </configuration> tags:

  1. <property>
  2. <name>javax.jdo.option.ConnectionURL</name>
  3. <value>jdbc:derby://localhost:1527/metastore_db;create=true </value>
  4. <description>JDBC connect string for a JDBC metastore</description>
  5. </property>

Create a file named and add the following lines into it:

  1. javax.jdo.PersistenceManagerFactoryClass =
  2. org.jpox.PersistenceManagerFactoryImpl
  3. org.jpox.autoCreateSchema = false
  4. org.jpox.validateTables = false
  5. org.jpox.validateColumns = false
  6. org.jpox.validateConstraints = false
  7. org.jpox.storeManagerType = rdbms
  8. org.jpox.autoCreateSchema = true
  9. org.jpox.autoStartMechanismMode = checked
  10. org.jpox.transactionIsolation = read_committed
  11. javax.jdo.option.DetachAllOnCommit = true
  12. javax.jdo.option.NontransactionalRead = true
  13. javax.jdo.option.ConnectionDriverName = org.apache.derby.jdbc.ClientDriver
  14. javax.jdo.option.ConnectionURL = jdbc:derby://hadoop1:1527/metastore_db;create = true
  15. javax.jdo.option.ConnectionUserName = APP
  16. javax.jdo.option.ConnectionPassword = mine

Step 5:Verify Hive Installation

Create the /tmp folder and a separate Hive folder in HDFS. Here, we use the /user/hive/warehouse folder. You need to set write permission for these newly created folders as shown below:

  1. chmodg+w

Set them in HDFS using the following commands:

  1. $ $HADOOP_HOME/bin/hadoop fs -mkdir /tmp
  2. $ $HADOOP_HOME/bin/hadoop fs -mkdir /user/hive/warehouse
  3. $ $HADOOP_HOME/bin/hadoop fs -chmodg+w /tmp
  4. $ $HADOOP_HOME/bin/hadoop fs -chmodg+w /user/hive/warehouse

The following commands are used to verify Hive installation:

  1. $ cd $HIVE_HOME
  2. $ bin/hive
  3. hive