apache hive0.13.1部署

1、设置环境变量

##HIVE_PATH
export HIVE_HOME=/home/local/hive/hive0.13.1
export 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;