Hive安装配置

最新推荐文章于 2024-06-18 14:15:00 发布

yangjian__

最新推荐文章于 2024-06-18 14:15:00 发布

阅读量119

点赞数 1

本文链接：https://blog.csdn.net/Jack__Yang/article/details/87123135

版权

Hive安装配置

(1)hive-env.sh

HADOOP_HOME=/home/hadoop/app/hadoop-2.6.0-cdh5.7.0
export HIVE_CONF_DIR=/home/hadoop/app/hive-1.1.0-cdh5.10.0/conf
export HIVE_AUX_JARS_PATH=/home/hadoop/app/hive-1.1.0-cdh5.10.0/lib

(2)hive-site.xml

<configuration>
<property>
	<name>javax.jdo.option.ConnectionURL</name>
	<value>jdbc:mysql://192.168.31.250:3306/hive?createDatabaseIfNotExist=true</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>123</value>
</property>
</configuration>

(3)mysql-connector-java-5.1.36.jar

HADOOP_HOME=/home/hadoop/app/hadoop-2.6.0-cdh5.7.0
export HIVE_CONF_DIR=/home/hadoop/app/hive-1.1.0-cdh5.10.0/conf
export HIVE_AUX_JARS_PATH=/home/hadoop/app/hive-1.1.0-cdh5.10.0/lib