SHARE
TWEET

Untitled

a guest Jun 12th, 2019 80 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <configuration>
  2.     <property>
  3.         <name>javax.jdo.option.ConnectionURL</name>
  4.         <value>jdbc:mysql://localhost/metastore?createDatabaseIfNotExist=true</value>
  5.         <description>metadata is stored in a MySQL server</description>
  6.     </property>
  7.     <property>
  8.         <name>javax.jdo.option.ConnectionDriverName</name>
  9.         <value>com.mysql.jdbc.Driver</value>
  10.         <description>MySQL JDBC driver class</description>
  11.     </property>
  12.     <property>
  13.         <name>javax.jdo.option.ConnectionUserName</name>
  14.         <value>hive</value>
  15.         <description>user name for connecting to mysql server</description>
  16.     </property>
  17.     <property>
  18.         <name>javax.jdo.option.ConnectionPassword</name>
  19.         <value>hive</value>
  20.         <description>password for connecting to mysql server</description>
  21.     </property>
  22.      <property>
  23.     <name>hive.exec.parallel</name>
  24.     <value>true</value>
  25.     <description>Whether to execute jobs in parallel</description>
  26.   </property>
  27.   <property>
  28.     <name>hive.exec.parallel.thread.number</name>
  29.     <value>8</value>
  30.     <description>How many jobs at most can be executed in parallel</description>
  31.   </property>
  32.         <property>
  33.     <name>hive.cbo.enable</name>
  34.     <value>true</value>
  35.     <description>Flag to control enabling Cost Based Optimizations using Calcite framework.</description>
  36.   </property>
  37.   <property>
  38.     <name>hive.compute.query.using.stats</name>
  39.     <value>true</value>
  40.     <description>
  41.       When set to true Hive will answer a few queries like count(1) purely using stats
  42.       stored in metastore. For basic stats collection turn on the config hive.stats.autogather to true.
  43.       For more advanced stats collection need to run analyze table queries.
  44.     </description>
  45.   </property>
  46.   <property>
  47.     <name>hive.stats.fetch.partition.stats</name>
  48.     <value>true</value>
  49.     <description>
  50.       Annotation of operator tree with statistics information requires partition level basic
  51.       statistics like number of rows, data size and file size. Partition statistics are fetched from
  52.       metastore. Fetching partition statistics for each needed partition can be expensive when the
  53.       number of partitions is high. This flag can be used to disable fetching of partition statistics
  54.       from metastore. When this flag is disabled, Hive will make calls to filesystem to get file sizes
  55.       and will estimate the number of rows from row schema.
  56.     </description>
  57.   </property>
  58.   <property>
  59.     <name>hive.stats.fetch.column.stats</name>
  60.     <value>true</value>
  61.     <description>
  62.       Annotation of operator tree with statistics information requires column statistics.
  63.       Column statistics are fetched from metastore. Fetching column statistics for each needed column
  64.       can be expensive when the number of columns is high. This flag can be used to disable fetching
  65.       of column statistics from metastore.
  66.     </description>
  67.   </property>
  68.   <property>
  69.     <name>hive.stats.autogather</name>
  70.     <value>true</value>
  71.     <description>A flag to gather statistics automatically during the INSERT OVERWRITE command.</description>
  72.   </property>
  73.   <property>
  74.     <name>hive.stats.dbclass</name>
  75.     <value>fs</value>
  76.     <description>
  77.       Expects one of the pattern in [jdbc(:.*), hbase, counter, custom, fs].
  78.       The storage that stores temporary Hive statistics. In filesystem based statistics collection ('fs'),
  79.       each task writes statistics it has collected in a file on the filesystem, which will be aggregated
  80.       after the job has finished. Supported values are fs (filesystem), jdbc:database (where database
  81.       can be derby, mysql, etc.), hbase, counter, and custom as defined in StatsSetupConst.java.
  82.     </description>
  83.   </property>
  84.  
  85.  
  86.   <property>
  87.     <name>hive.exec.scratchdir</name>
  88.     <value>/data/bd/tmp</value>
  89.     <description>Scratch space for Hive jobs</description>
  90.   </property>
  91.  <property>
  92.     <name>hive.service.metrics.file.location</name>
  93.     <value>/data/bd/tmp/report.json</value>
  94.     <description>For metric class org.apache.hadoop.hive.common.metrics.metrics2.CodahaleMetrics JSON_FILE reporter, the location of local JSON metrics file.  This file will get overwritten at every interval.</description>
  95. </property>
  96.  <property>
  97.     <name>hive.query.results.cache.directory</name>
  98.     <value>/data/bd/tmp/hive/_resultscache_</value>
  99.     <description>unknown</description>
  100. </property>
  101.  
  102.  <property>
  103.     <name>hive.llap.io.allocator.mmap.path</name>
  104.     <value>/data/bd/tmp</value>
  105.     <description>unknown</description>
  106. </property>
  107.  
  108.  <property>
  109.     <name>hive.hbase.snapshot.restoredir</name>
  110.     <value>/data/bd/tmp</value>
  111.     <description>unknown</description>
  112. </property>
  113.  <property>
  114.     <name>hive.druid.working.directory</name>
  115.     <value>/data/bd/tmp//workingDirectory</value>
  116.     <description>unknown</description>
  117. </property>
  118. <property>
  119.  
  120. <name>hive.querylog.location</name>
  121.  
  122. <value>/data/bd/tmp</value>
  123.  
  124. <description>logs hive</description>
  125.  
  126. </property>
  127.  
  128.  
  129. </configuration>
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top