Wednesday, 6 November 2013

Hive Installation


A. Pre-Requisite:
Hadoop

B. Hive Installation steps:
1. Download Hive from http://mirror.olnevhost.net/pub/apache/hive/stable/ (File: hive-0.11.0-bin.tar.gz)

2. Extract Hive : tar -xzf hive-0.11.0-bin.tar.gz (it will extract to a folder hive-0.11.0-bin)

3. sudo mv hive-0.11.0-bin/ hive

4. sudo mv hive/ /usr/local/.

5. cd /usr/local

6. sudo chown -R hduser:hadoop hive/

7. Set below Env variables (under hduser).
export HIVE_HOME=/usr/local/hive
export PATH=$HIVE_HOME/bin:$PATH
(Make sure hadoop is started. To start Hadoop, ssh localhost; start-all.sh)

Working on Hive:

8. hive

it will give you hive prompt. So that you can start accessing default DB or create new DB :)

Note: hduser is the user under which I have installed hadoop & hive. In your case it may be different

********** End of Hive Installation - Enjoy SQL based HDFS tool ***************************