Hive安装
解决包冲突
解决包冲突,保证以下架包的版本一致
/usr/local/apps/hive-1.1.0-cdh5.7.0/lib/ jline-2.12.jar
/usr/local/apps/hadoop-2.6.0-cdh5.7.0/share/hadoop/yarn/lib/ jline-2.11.jar
版本更新:
rm -rf /usr/local/apps/hadoop-2.6.0-cdh5.7.0/share/hadoop/yarn/lib/ jline-2.11.jar
cp \
/usr/local/apps/hive-1.1.0-cdh5.7.0/lib/jline-2.12.jar \
/usr/local/apps/hadoop-2.6.0-cdh5.7.0/share/hadoop/yarn/lib/
配置环境变量
用户环境变量文件:~/.bashrc
export JAVA_HOME=/usr/local/apps/jdk1.8.0_192
export HADOOP_HOME=/usr/local/apps/hadoop-2.5.1
export HIVE_HOME=/usr/local/apps/hive-1.0.0
export PATH=$PATH:$JAVA_HOME/bin:$HADOOP_HOME/bin:$HADOOP_HOME/sbin:$HIVE_HOME/bin
导入MySQL驱动包
将mysql-connector-java-5.1.27.jar导入Hive-1.1.0/lib/下
配置数据元
配置数据元存放位置(hive-1.1.0-cdh5.7.0/conf/)hive-site.xml
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
<!--链接-->
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true&useUnicode=true&characterEncoding=UTF-8</value>
</property>
<!--驱动-->
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
</property>
<!--用户-->
<property>
<name>javax.jdo.option.ConnectionUserName</name>
<value>root</value>
</property>
<!--密码-->
<property>
<name>javax.jdo.option.ConnectionPassword</name>
<value>123456</value>
</property>
<!--显示当前库-->
<property>
<name>hive.cli.print.current.db</name>
<value>true</value>
</property>
<!--查询结果显示字段名称-->
<property>
<name>hive.cli.print.header</name>
<value>true</value>
</property>
</configuration>
启动Hive
Hive