Apache Hive0.13.1部署

1、设置环境变量

##HIVE_PATHexport HIVE_HOME=/home/local/hive/hive0.13.1export PATH=$HIVE_HOME/bin:$PATH

[root@hadoop5 conf]# source /etc/profile

2、配置属性文件

[root@hadoop5 conf]# cp -a hive-default.xml.template hive-default.xml
[root@hadoop5 conf]# cp -a hive-env.sh.template hive-env.sh
[root@hadoop5 conf]# mv hive-default.xml hive-site.xml

<property>  <name>javax.jdo.option.ConnectionURL</name>  <value>jdbc:mysql://hadoop5:3306/hive?createDatabaseIfNotExist=true</value>  <description>JDBC connect string 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>123456</value>  <description>password to use against metastore database</description></property>

3、创建数据库hive

 mysql> create database hive; mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;   mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY '123456' WITH GRANT OPTION;  mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.116' IDENTIFIED BY '123456' WITH GRANT OPTION;   mysql> GRANT ALL PRIVILEGES ON *.* TO 'root'@'hadoop1' IDENTIFIED BY '123456' WITH GRANT OPTION;  mysql> flush privileges; mysql> use mysql mysql> SELECT User, Password, Host FROM user;

4、测试并进入hive

报错：

解决办法：
    设置hive数据库编码为latin1
    alter database hive character set latin1;