hive3.1.1环境搭建hive-site.xml文件配置

<property>
  <name>javax.jdo.option.ConnectionURL</name>
  <value>jdbc:mysql://192.168.160.100:3306/hive</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionPassword</name>
  <value>root</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionUserName</name>
  <value>root</value>
</property>

<property>
  <name>javax.jdo.option.ConnectionDriverName</name>
  <value>com.mysql.jdbc.Driver</value>
</property>

<property>
  <name>hive.exec.scratchdir</name>
  <value>/user/hive/tmp</value>
</property>

<property>
  <name>hive.exec.local.scratchdir</name>
  <value>/home/centos/install/hive-3.1.1/iotmp</value>
</property>

<property>
  <name>hive.downloaded.resources.dir</name>
  <value>/home/centos/install/hive-3.1.1/download_resources</value>
</property>

<property>
  <name>hive.metastore.warehouse.dir</name>
  <value>/user/hive/warehouse</value>
</property>

<property>
  <name>datanucleus.schema.autoCreateAll</name>
  <value>true</value>
</property>

<property>
  <name>hive.querylog.location</name>
  <value>/user/hive/logs</value>
</property>

<property>
  <name>hive.txn.xlock.iow</name>
  <value>true</value>
</property>

<property>
  <name>hive.server2.logging.operation.log.location</name>
  <value>/home/centos/install/hive-3.1.1/iotmp/operation_logs</value>
</property>

<property>
  <name>hive.query.results.cache.directory</name>
  <value>/user/hive/tmp/resultscache</value>
</property>

<property>
  <name>hive.server2.enable.doAs</name>
  <value>false</value>
</property>