安裝hive包
[CDH下載地址]（http://archive.cloudera.com/cdh5/cdh/5/）
1、將hive-0.13.1-cdh5.3.10.tar.gz使用WinSCP上傳到sparkproject1的/usr/local目錄下貌笨。
2京腥、解壓縮hive安裝包：tar -zxvf hive-0.13.1-cdh5.3.6.tar.gz
3粥血、重命名hive目錄：mv hive-0.13.1-cdh5.3.6 hive
4、配置hive相關(guān)的環(huán)境變量
vi /etc/profile
export HIVE_HOME=/usr/local/hive
export PATH=$HIVE_HOME/bin
source /etc/profile
安裝mysql
1、在sparkproject1上安裝mysql糠亩。
2虐骑、使用yum安裝mysql server。
yum install -y mysql-server
service mysqld start
chkconfig mysqld on
3赎线、使用yum安裝mysql connector
yum install -y mysql-connector-java
4富弦、將mysql connector拷貝到hive的lib包中
cp /usr/share/java/mysql-connector-java-5.1.17.jar /usr/local/hive/lib
5、在mysql上創(chuàng)建hive元數(shù)據(jù)庫氛驮，創(chuàng)建hive賬號腕柜，并進(jìn)行授權(quán)
create database if not exists hive_metadata;
grant all privileges on hive_metadata.* to 'hive'@'%' identified by 'hive';
grant all privileges on hive_metadata.* to 'hive'@'localhost' identified by 'hive';
grant all privileges on hive_metadata.* to 'hive'@'spark1' identified by 'hive';
flush privileges;
use hive_metadata;
配置hive-site.xml
mv hive-default.xml.template hive-site.xml
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://spark1:3306/hive_metadata?createDatabaseIfNotExist=true</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>hive</value>
</property>
配置hive-env.sh和hive-config.sh
mv hive-env.sh.template hive-env.sh
vi /usr/local/hive/bin/hive-config.sh
export JAVA_HOME=/usr/java/latest
export HIVE_HOME=/usr/local/hive
export HADOOP_HOME=/usr/local/hadoop
驗(yàn)證hive是否安裝成功
直接輸入hive命令，可以進(jìn)入hive命令行
create table users(id int, name string)
load data local inpath '/usr/local/users.txt' into table users
select name from users
users
1?leo
2?jack
3?jen
4?marry
5?tom
