Hive的安装-Hive配置

修改hive的配置文件

修改hive-env.sh

cd /export/servers/apache-hive-3.1.0-bin/conf
cp hive-env.sh.template hive-env.sh
HADOOP_HOME=/export/servers/hadoop-3.1.1
export HIVE_CONF_DIR=/export/servers/apache-hive-3.1.0-bin/conf

修改hive-site.xml

cd /export/servers/apache-hive-3.1.0-bin/conf
vim 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.ConnectionUserName</name>
	<value>root</value>
	</property>
	<property>
		<name>javax.jdo.option.ConnectionPassword</name>
	<value>123456</value>
	</property>
	<property>
		<name>javax.jdo.option.ConnectionURL</name>
	<value>jdbc:mysql://node03:3306/hive?createDatabaseIfNotExist=true&amp;useSSL=fal
	</property>
	<property>
		<name>javax.jdo.option.ConnectionDriverName</name>
		<value>com.mysql.jdbc.Driver</value>
	</property>
	<property>
		<name>hive.metastore.schema.verification</name>
	<value>false</value>
	</property>
	<property>
		<name>datanucleus.schema.autoCreateAll</name>
	<value>true</value>
	</property>
	<property>
		<name>hive.server2.thrift.bind.host</name>
		<value>node03.hadoop.com</value>
	</property>
	<!--
	<property>
		<name>hive.metastore.uris</name>
		<value>thrift://node03:9083</value>
	<description>JDBC connect string for a JDBC metastore</description>
	</property>
	<property>
		<name>hive.metastore.local</name>
		<value>false</value>
	<description>this is local store</description>
	</property>
	-->
</configuration>

添加mysql的连接驱动包到hive的lib目录下

hive使用mysql作为元数据存储，必然需要连接mysql数据库，所以我们添加一个mysql的连接驱动包到hive的安装目录下，然后就可以准备启动hive了

将我们准备好的mysql-connector-java-5.1.38.jar 这个jar包直接上传到/export/servers/apache-hive-3.1.0-bin/lib 这个目录下即可

至此，hive的安装部署已经完成，接下来我们来看下hive的三种交互方式

配置hive的环境变量

node03服务器执行以下命令配置hive的环境变量

sudo vim /etc/profile
export HIVE_HOME=/export/servers/apache-hive-3.1.0-bin
export PATH=:$HIVE_HOME/bin:$PATH