因為我們選擇使用MySQL版安裝方式,所以我們保證已經有了一個可連接的MySQL服務。
這里默認裝在了Hadoop1主機上,端口是3306,用戶名root,密碼root。
一、上傳安裝包并解壓
```bash
tar -zxvf apache-hive-1.2.2-bin.tar.gz -C /opt/
```
為了方便操作,將解壓后目錄更為`hive`。
二、配置文件
```bash
vi /opt/hive/conf/hive-env.sh
```
```bash
# 添加內容
export HADOOP_HOME=/opt/hadoop
```
```bash
vi /opt/hive/conf/hive-default.xml # 配置MYSQL連接
```
```xml
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://hadoop1:3306/hive?createDatabaseIfNotExist=true</value>
<description>JDBC connect string for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
<description>Username to use against metastore database</description>
</property>
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>root</value>
<description>password to use against metastore database</description>
</property>
```
三、選擇一個MySQL驅動包放入`/opt/hive/lib`目錄下。[mysql-connector-java-5.1.6.jar]
啟動Hive
```bash
/opt/hive/bin/hive
```