将数据从mysql中导入hive表中,出现异常ERROR hive.HiveConfig: Could not load org.apache.hadoop.hive.conf.HiveConf.
ERROR hive.HiveConfig: Could not load org.apache.hadoop.hive.conf.HiveConf. Make sure HIVE_CONF_DIR is set correctly.
Caused by: java.lang.ClassNotFoundException: org.apache.hadoop.hive.conf.HiveConf
解决办法:
(1)在配置文件/etc/profile
中添加环境变量如下:
export HIVE_HOME=/home/bxp/Documents/install/hadoop-cdh5.10.0/hive-1.1.0-cdh5.10.0
export HADOOP_HOME=/home/bxp/Documents/install/hadoop-cdh5.10.0/hadoop-2.6.0-cdh5.10.0
export HIVE_CONF_DIR=/home/bxp/Documents/install/hadoop-cdh5.10.0/hive-1.1.0-cdh5.10.0/conf
export HADOOP_CLASSPATH=$HADOOP_CLASSPATH:$HIVE_HOME/lib/*
(2)执行source /etc/profile
使得新配置的环境变量生效。(此语句执行只在当前终端和重新启动的终端中生效,对于已经启动的终端不生效,需要关闭终端重启或者执行此语句才能生效)