前言：
上篇文章我們介紹了Hive源碼編譯的相關(guān)內(nèi)容累提，本篇文章將主要介紹Hive環(huán)境的搭建步驟及簡(jiǎn)單使用丰泊。
1.下載安裝包并解壓
# 下載地址http://archive.cloudera.com/cdh5/cdh/5/ 選擇hive-1.1.0-cdh5.7.0.tar.gz包浪蹂，也可用我們上篇文章編譯來(lái)的包[hadoop@hadoop000 ~]$ ll
total 32
drwxrwxr-x 4 hadoop hadoop 4096 Jun? 1 21:27 app? ? ? ? ? --軟件安裝路徑
drwx------ 3 hadoop hadoop 4096 Jun? 1 21:46 data
drwxrwxr-x 2 hadoop hadoop 4096 May 31 19:41 lib
drwxrwxr-x 2 hadoop hadoop 4096 May 31 19:41 maven_repo
drwxrwxr-x 2 hadoop hadoop 4096 Jun? 1 21:46 pids
drwxrwxr-x 2 hadoop hadoop 4096 May 31 19:42 shell
drwxrwxr-x 2 hadoop hadoop 4096 May 31 19:48 software? ? --安裝包路徑
drwxrwxr-x 3 hadoop hadoop 4096 May 31 20:59 source? ? ? --源碼包路徑
[hadoop@hadoop000 ~]$ cd software/
[hadoop@hadoop000 software]$ pwd
/home/hadoop/software
[hadoop@hadoop000 software]$ wget http://archive.cloudera.com/cdh5/cdh/5/hive-1.1.0-cdh5.7.0.tar.gz
[hadoop@hadoop000 software]$ tar -xzvf hive-1.1.0-cdh5.7.0.tar.gz -C /home/hadoop/app/
2.配置環(huán)境變量
[hadoop@oradb3 ~]$ vi .bash_profile# 添加下面內(nèi)容：export HIVE_HOME=/home/hadoop/app/hive-1.1.0-cdh5.7.0
export PATH=$HIVE_HOME/bin:$PATH
[hadoop@oradb3 ~]$ source .bash_profile# 或添加到全局環(huán)境變量/etc/profile也可以
3.配置文件修改
[hadoop@hadoop000 conf]$ pwd
/home/hadoop/app/hive-1.1.0-cdh5.7.0/conf
[hadoop@hadoop000 conf]$ cp hive-env.sh.template? hive-env.sh
[hadoop@hadoop000 conf]$ vi hive-env.sh# 更改HADOOP_HOMEHADOOP_HOME=/home/hadoop/app/hadoop-2.6.0-cdh5.7.0
4.在lib下添加MySQL驅(qū)動(dòng)包
# 需要自行下載 下載地址https://dev.mysql.com/downloads/connector/j/
[hadoop@oradb3 lib]$ pwd
/home/hadoop/app/hive-1.1.0-cdh5.7.0/lib
[hadoop@oradb3 lib]$ ll mysql-connector-java-5.1.13-bin.jar
-rw-r--r-- 1 hadoop hadoop 767492 Jun? 1 22:01 mysql-connector-java-5.1.13-bin.jar
5.創(chuàng)建表進(jìn)行測(cè)試
[hadoop@oradb3 ~]$ hive
which: no hbase in (/home/hadoop/app/hive-1.1.0-cdh5.7.0/bin:/home/hadoop/app/hadoop-2.6.0-cdh5.7.0/bin:/usr/java/jdk1.7/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin)
Logging initialized using configuration in jar:file:/home/hadoop/app/hive-1.1.0-cdh5.7.0/lib/hive-common-1.1.0-cdh5.7.0.jar!/hive-log4j.propertieshive> create database ruoze;OK
Time taken: 1.35 secondshive> use ruoze;OK
Time taken: 0.05 secondshive>create tabletest(id int);OK
Time taken: 0.65 secondshive> show tables;OK
test
Time taken: 0.239 seconds, Fetched: 1 row(s)
# 詳細(xì)操作可參考：https://blog.csdn.net/scgaliguodong123_/article/details/46868525
