配置hive.exec.scratchdir
hive用来存储不同阶段的map/reduce的执行计划的目录，同时也存储中间输出结果
<property>
<name>hive.exec.scratchdir</name>
<value>/tmp/hive</value>
<description>
HDFS root scratch dir for Hive jobs which gets created with write all (733) permission. For each connecting user, an HDFS scratch dir: ${hive.exec.scratchdir}/<username> is created, with ${hive.scratch.dir.permission}.
</description>
</property>
配置hive.exec.local.scratchdir
当hive运行在本地模式时配置
<property>
<name>hive.exec.local.scratchdir</name>
<value>/tmp/hive/root</value>
<description>Local scratch space for Hive jobs</description>
</property>
配置hive.scratch.dir.permission
允许在根scratch录中创建的用户特定的scratch目录的权限
<property>
<name>hive.scratch.dir.permission</name>
<value>777</value>
<description>The permission for the user specific scratch directories that get created.</description>
</property>
配置hive.downloaded.resources.dir
远程资源下载的临时目录（创建一个tmp目录，本文将该目录创建在解压目录下）
<property>
<name>hive.downloaded.resources.dir</name>
<value>/usr/env/hive/hive-2.3.3/tmp/${hive.session.id}_resources</value>
<description>Temporary local directory for added resources in the remote file system.</description>
</property>
将配置文件中${system:user.name}都替换为root
配置数据库连接驱动javax.jdo.option.ConnectionDriverName（本文使用的mysql数据库）
<property>
<name>javax.jdo.option.ConnectionDriverName</name>
<value>com.mysql.jdbc.Driver</value>
<description>Driver class name for a JDBC metastore</description>
</property>
配置连接数据库的URL javax.jdo.option.ConnectionURL
<property>
<name>javax.jdo.option.ConnectionURL</name>
<value>jdbc:mysql://XXX.XXX.XXX.XXX:3306/hive?createDatabaseIfNotExist=true</value>
<description>
JDBC connect string for a JDBC metastore.
To use SSL to encrypt/authenticate the connection, provide database-specific SSL flag in the connection URL.
For example, jdbc:postgresql://myhost/db?ssl=true for postgres database.
</description>
</property>
