Hive的安装(详细)

一、解压压缩包到指定目录

二、修改配置文件

1. cd 到hive目录下的conf 文件，修改配置

2. vi hive-env.sh

JAVA_HOME=/usr/local/jdk1.8.0_211
	
# Set HADOOP_HOME to point to a specific hadoop install directory
HADOOP_HOME=/usr/local/hadoop-2.7.3
	
# Hive Configuration Directory can be controlled by:
export HIVE_CONF_DIR=/usr/local/hive/conf

3. vi hive-site.xml

<configuration>
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</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.option.ConnectionUserName</name>
<value>root</value>
<description>username to use against metastore database</description>
</property>

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

4.上传mysql的依赖jar包 ，到hive的lib目录下

cp -a mysql-connector-java-8.0.11.jar /usr/local/hive/lib/

5.启动hive(记得配置环境变量哦)

hive

然后用命令启动hive交互界面：