Hive2.1.0安装配置mysql

1. 设置Hive环境变量

export JAVA_HOME=/usr/java/jdk1.8.0_111
export JRE_HOME=/usr/java/jdk1.8.0_111/jre
export CLASSPATH=/usr/java/jdk1.8.0_111/lib
export HADOOP_HOME=/root/cluster/opt/hadoop-2.6.0
export HIVE_HOME=/root/cluster/opt/hive-2.1.0
export PATH=$JAVA_HOME/bin:/opt/STM/ST40R5.1.0/bin:/usr/lib/:$PATH:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$HIVE_HOME:/bin:$HIVE_HOME/conf

2. 修改Hive的配置文件

export HIVE_CONF_DIR=/root/cluster/opt/hive-2.1.0/conf

export  HADOOP_HOME ...  (ignore here).

cp conf/hive-default.xml.template hive-site.xml
cp conf/hive-log4j.properties.template hive-log4j.properties
cp conf/hive-exec-log4j.properties.template hive-exec-log4j.properties

3.  修改 hive-