一、HDFS安裝

1、解壓到指定位置tar -zxvf apache-hive-3.1.2-bin.tar.gz -C /usr/local/apps/
2、改名mv apache-hive-3.1.2-bin/ hive-3.1.2
3、在·conf·目錄下添加Hadoop安裝路徑mv hive-env.sh.template hive-env.sh

# 配置HADOOP_HOME路徑
export HADOOP_HOME=/opt/module/hadoop-2.7.2
# 配置HIVE_CONF_DIR路徑
export HIVE_CONF_DIR=/opt/module/hive/conf

4、環境變量vi /etc/profile,source /etc/profile

#Hive
export HIVE_HOME=/usr/local/apps/hive-3.1.2
export PATH=$PATH:$HIVE_HOME/bin
export HIVE_CONF_DIR=$HIVE_HOME/conf

二、將Hive元數據配置到MySql

Hive Metastore服務將Hive表和分區的元數據存儲在關系數據庫中，并使用metastore服務API向客戶端（包括Hive）提供對此信息的訪問。
Metastore默認存儲在自帶的derby數據庫中，推薦使用MySQL存儲Metastore;

1、解壓驅動包tar -zxvf mysql-connector-java-5.1.49.tar.gz
2、驅動拷貝cp mysql-connector-java-5.1.49-bin.jar /usr/local/apps/hive-3.1.2/lib
3、vim 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://Carlota1:3306/metastore?createDatabaseIfNotExist=true&amp;autoReconnect=true&amp;useSSL=false</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、元數據初始化schematool -initSchema -dbType mysql
5、測試啟動bin/hive

Logging initialized using configuration in jar:file:/usr/local/apps/hive-3.1.2/lib/hive-common-3.1.2.jar!/hive-log4j2.properties Async: true
Hive-on-MR is deprecated in Hive 2 and may not be available in the future versions. Consider using a different execution engine (i.e. spark, tez) or using Hive 1.X releases.
Hive Session ID = adfa8414-e92f-4208-b0fb-9d5e483e342d
hive>