hive 3.1.2安装

1.下载hive3.1.2
镜像下载
2.配置path
3.修改文件

cp hive-default.xml.template hive-default.xml
cp hive-env.sh.template hive-env.sh

hive-env.sh

 HADOOP_HOME=/opt/module/hadoop-3.1.3

# Hive Configuration Directory can be controlled by:
 export HIVE_CONF_DIR=/opt/module/hive-3.1.2/conf

# Folder containing extra libraries required for hive compilation/execution can be controlled by:
 export HIVE_AUX_JARS_PATH=/opt/module/hive-3.1.2/lib

4.创建hive-site.xml

<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
  <property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://192.168.252.133: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.cj.jdbc.Driver</value>
    <description>Driver class name for a JDBC metastore</description>
  </property>
  <property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>hive</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>

我写的mysql是远程的
我需要在192.168.252.133的mysql里为这台主机授权

GRANT ALL PRIVILEGES ON *.* TO 'hive'@'192.168.252.130' IDENTIFIED BY '123456';

schematool -dbType mysql -initSchema

bin：./hive