1.下载apache-hive-2.3.3-bin.tar.gz
2.解压,进入目录,根据模板文件,重新生成新的hive-env.sh,hive-site.xml
3.编辑hive-env.sh 主要是这两个参数 HADOOP_HOME=/opt/soft/hadoop-2.7.5 # Hive Configuration Directory can be controlled by: export HIVE_CONF_DIR=/opt/soft/hive-2.1.1/conf
4.编辑hive-site.xml 有三个参数与mysql相关,我们把hive元数据放在mysql中
mysql 用户名<property><name>javax.jdo.option.ConnectionUserName</name><value>username</value> <description>Username to use against metastore database</description> </property>
mysql 密码 <property> <name>javax.jdo.option.ConnectionPassword</name> <value>password</value> <description>password to use against metastore data