训练九：hive安装

1、到下载地址http://apache.fayea.com/hive/，下载apache-hive-2.3.3-bin.tar.gz，解压

tar -xzvf apache-hive-2.3.3-bin.tar.gz 

2、配置环境变量

sudo vim /etc/profile  

# hive
export HIVE_HOME=/home/hadoop/tools/hive
export PATH=$PATH:${HIVE_HOME}/bin

3、配置hive参数

3.1 拷贝模板配置

cp hive-default.xml.template  hive-default.xml  

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

3.2 创建hive-site.xml

touch hive-site.xml  

3.3 配置hive-env.sh

# Set HADOOP_HOME to point to a specific hadoop install directory
# HADOOP_HOME=${bin}/../../hadoop
export HADOOP_HOME=/home/hadoop/tools/hadoop3

# Hive Configuration Directory can be controlled by:
# export HIVE_CONF_DIR=
export HIVE_CONF_DIR=/home/hadoop/tools/hive/conf

# Folder containing extra libraries required for hive compilation/execution can be controlled by:
# export HIVE_AUX_JARS_PATH=
export JAVA_HOME=/home/hadoop/tools/jdk8
export HIVE_HOME=/home/hadoop/tools/hive

3.4 配置hive-site.xml

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
	<property>
		<name>javax.jdo.option.ConnectionURL</name>
		<value>jdbc:mysql://192.168.1.15:3306/hive?createDatabaseIfNotExist=true&useSSL=false&characterEncoding=utf8</value>
		<description>JDBC connect string for a JDBC metastore</description>
	</property>

	<property>
		<name>javax.jdo.option.ConnectionDriverName</name>
		<value>com.mysql.jdbc.Driver</value>
		<description>Driver class name for a JDBC metastore</description>
	</property>

	<property>
		<name>javax.jdo.PersistenceManagerFactoryClass</name>
		<value>org.datanucleus.api.jdo.JDOPersistenceManagerFactory</value>
		<description>class implementing the jdo persistence</description>
	</property>

	<property>
		<name>javax.jdo.option.DetachAllOnCommit</name>
		<value>true</value>
		<description>detaches all objects from session so that they can be used after transaction is committed</description>
	</property>

	<property>
		<name>javax.jdo.option.NonTransactionalRead</name>  
		<value>true</value>  
		<description>reads outside of transactions</description>  
	</property>

	<property>  
		<name>javax.jdo.option.ConnectionUserName</name>
		<value>root</value>
		<description>username to use against metastore database</description>
	</property>

	<property>
		<name>javax.jdo.option.ConnectionPassword</name>
		<value>hadoop</value>
		<description>password to use against metastore database</description>
	</property>

	<property>
		<name>hive.querylog.location</name>
		<value>/home/hadoop/tools/hive/tmp</value>
	</property>

	<property>
		<name>hive.exec.local.scratchdir</name>
		<value>/home/hadoop/tools/hive/tmp</value>
	</property>

	<property>
		<name>hive.downloaded.resources.dir</name>
		<value>/home/hadoop/tools/hive/tmp</value>
	</property>

	<property>
		<name>datanucleus.schema.autoCreateAll</name>
		<value>true</value>
	</property>
</configuration>

4. 上传mysql驱动jar

下载mysql驱动文件mysql-connector-java-8.0.11.jar，并上传到到/hive/lib目录下。

5. 初始化hive

命令：

schematool -initSchema -dbType mysql 

最后显示schemaTool completed，没有报错就成功了。

6. 启动hive

输入命令：hive