Hive一些常用配置【持续更新】

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="configuration.xsl"?>
<configuration>
  <!--是否以本地模式启动，默认false-->
  <property>
    <name>hive.exec.mode.local.auto</name>
    <value>false</value>
  </property>
  <!--设置local mr的最大输入数据量，当输入数据量小于这个值时采用local  mr的方式，默认为134217728，即128M-->
  <property>
    <name>hive.exec.mode.local.auto.inputbytes.max</name>
    <value>134217728</value>
  </property>
  <!--设置local mr的最大输入文件个数，当输入文件个数小于这个值时采用local mr的方式，默认为4-->
  <property>
    <name>hive.exec.mode.local.auto.input.files.max</name>
    <value>4</value>
  </property>

  <!--让提示符显示当前库，默认false-->
  <property>
    <name>hive.cli.print.current.db</name>
    <value>true</value>
  </property>

  <!--查询结果中显示字段名称，默认false-->
  <property>
    <name>hive.cli.print.header</name>
    <value>true</value>
  </property>

  <property>
    <name>javax.jdo.option.ConnectionURL</name>
    <value>jdbc:mysql://localhost:3306/hive?createDatabaseIfNotExist=true</value>
  </property>
 
  <property>
    <name>javax.jdo.option.ConnectionDriverName</name>
    <value>com.mysql.cj.jdbc.Driver</value>
  </property>
   
  <property>
    <name>javax.jdo.option.ConnectionUserName</name>
    <value>root</value>
  </property>
   
  <property>
    <name>javax.jdo.option.ConnectionPassword</name>
    <value>wz55213305</value>
  </property>
   
  <property>
    <name>hive.metastore.warehouse.dir</name>
    <value>/user/hive/warehouse</value>
  </property>
  
  <property>
    <name>hive.metastore.uris</name>
    <value>thrift://localhost:9083</value>
  </property>
  
  <property>
    <name>hive.server2.thrift.bind.host</name>
    <value>localhost</value>
  </property>
  <property>
    <name>hive.server2.thrift.port</name>
    <value>10000</value>
  </property>
  
  <property>
    <name>hive.zookeeper.quorum</name>
    <value>localhost</value>
  </property>
  <property>
    <name>hive.zookeeper.client.port</name>
    <value>2181</value>
  </property>
  
  <property>
    <name>hive.execution.engine</name>
    <value>mr</value>
  </property>
  
  <!--日志相关-->
  <property>
      <name>hive.server2.logging.operation.enabled</name>
      <value>true</value>
    </property>
    <property>
        <name>hive.server2.logging.operation.log.location</name>
        <value>/opt/bigdata/hive/hive-3.1.2/logs/hive.log</value>
    </property>
  
  <!--原子操作相关-->
  <property>
      <name>hive.support.concurrency</name>
      <value>true</value>
    </property>
    <property>
        <name>hive.txn.manager</name>
        <value>org.apache.hadoop.hive.ql.lockmgr.DbTxnManager</value>
    </property>
 
</configuration>