標籤：
環境：
CentOS6.6 hadoop1.2.1 mysql5.1.73
1、下載
[[email protected] ~]$ wget http://mirrors.cnnic.cn/apache/hive/hive-1.0.0/apache-hive-1.0.0-bin.tar.gz
2、解壓
[[email protected] ~]$ tar -zxf apache-hive-1.0.0-bin.tar.gz
3、設定環境變數
[[email protected] ~]$ vim .bash_profile
HIVE_HOME=/home/grid/apache-hive-1.0.0-bin
PATH=$PATH:$HIVE_HOME/bin
CLASSPATH=$CLASSPATH:$HIVE_HOME/lib
export HIVE_HOME PATH CLASSPATH
[[email protected] ~]$ source .bash_profile
4、編輯Hive設定檔
a、編輯 hive-env.sh ，指定 HADOOP_HOME 、HIVE_CONF_DIR
[[email protected] conf]$ pwd
/home/grid/apache-hive-1.0.0-bin/conf
[[email protected] conf]$ cp hive-env.sh.template hive-env.sh
[[email protected] conf]$ vim hive-env.sh
# Set HADOOP_HOME to point to a specific hadoop install directory
HADOOP_HOME=/home/grid/hadoop-1.2.1
# Hive Configuration Directory can be controlled by:
export HIVE_CONF_DIR=/home/grid/apache-hive-1.0.0-bin/conf
b、編輯 hive-site.xml ，修改資料庫連接屬性（javax.jdo.option.ConnectionURL/ConnectionDriverName/ConnectionUserName/ConnectionPassword）
[[email protected] conf]$ cp hive-default.xml.template hive-site.xml
[[email protected] conf]$ vi hive-site.xml
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://192.168.0.103:3306/hivedb</value>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>hive</value>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
<property>
<name>hive.metastore.uris</name>
<value>thrift://192.168.0.104:9083</value>
<description>Thrift URI for the remote metastore. Used by metastore client to connect to remote metastore.</description>
</property>
<property>
<name>hive.metastore.warehouse.dir</name>
<value>/user/hive/warehouse</value>
<description>location of default database for the warehouse</description>
</property>
5、複製MySQL的JDBC驅動包到Hive的lib目錄下
6、啟動Hive（hadoop已啟動）
啟動服務端
[[email protected] ~]$ hive --service metastore
Starting Hive Metastore Server
啟動用戶端
[[email protected] ~]$ hive
Logging initialized using configuration in jar:file:/home/grid/apache-hive-1.0.0-bin/lib/hive-common-1.0.0.jar!/hive-log4j.properties
hive>
使用遠程mysql作為中繼資料庫安裝Hive
