Hive-003安装配置

Hive的安装

1. 安装 Hive
2. 安装 MySql
	1. 启动 MySql 服务
	2.  通过 MySql 自带的脚本设置
3.  进入MySql Client,授权

安装 MySQL

# 解压hive 3.1.1
tar -zxvf xxx
# 在线安装 mysql
yum install mysql mysql-server mysql-devel
# 启动 mysql 服务
/etc/init.d/mysqld start
# 进行 mysql的客户端然后进行授权
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;

配置 Hive

hive-env.sh

修改 hive_env.sh 文件

cp hive-env.sh.template hive-env.sh

# 设置 hadoop_home位置
HADOOP_HOME=/export/servers/hadoop-3.1.1/
# 设置 Hive COnf 目录
export HIVE_CONF_DIR=/export/servers/apache-hive-3.1.1-bin/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.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环境变量

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