Home: http://manmustbecool.github.io/MyWiki/

---

---

1 Quick installation

Assuming that the Hadoop is installed

export HADOOP_HOME=/home/ubuntu/hadoop-0.20.205.0

Download the Hive

sudo wget http://ftp.heanet.ie/mirrors/www.apache.org/dist/hive/hive-0.9.0/hive-0.9.0.tar.gz
tar xzvf hive-0.9.0.tar.gz

Set the variables

Edit .bash_profile to add entry for $HIVE_HOME and change $PATH. vim ~/.bash_profile

export HIVE_HOME=/home/ubuntu/hive-0.9.0
export PATH=$PATH:$HIVE_HOME/bin

Logout and login for the changes to take effect. After successful login, typing echo $HIVE_HOME to check

Create a space in HDFS for Hive

$HADOOP_HOME/bin/start-all.sh // start the Hadoop

$HADOOP_HOME/bin/hadoop fs -mkdir /tmp
$HADOOP_HOME/bin/hadoop fs -mkdir /user/hive/warehouse
$HADOOP_HOME/bin/hadoop fs -chmod g+w /tmp
$HADOOP_HOME/bin/hadoop fs -chmod g+w /user/hive/warehouse

Start the Hive CLI

$HIVE_HOME/bin/hive

2 Web interface

Start the web application

$HIVE_HOME/bin/hive --service hwi

To access Hive using the web interface (default port: 9999) - <Hive Server Address>:9999/hwi

Creating a hive-site.xml in the hive/con folder, if it can not find the hwi.war file

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
  <property>
    <name>hive.hwi.war.file</name>
    <value>lib/hive-hwi-0.9.0.war</value>
    <description>This sets the path to the HWI war file, relative to ${HIVE_HOME}. </description>
  </property>
</configuration>

3 JDBC connection

To interact with Hive using JDBC, first run the Hive Thrift Server (default port: 10000) -

hive --service hiveserver
# or 
hive --service hiveserver2

.