You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2018/11/07 06:08:05 UTC
svn commit: r1845984 [4/25] - in /kylin/site: ./ about/ blog/
blog/2015/01/25/introduce-data-model/
blog/2015/06/10/release-v0.7.1-incubating/
blog/2015/08/13/kylin-dictionary/ blog/2015/08/15/fast-cubing/
blog/2015/09/06/release-v1.0-incubating/ blog/...
Modified: kylin/site/cn/docs/install/configuration.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/install/configuration.html?rev=1845984&r1=1845983&r2=1845984&view=diff
==============================================================================
--- kylin/site/cn/docs/install/configuration.html (original)
+++ kylin/site/cn/docs/install/configuration.html Wed Nov 7 06:08:00 2018
@@ -166,1266 +166,668 @@ var _hmt = _hmt || [];
<div id="pjax">
<h1 class="post-title">Kylin é
ç½®</h1>
<article class="post-content" >
- <p>Kylin ä¼èªå¨ä»ç¯å¢ä¸æ£æµ Hadoop/Hive/HBase é
ç½®ï¼å¦ âcore-site.xmlâ, âhbase-site.xmlâ åå
¶ä»ãé¤æ¤ä¹å¤ï¼Kylin æèªå·±çé
ç½®ï¼å¨ âconfâ æ件夹ä¸ã</p>
+ <ul>
+ <li><a href="#kylin-config">é
ç½®æ件ååæ°éå</a>
+ <ul>
+ <li><a href="#kylin-config">Kylin é
ç½®æ件</a></li>
+ <li><a href="#config-overwrite">é
ç½®éå</a>
+ <ul>
+ <li><a href="#project-config-overwrite">项ç®é
ç½®éå</a></li>
+ <li><a href="#cube-config-overwrite">Cube é
ç½®éå</a></li>
+ <li><a href="#mr-config-overwrite">éå MapReduce ä»»å¡ç¸å
³</a></li>
+ <li><a href="#hive-config-overwrite">éå Hive åæ°</a></li>
+ <li><a href="#spark-config-overwrite">éå Spark åæ°</a></li>
+ </ul>
+ </li>
+ </ul>
+ </li>
+ <li><a href="#kylin-deploy">é¨ç½²é
ç½®</a>
+ <ul>
+ <li><a href="#deploy-config">é¨ç½² Kylin</a></li>
+ <li><a href="#job-engine-ha">ä»»å¡å¼æé«å¯ç¨</a></li>
+ <li><a href="#kylin-jvm-settings">åé
æ´å¤å
åç» Kylin å®ä¾</a></li>
+ <li><a href="#rest-config">RESTful Webservice</a></li>
+ </ul>
+ </li>
+ <li><a href="#kylin_metastore">Metastore é
ç½®</a>
+ <ul>
+ <li><a href="#metadata">å
æ°æ®</a></li>
+ <li><a href="#mysql-metastore">ä½¿ç¨ MySQL ä½ä¸º Metastore (æµè¯)</a></li>
+ </ul>
+ </li>
+ <li><a href="#kylin-build">æ建é
ç½®</a>
+ <ul>
+ <li><a href="#hive-client-and-sparksql">Hive 客æ·ç«¯ & SparkSQL</a></li>
+ <li><a href="#jdbc-datasource">é
ç½® JDBC æ°æ®æº</a></li>
+ <li><a href="#precision-config">æ°æ®ç±»å精度</a></li>
+ <li><a href="#cube-config">Cube 设置</a></li>
+ <li><a href="#cube-estimate">Cube 大å°ä¼°è®¡</a></li>
+ <li><a href="#cube-algorithm">Cube æ建ç®æ³</a></li>
+ <li><a href="#auto-merge">èªå¨å并</a></li>
+ <li><a href="#snapshot">维表快ç
§</a></li>
+ <li><a href="#cube-build">Cube æ建</a></li>
+ <li><a href="#dict-config">åå
¸ç¸å
³</a></li>
+ <li><a href="#uhc-config">è¶
é«åºç»´åº¦çå¤ç</a></li>
+ <li><a href="#spark-cubing">Spark æ建å¼æ</a></li>
+ <li><a href="#dynamic-allocation">Spark èµæºå¨æåé
</a></li>
+ <li><a href="#job-config">ä»»å¡ç¸å
³</a></li>
+ <li><a href="#email-notification">å¯ç¨é®ä»¶éç¥</a></li>
+ <li><a href="#cube-planner">å¯ç¨ Cube Planner</a></li>
+ <li><a href="#hbase-config">HBase åå¨</a></li>
+ <li><a href="#compress-config">å¯ç¨å缩</a></li>
+ </ul>
+ </li>
+ <li><a href="#kylin-query">æ¥è¯¢é
ç½®</a>
+ <ul>
+ <li><a href="#query-config">æ¥è¯¢ç¸å
³</a></li>
+ <li><a href="#fuzzy">模ç³æ¥è¯¢</a></li>
+ <li><a href="#cache-config">æ¥è¯¢ç¼å</a></li>
+ <li><a href="#query-limit">æ¥è¯¢éå¶</a></li>
+ <li><a href="#query-pushdown">æ¥è¯¢ä¸å</a></li>
+ <li><a href="#convert-sql">æ¥è¯¢æ¹å</a></li>
+ <li><a href="#jmx-metrics">æ¶éæ¥è¯¢ææ å° JMX</a></li>
+ <li><a href="#dropwizard-metrics">æ¶éæ¥è¯¢ææ å°dropwizard</a></li>
+ </ul>
+ </li>
+ <li><a href="#kylin-security">å®å
¨é
ç½®</a>
+ <ul>
+ <li><a href="#ldap-sso">éæ LDAP å®ç°åç¹ç»å½</a></li>
+ <li><a href="#ranger">ä¸ Apache Ranger éæ</a></li>
+ <li><a href="#zookeeper-acl">å¯ç¨ ZooKeeper ACL</a></li>
+ </ul>
+ </li>
+</ul>
+
+<h3 id="kylin-config">é
ç½®æ件ååæ°éå</h3>
+
+<p>æ¬å°èä»ç» Kylin çé
ç½®æ件åå¦ä½è¿è¡é
ç½®éåã</p>
+
+<h3 id="kylin-config-file">Kylin é
ç½®æ件</h3>
+
+<p>Kylin ä¼èªå¨ä»ç¯å¢ä¸è¯»å Hadoop é
ç½®ï¼<code class="highlighter-rouge">core-site.xml</code>ï¼ï¼Hive é
ç½®ï¼<code class="highlighter-rouge">hbase-site.xml</code>ï¼å HBase é
ç½®ï¼<code class="highlighter-rouge">hbase-site.xml</code>ï¼ï¼å¦å¤ï¼Kylin çé
ç½®æä»¶å¨ <code class="highlighter-rouge">$KYLIN_HOME/conf/</code> ç®å½ä¸ã<br />
+Kylin çé
ç½®æ件å¦ä¸ï¼</p>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin_hive_conf.xml</code>ï¼è¯¥æ件å
å«äº Hive ä»»å¡çé
置项ã</li>
+ <li><code class="highlighter-rouge">kylin_job_conf.xml</code> & <code class="highlighter-rouge">kylin_job_conf_inmem.xml</code>ï¼è¯¥æ件å
å«äº MapReduce ä»»å¡çé
置项ãå½æ§è¡<strong>In-mem Cubing</strong>ä»»å¡æ¶ï¼éè¦å¨ <code class="highlighter-rouge">kylin_job_conf_inmem.xml</code> ä¸ä¸º mapper ç³è¯·æ´å¤çå
å</li>
+ <li><code class="highlighter-rouge">kylin-kafka-consumer.xml</code>ï¼è¯¥æ件å
å«äº Kafka ä»»å¡çé
置项ã</li>
+ <li><code class="highlighter-rouge">kylin-server-log4j.properties</code>ï¼è¯¥æ件å
å«äº Kylin æå¡å¨çæ¥å¿é
置项ã</li>
+ <li><code class="highlighter-rouge">kylin-tools-log4j.properties</code>ï¼è¯¥æ件å
å«äº Kylin å½ä»¤è¡çæ¥å¿é
置项ã</li>
+ <li><code class="highlighter-rouge">setenv.sh</code> ï¼è¯¥æ件æ¯ç¨äºè®¾ç½®ç¯å¢åéç shell èæ¬ï¼å¯ä»¥éè¿ <code class="highlighter-rouge">KYLIN_JVM_SETTINGS</code> è°æ´ Kylin JVM æ ç大å°ï¼ä¸å¯ä»¥è®¾ç½® <code class="highlighter-rouge">KAFKA_HOME</code> çå
¶ä»ç¯å¢åéã</li>
+ <li><code class="highlighter-rouge">kylin.properties</code>ï¼è¯¥æä»¶æ¯ Kylin 使ç¨çå
¨å±é
ç½®æ件ã</li>
+</ul>
+
+<h3 id="config-overwrite">é
ç½®éå</h3>
+
+<p><code class="highlighter-rouge">$KYLIN_HOME/conf/</code> ä¸æé¨åé
置项å¯ä»¥å¨ Web UI çé¢è¿è¡éåï¼é
ç½®éåå为<strong>项ç®çº§å«é
ç½®éå</strong>å <strong>Cube 级å«é
ç½®éå</strong>ãé
ç½®éåçä¼å
级å
³ç³»ä¸ºï¼Cube 级å«é
ç½®éå > 项ç®çº§å«é
ç½®éå > å
¨å±é
ç½®æ件ã</p>
+
+<h3 id="project-config-overwrite">项ç®é
ç½®éå</h3>
+
+<p>å¨ Web UI çé¢ç¹å» â<strong>Manage Project</strong>â ï¼éä¸æ个项ç®ï¼ç¹å» â<strong>Edit</strong>â->â<strong>Project Config</strong>â->â<strong>+ Property</strong>âï¼è¿è¡é¡¹ç®çº§å«çé
ç½®éåï¼å¦ä¸å¾æ示ï¼<br />
+<img src="/images/install/overwrite_config_project.png" alt="" /></p>
+
+<h3 id="cube-config-overwrite">Cube é
ç½®éå</h3>
+
+<p>å¨è®¾è®¡ Cube ï¼<strong>Cube Designer</strong>ï¼ç â<strong>Configuration Overwrites</strong>â æ¥éª¤å¯ä»¥æ·»å é
置项ï¼è¿è¡ Cube 级å«çé
ç½®éåï¼å¦ä¸å¾æ示ï¼<br />
+<img src="/images/install/overwrite_config_v2.png" alt="" /></p>
+
+<h3 id="mr-config-overwrite">éå MapReduce ä»»å¡ç¸å
³</h3>
+
+<p>Kylin æ¯æå¨é¡¹ç®å Cube 级å«éå <code class="highlighter-rouge">kylin_job_conf.xml</code> å <code class="highlighter-rouge">kylin_job_conf_inmem.xml</code> ä¸åæ°ï¼ä»¥é®å¼å¯¹çæ§è´¨ï¼æç
§å¦ä¸æ ¼å¼æ¿æ¢ï¼<br />
+<code class="highlighter-rouge">kylin.job.mr.config.override.<key> = <value></code><br />
+å¦ææ¨å¸æ Cube çæ建任å¡ä½¿ç¨ä¸åç YARN resource queueï¼æ¨å¯ä»¥è®¾ç½®ï¼<code class="highlighter-rouge">kylin.engine.mr.config-override.mapreduce.job.queuename={queueName}</code></p>
+
+<h3 id="hive-config-overwrite">éå Hive åæ°</h3>
+
+<p>Kylin æ¯æå¨é¡¹ç®å Cube 级å«éå <code class="highlighter-rouge">kylin_hive_conf.xml</code> ä¸åæ°ï¼ä»¥é®å¼å¯¹çæ§è´¨ï¼æç
§å¦ä¸æ ¼å¼æ¿æ¢ï¼<br />
+<code class="highlighter-rouge">kylin.source.hive.config-override.<key> = <value></code><br />
+å¦ææ¨å¸æ Hive 使ç¨ä¸åç YARN resource queueï¼æ¨å¯ä»¥è®¾ç½®ï¼<code class="highlighter-rouge">kylin.source.hive.config-override.mapreduce.job.queuename={queueName}</code></p>
+
+<h3 id="spark-config-overwrite">éå Spark åæ°</h3>
+
+<p>Kylin æ¯æå¨é¡¹ç®å Cube 级å«éå <code class="highlighter-rouge">kylin.properties</code> ä¸ç Spark åæ°ï¼ä»¥é®å¼å¯¹çæ§è´¨ï¼æç
§å¦ä¸æ ¼å¼æ¿æ¢ï¼<br />
+<code class="highlighter-rouge">kylin.engine.spark-conf.<key> = <value></code><br />
+å¦ææ¨å¸æ Spark 使ç¨ä¸åç YARN resource queueï¼æ¨å¯ä»¥è®¾ç½®ï¼<code class="highlighter-rouge">kylin.engine.spark-conf.spark.yarn.queue={queueName}</code></p>
+
+<h3 id="kylin-deploy">é¨ç½²é
ç½®</h3>
+
+<p>æ¬å°èä»ç»é¨ç½² Kylin ç¸å
³çé
ç½®ã</p>
+
+<h3 id="deploy-config">é¨ç½² Kylin</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.env</code>ï¼æå® Kylin é¨ç½²çç¨éï¼åæ°å¼å¯é <code class="highlighter-rouge">DEV</code>ï¼<code class="highlighter-rouge">QA</code> æ <code class="highlighter-rouge">PROD</code>ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">DEV</code>ï¼å¨ DEV 模å¼ä¸ä¸äºå¼åè
åè½å°è¢«å¯ç¨</li>
+ <li><code class="highlighter-rouge">kylin.env.hdfs-working-dir</code>ï¼æå® Kylin æå¡æç¨ç HDFS è·¯å¾ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">/kylin</code>ï¼è¯·ç¡®ä¿å¯å¨ Kylin å®ä¾çç¨æ·æ读å该ç®å½çæé</li>
+ <li><code class="highlighter-rouge">kylin.env.zookeeper-base-path</code>ï¼æå® Kylin æå¡æç¨ç ZooKeeper è·¯å¾ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">/kylin</code></li>
+ <li><code class="highlighter-rouge">kylin.env.zookeeper-connect-string</code>ï¼æå® ZooKeeper è¿æ¥å符串ï¼å¦æ为空ï¼ä½¿ç¨ HBase ç ZooKeeper</li>
+ <li><code class="highlighter-rouge">kylin.env.hadoop-conf-dir</code>ï¼æå® Hadoop é
ç½®æ件ç®å½ï¼å¦æä¸æå®çè¯ï¼è·åç¯å¢ä¸ç <code class="highlighter-rouge">HADOOP_CONF_DIR</code></li>
+ <li><code class="highlighter-rouge">kylin.server.mode</code>ï¼æå® Kylin å®ä¾çè¿è¡æ¨¡å¼ï¼åæ°å¼å¯é <code class="highlighter-rouge">all</code>ï¼<code class="highlighter-rouge">job</code>ï¼<code class="highlighter-rouge">query</code>ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">all</code>ï¼job 模å¼ä»£è¡¨è¯¥æå¡ä»
ç¨äºä»»å¡è°åº¦ï¼ä¸ç¨äºæ¥è¯¢ï¼query 模å¼ä»£è¡¨è¯¥æå¡ä»
ç¨äºæ¥è¯¢ï¼ä¸ç¨äºæ建任å¡çè°åº¦ï¼all 模å¼ä»£è¡¨è¯¥æå¡åæ¶ç¨äºä»»å¡è°åº¦å SQL æ¥è¯¢ã</li>
+ <li><code class="highlighter-rouge">kylin.server.cluster-name</code>ï¼æå®é群å称</li>
+</ul>
+
+<h3 id="rw-deploy">读åå离é
ç½®</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.cluster-fs</code>ï¼ææ HBase é群ç HDFS æ件系ç»</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.cluster-hdfs-config-file</code>ï¼æå HBase é群ç HDFS é
ç½®æ件</li>
+</ul>
+
+<blockquote>
+ <p>æ示ï¼æ´å¤ä¿¡æ¯è¯·åè <a href="http://kylin.apache.org/blog/2016/06/10/standalone-hbase-cluster/">Deploy Apache Kylin with Standalone HBase Cluster</a></p>
+</blockquote>
+
+<h3 id="kylin-jvm-settings">åé
æ´å¤å
åç» Kylin å®ä¾</h3>
+
+<p>å¨ <code class="highlighter-rouge">$KYLIN_HOME/conf/setenv.sh</code> ä¸åå¨å¯¹ <code class="highlighter-rouge">KYLIN_JVM_SETTINGS</code> ç两ç§ç¤ºä¾é
ç½®ã<br />
+é»è®¤é
置使ç¨çå
åè¾å°ï¼ç¨æ·å¯ä»¥æ ¹æ®èªå·±çå®é
æ
åµï¼æ³¨éæé»è®¤é
置并åæ¶å¦ä¸é
ç½®åç注é符å·ä»¥å¯ç¨å¦ä¸é
ç½®ï¼ä»è为 Kylin å®ä¾åé
æ´å¤çå
åèµæºï¼è¯¥é¡¹é
ç½®çé»è®¤å¼å¦ä¸ï¼</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="nb">export </span><span class="nv">KYLIN_JVM_SETTINGS</span><span class="o">=</span><span class="s2">"-Xms1024M -Xmx4096M -Xss1024K -XX</span><span class="sb">`</span><span class="nv">MaxPermSize</span><span class="o">=</span>512M -verbose<span class="sb">`</span><span class="s2">gc -XX</span><span class="sb">`</span>+PrintGCDetails -XX<span class="sb">`</span><span class="s2">+PrintGCDateStamps -Xloggc</span><span class="sb">`</span><span class="nv">$KYLIN_HOME</span>/logs/kylin.gc.<span class="nv">$$</span> -XX<span class="sb">`</span><span class="s2">+UseGCLogFileRotation -XX</span><span class="sb">`</span><span class="nv">NumberOfGCLogFiles</span><span class="o">=</span>10 -XX<span class="sb">`</span><span class="s2">GCLogFileSize=64M"</span>
+<span class="c"># export KYLIN_JVM_SETTINGS="-Xms16g -Xmx16g -XX`MaxPermSize=512m -XX`NewSize=3g -XX`MaxNewSize=3g -XX`SurvivorRatio=4 -XX`+CMSClassUnloadingEnabled -XX`+CMSParallelRemarkEnabled -XX`+UseConcMarkSweepGC -XX`+CMSIncrementalMode -XX`CMSInitiatingOccupancyFraction=70 -XX`+UseCMSInitiatingOccupancyOnly -XX`+DisableExplicitGC -XX`+HeapDumpOnOutOfMemoryError -verbose`gc -XX`+PrintGCDetails -XX`+PrintGCDateStamps -Xloggc`$KYLIN_HOME/logs/kylin.gc.$$ -XX`+UseGCLogFileRotation -XX`NumberOfGCLogFiles=10 -XX`GCLogFileSize=64M"</span>
+</code></pre>
+</div>
+
+<h3 id="rest-config">RESTful Webservice</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.web.timezone</code>ï¼æå® Kylin ç REST æå¡æ使ç¨çæ¶åºï¼é»è®¤å¼ä¸º GMT+8</li>
+ <li><code class="highlighter-rouge">kylin.web.cross-domain-enabled</code>ï¼æ¯å¦æ¯æè·¨å访é®ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.web.export-allow-admin</code>ï¼æ¯å¦æ¯æ管çåç¨æ·å¯¼åºä¿¡æ¯ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.web.export-allow-other</code>ï¼æ¯å¦æ¯æå
¶ä»ç¨æ·å¯¼åºä¿¡æ¯ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.web.dashboard-enabled</code>ï¼æ¯å¦å¯ç¨ Dashboardï¼é»è®¤å¼ä¸º FALSE</li>
+</ul>
+
+<h3 id="kylin_metastore">Metastore é
ç½®</h3>
+
+<p>æ¬å°èä»ç» Kylin Metastore ç¸å
³çé
ç½®ã</p>
+
+<h3 id="metadata">å
æ°æ®</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.metadata.url</code>ï¼æå®å
æ°æ®åºè·¯å¾ï¼é»è®¤å¼ä¸º kylin_metadata@hbase</li>
+ <li><code class="highlighter-rouge">kylin.metadata.dimension-encoding-max-length</code>ï¼æå®ç»´åº¦ä½ä¸º Rowkeys æ¶ä½¿ç¨ fix_length ç¼ç æ¶çæ大é¿åº¦ï¼é»è®¤å¼ä¸º 256</li>
+ <li><code class="highlighter-rouge">kylin.metadata.sync-retries</code>ï¼æå®å
æ°æ®åæ¥éè¯æ¬¡æ°ï¼é»è®¤å¼ä¸º 3</li>
+ <li><code class="highlighter-rouge">kylin.metadata.sync-error-handler</code>ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">DefaultSyncErrorHandler</code></li>
+ <li><code class="highlighter-rouge">kylin.metadata.check-copy-on-write</code>ï¼æ¸
é¤å
æ°æ®ç¼åï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">FALSE</code></li>
+ <li><code class="highlighter-rouge">kylin.metadata.hbase-client-scanner-timeout-period</code>ï¼è¡¨ç¤º HBase 客æ·ç«¯åèµ·ä¸æ¬¡ scan æä½ç RPC è°ç¨è³å¾å°ååºä¹é´æ»çè¶
æ¶æ¶é´ï¼é»è®¤å¼ä¸º 10000(ms)</li>
+ <li><code class="highlighter-rouge">kylin.metadata.hbase-rpc-timeout</code>ï¼æå® HBase æ§è¡ RPC æä½çè¶
æ¶æ¶é´ï¼é»è®¤å¼ä¸º 5000(ms)</li>
+ <li><code class="highlighter-rouge">kylin.metadata.hbase-client-retries-number</code>ï¼æå® HBase éè¯æ¬¡æ°ï¼é»è®¤å¼ä¸º 1ï¼æ¬¡ï¼</li>
+ <li><code class="highlighter-rouge">kylin.metadata.resource-store-provider.jdbc</code>ï¼æå® JDBC 使ç¨çç±»ï¼é»è®¤å¼ä¸ºorg.apache.kylin.common.persistence.JDBCResourceStore</li>
+</ul>
+
+<h3 id="mysql-metastore">ä½¿ç¨ MySQL ä½ä¸º Metastore (æµè¯)</h3>
+
+<blockquote>
+ <p><strong>注æ</strong>ï¼è¯¥åè½è¿å¨æµè¯ä¸ï¼å»ºè®®æ¨è°¨æ
使ç¨ã</p>
+</blockquote>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.metadata.url</code>ï¼æå®å
æ°æ®è·¯å¾</li>
+ <li><code class="highlighter-rouge">kylin.metadata.jdbc.dialect</code>ï¼æå® JDBC æ¹è¨</li>
+ <li><code class="highlighter-rouge">kylin.metadata.jdbc.json-always-small-cell</code>ï¼é»è®¤å¼ä¸º true</li>
+ <li><code class="highlighter-rouge">kylin.metadata.jdbc.small-cell-meta-size-warning-threshold</code>ï¼é»è®¤å¼ä¸º 100(MB)</li>
+ <li><code class="highlighter-rouge">kylin.metadata.jdbc.small-cell-meta-size-error-threshold</code>ï¼é»è®¤å¼ä¸º 1(GB)</li>
+ <li><code class="highlighter-rouge">kylin.metadata.jdbc.max-cell-size</code>ï¼é»è®¤å¼ä¸º 1(MB)</li>
+ <li><code class="highlighter-rouge">kylin.metadata.resource-store-provider.jdbc</code>ï¼æå® JDBC 使ç¨çç±»ï¼é»è®¤å¼ä¸º org.apache.kylin.common.persistence.JDBCResourceStore</li>
+</ul>
+
+<blockquote>
+ <p>æ示ï¼æ´å¤ä¿¡æ¯è¯·åè<a href="/docs/tutorial/mysql_metastore.html">åºäº MySQL ç Metastore é
ç½®</a></p>
+</blockquote>
+
+<h3 id="kylin-build">æ建é
ç½®</h3>
+
+<p>æ¬å°èä»ç» Kylin æ°æ®å»ºæ¨¡åæ建ç¸å
³çé
ç½®ã</p>
+
+<h3 id="hive-client-and-sparksql">Hive 客æ·ç«¯ & SparkSQL</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.source.hive.client</code>ï¼æå® Hive å½ä»¤è¡ç±»åï¼åæ°å¼å¯é cli æ beelineï¼é»è®¤å¼ä¸º cli</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.beeline-shell</code>ï¼æå® Beeline shell çç»å¯¹è·¯å¾ï¼é»è®¤ä¸º beeline</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.beeline-params</code>ï¼å½ä½¿ç¨ Beeline å为 Hive ç Client å·¥å
·æ¶ï¼éè¦é
ç½®æ¤åæ°ï¼ä»¥æä¾æ´å¤ä¿¡æ¯ç» Beeline</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.enable-sparksql-for-table-ops</code>ï¼é»è®¤å¼ä¸º FALSEï¼å½ä½¿ç¨ SparkSQL æ¶éè¦è®¾ç½®ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.sparksql-beeline-shell</code>ï¼å½ä½¿ç¨ SparkSQL Beeline å为 Hive ç Client å·¥å
·æ¶ï¼éè¦é
ç½®æ¤åæ°ä¸º /path/to/spark-client/bin/beeline</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.sparksql-beeline-params</code>ï¼å½ä½¿ç¨ SparkSQL Beeline å为 Hive ç Client å·¥å
·æ¶ï¼éè¦é
ç½®æ¤åæ°</li>
+</ul>
+
+<h3 id="jdbc-datasource">é
ç½® JDBC æ°æ®æº</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.source.default</code>ï¼JDBC 使ç¨çæ°æ®æºç§ç±»</li>
+ <li><code class="highlighter-rouge">kylin.source.jdbc.connection-url</code>ï¼JDBC è¿æ¥å符串</li>
+ <li><code class="highlighter-rouge">kylin.source.jdbc.driver</code>ï¼JDBC 驱å¨ç±»å</li>
+ <li><code class="highlighter-rouge">kylin.source.jdbc.dialect</code>ï¼JDBCæ¹è¨ï¼é»è®¤å¼ä¸º default</li>
+ <li><code class="highlighter-rouge">kylin.source.jdbc.user</code>ï¼JDBC è¿æ¥ç¨æ·å</li>
+ <li><code class="highlighter-rouge">kylin.source.jdbc.pass</code>ï¼JDBC è¿æ¥å¯ç </li>
+ <li><code class="highlighter-rouge">kylin.source.jdbc.sqoop-home</code>ï¼Sqoop å®è£
è·¯å¾</li>
+ <li><code class="highlighter-rouge">kylin.source.jdbc.sqoop-mapper-num</code>ï¼æå®åºè¯¥å为å¤å°ä¸ªåçï¼Sqoop å°ä¸ºæ¯ä¸ä¸ªåçè¿è¡ä¸ä¸ª mapperï¼é»è®¤å¼ä¸º 4</li>
+ <li><code class="highlighter-rouge">kylin.source.jdbc.field-delimiter</code>ï¼æå®å段åéç¬¦ï¼ é»è®¤å¼ä¸º \</li>
+</ul>
+
+<blockquote>
+ <p>æ示ï¼æ´å¤ä¿¡æ¯è¯·åè<a href="/docs/tutorial/setup_jdbc_datasource.html">å»ºç« JDBC æ°æ®æº</a>ã</p>
+</blockquote>
+
+<h3 id="precision-config">æ°æ®ç±»å精度</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.source.hive.default-varchar-precision</code>ï¼æå® varchar å段çæ大é¿åº¦ï¼é»è®¤å¼ä¸º256</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.default-char-precision</code>ï¼æå® char å段çæ大é¿åº¦ï¼é»è®¤å¼ä¸º 255</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.default-decimal-precision</code>ï¼æå® decimal å段ç精度ï¼é»è®¤å¼ä¸º 19</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.default-decimal-scale</code>ï¼æå® decimal å段çèå´ï¼é»è®¤å¼ä¸º 4</li>
+</ul>
+
+<h3 id="cube-config">Cube 设置</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.cube.ignore-signature-inconsistency</code>ï¼Cube desc ä¸ç signature ä¿¡æ¯è½ä¿è¯ Cube ä¸è¢«æ´æ¹ä¸ºæåç¶æï¼é»è®¤å¼ä¸º FALSE</li>
+ <li><code class="highlighter-rouge">kylin.cube.aggrgroup.max-combination</code>ï¼æå®ä¸ä¸ª Cube çèåç» Cuboid ä¸éï¼é»è®¤å¼ä¸º 32768ï¼ä¸å»ºè®®ä¿®æ¹ï¼è¿å¤§ç Cuboid æ°ä¼å¯¼è´æ建èæ¶åè¨èçé½è¾¾å°ä¸å¯æ¥åçç¨åº¦</li>
+ <li><code class="highlighter-rouge">kylin.cube.aggrgroup.is-mandatory-only-valid</code>ï¼æ¯å¦å
许 Cube åªå
å« Base Cuboidï¼é»è®¤å¼ä¸º FALSEï¼å½ä½¿ç¨ Spark Cubing æ¶é设置为 TRUE</li>
+ <li><code class="highlighter-rouge">kylin.cube.rowkey.max-size</code>ï¼æå®å¯ä»¥è®¾ç½®ä¸º Rowkeys çæ大åæ°ï¼é»è®¤å¼ä¸º 63</li>
+ <li><code class="highlighter-rouge">kylin.cube.allow-appear-in-multiple-projects</code>ï¼æ¯å¦å
许ä¸ä¸ª Cube åºç°å¨å¤ä¸ªé¡¹ç®ä¸</li>
+ <li><code class="highlighter-rouge">kylin.cube.gtscanrequest-serialization-level</code>ï¼é»è®¤ä¸º 1</li>
+</ul>
+
+<h3 id="cube-estimate">Cube 大å°ä¼°è®¡</h3>
+
+<p>Kylin å HBase é½å¨åå
¥ç£çæ¶ä½¿ç¨å缩ï¼å æ¤ï¼Kylin å°å¨å
¶åæ¥ç大å°ä¸ä¹ä»¥æ¯çæ¥ä¼°è®¡ Cube 大å°ã</p>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.cube.size-estimate-ratio</code>ï¼æ®éç Cubeï¼é»è®¤å¼ä¸º 0.25</li>
+ <li><code class="highlighter-rouge">kylin.cube.size-estimate-memhungry-ratio</code>ï¼å·²åºå¼ï¼é»è®¤å¼ä¸º 0.05</li>
+ <li><code class="highlighter-rouge">kylin.cube.size-estimate-countdistinct-ratio</code>ï¼å
å«ç²¾ç¡®å»é度éç Cube 大å°ä¼°è®¡ï¼é»è®¤å¼ä¸º 0.5</li>
+ <li><code class="highlighter-rouge">kylin.cube.size-estimate-topn-ratio</code>ï¼å
å« TopN 度éç Cube 大å°ä¼°è®¡ï¼é»è®¤å¼ä¸º 0.5</li>
+</ul>
+
+<h3 id="cube-algorithm">Cube æ建ç®æ³</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.cube.algorithm</code>ï¼æå® Cube æ建çç®æ³ï¼åæ°å¼å¯é <code class="highlighter-rouge">auto</code>ï¼<code class="highlighter-rouge">layer</code> å <code class="highlighter-rouge">inmem</code>ï¼ é»è®¤å¼ä¸º <code class="highlighter-rouge">auto</code>ï¼å³ Kylin ä¼éè¿ééæ°æ®å¨æå°éæ©ä¸ä¸ªç®æ³ (layer or inmem)ï¼å¦ææ¨å¾äºè§£ Kylin åæ¨çæ°æ®ãé群ï¼æ¨å¯ä»¥ç´æ¥è®¾ç½®æ¨å欢çç®æ³</li>
+ <li><code class="highlighter-rouge">kylin.cube.algorithm.layer-or-inmem-threshold</code>ï¼é»è®¤å¼ä¸º 7</li>
+ <li><code class="highlighter-rouge">kylin.cube.algorithm.inmem-split-limit</code>ï¼é»è®¤å¼ä¸º 500</li>
+ <li><code class="highlighter-rouge">kylin.cube.algorithm.inmem-concurrent-threads</code>ï¼é»è®¤å¼ä¸º 1</li>
+ <li><code class="highlighter-rouge">kylin.job.sampling-percentage</code>ï¼æå®æ°æ®éæ ·ç¾åæ¯ï¼é»è®¤å¼ä¸º 100</li>
+</ul>
+
+<h3 id="auto-merge">èªå¨å并</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.cube.is-automerge-enabled</code>ï¼æ¯å¦å¯ç¨èªå¨å并ï¼é»è®¤å¼ä¸º TRUEï¼å°è¯¥åæ°è®¾ç½®ä¸º FALSE æ¶ï¼èªå¨å并åè½ä¼è¢«å
³éï¼å³ä½¿ Cube 设置ä¸å¼å¯äºèªå¨å并ã设置äºèªå¨å并éå¼ï¼ä¹ä¸ä¼è§¦åå并任å¡ã</li>
+</ul>
+
+<h3 id="snapshot">维表快ç
§</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.snapshot.max-mb</code>ï¼å
许维表çå¿«ç
§å¤§å°çä¸éï¼é»è®¤å¼ä¸º 300 (M)</li>
+ <li><code class="highlighter-rouge">kylin.snapshot.max-cache-entry</code>ï¼ç¼åä¸æå¤å¯ä»¥åå¨ç snapshot æ°éï¼é»è®¤å¼ä¸º 500</li>
+ <li><code class="highlighter-rouge">kylin.snapshot.ext.shard-mb</code>ï¼è®¾ç½®åå¨ç»´è¡¨å¿«ç
§ç HBase åç大å°ï¼é»è®¤å¼ä¸º 500(M)</li>
+ <li><code class="highlighter-rouge">kylin.snapshot.ext.local.cache.path</code>ï¼æ¬å°ç¼åè·¯å¾ï¼é»è®¤å¼ä¸º lookup_cache</li>
+ <li><code class="highlighter-rouge">kylin.snapshot.ext.local.cache.max-size-gb</code>ï¼æ¬å°ç»´è¡¨å¿«ç
§ç¼å大å°ï¼é»è®¤å¼ä¸º 200(M)</li>
+</ul>
+
+<h3 id="cube-build">Cube æ建</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.storage.default</code>ï¼æå®é»è®¤çæ建å¼æï¼é»è®¤å¼ä¸º 2ï¼å³ HBase</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.keep-flat-table</code>ï¼æ¯å¦å¨æ建å®æåä¿ç Hive ä¸é´è¡¨ï¼é»è®¤å¼ä¸º FALSE</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.database-for-flat-table</code>ï¼æå®åæ¾ Hive ä¸é´è¡¨ç Hive æ°æ®åºååï¼é»è®¤ä¸º defaultï¼è¯·ç¡®ä¿å¯å¨ Kylin å®ä¾çç¨æ·ææä½è¯¥æ°æ®åºçæé</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.flat-table-storage-format</code>ï¼æå® Hive ä¸é´è¡¨çåå¨æ ¼å¼ï¼é»è®¤å¼ä¸º SEQUENCEFILE</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.flat-table-field-delimiter</code>ï¼æå® Hive ä¸é´è¡¨çåé符ï¼é»è®¤å¼ä¸º \u001F</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.redistribute-flat-table</code>ï¼æ¯å¦éåé
Hive 平表ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.redistribute-column-count</code>ï¼éåé
åçæ°éï¼é»è®¤å¼ä¸º 3</li>
+ <li><code class="highlighter-rouge">kylin.source.hive.table-dir-create-first</code>ï¼é»è®¤å¼ä¸º FALSE</li>
+ <li><code class="highlighter-rouge">kylin.storage.partition.aggr-spill-enabled</code>ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">TRUE</code></li>
+ <li><code class="highlighter-rouge">kylin.engine.mr.lib-dir</code>ï¼æå® MapReduce ä»»å¡æ使ç¨ç jar å
çè·¯å¾</li>
+ <li><code class="highlighter-rouge">kylin.engine.mr.reduce-input-mb</code>ï¼MapReduce ä»»å¡å¯å¨åä¼ä¾æ®è¾å
¥é¢ä¼° Reducer æ¥æ¶æ°æ®çæ»éï¼åé¤ä»¥è¯¥åæ°å¾åº Reducer çæ°ç®ï¼é»è®¤å¼ä¸º 500ï¼MBï¼</li>
+ <li><code class="highlighter-rouge">kylin.engine.mr.reduce-count-ratio</code>ï¼ç¨äºä¼°ç® Reducer æ°ç®ï¼é»è®¤å¼ä¸º 1.0</li>
+ <li><code class="highlighter-rouge">kylin.engine.mr.min-reducer-number</code>ï¼MapReduce ä»»å¡ä¸ Reducer æ°ç®çæå°å¼ï¼é»è®¤ä¸º 1</li>
+ <li><code class="highlighter-rouge">kylin.engine.mr.max-reducer-number</code>ï¼MapReduce ä»»å¡ä¸ Reducer æ°ç®çæ大å¼ï¼é»è®¤ä¸º 500</li>
+ <li><code class="highlighter-rouge">kylin.engine.mr.mapper-input-rows</code>ï¼æ¯ä¸ª Mapper å¯ä»¥å¤ççè¡æ°ï¼é»è®¤å¼ä¸º 1000000ï¼å¦æå°è¿ä¸ªå¼è°å°ï¼ä¼èµ·æ´å¤ç Mapper</li>
+ <li><code class="highlighter-rouge">kylin.engine.mr.max-cuboid-stats-calculator-number</code>ï¼ç¨äºè®¡ç® Cube ç»è®¡æ°æ®ç线ç¨æ°éï¼é»è®¤å¼ä¸º 1</li>
+ <li><code class="highlighter-rouge">kylin.engine.mr.build-dict-in-reducer</code>ï¼æ¯å¦å¨æå»ºä»»å¡ <strong>Extract Fact Table Distinct Columns</strong> ç Reduce é¶æ®µæ建åå
¸ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">TRUE</code></li>
+ <li><code class="highlighter-rouge">kylin.engine.mr.yarn-check-interval-seconds</code>ï¼æ建å¼æé´éå¤ä¹
æ£æ¥ Hadoop ä»»å¡çç¶æï¼é»è®¤å¼ä¸º 10ï¼sï¼</li>
+</ul>
+
+<h3 id="dict-config">åå
¸ç¸å
³</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.dictionary.use-forest-trie</code>ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.dictionary.forest-trie-max-mb</code>ï¼é»è®¤å¼ä¸º 500</li>
+ <li><code class="highlighter-rouge">kylin.dictionary.max-cache-entry</code>ï¼é»è®¤å¼ä¸º 3000</li>
+ <li><code class="highlighter-rouge">kylin.dictionary.growing-enabled</code>ï¼é»è®¤å¼ä¸º FALSE</li>
+ <li><code class="highlighter-rouge">kylin.dictionary.append-entry-size</code>ï¼é»è®¤å¼ä¸º 10000000</li>
+ <li><code class="highlighter-rouge">kylin.dictionary.append-max-versions</code>ï¼é»è®¤å¼ä¸º 3</li>
+ <li><code class="highlighter-rouge">kylin.dictionary.append-version-ttl</code>ï¼é»è®¤å¼ä¸º 259200000</li>
+ <li><code class="highlighter-rouge">kylin.dictionary.resuable</code>ï¼æ¯å¦éç¨åå
¸ï¼é»è®¤å¼ä¸º FALSE</li>
+ <li><code class="highlighter-rouge">kylin.dictionary.shrunken-from-global-enable</code>ï¼æ¯å¦ç¼©å°å
¨å±åå
¸ï¼é»è®¤å¼ä¸º FALSE</li>
+</ul>
+
+<h3 id="uhc-config">è¶
é«åºç»´åº¦çå¤ç</h3>
+
+<p>Cube æ建é»è®¤å¨ <strong>Extract Fact Table Distinct Column</strong> è¿ä¸æ¥ä¸ºæ¯ä¸ååé
ä¸ä¸ª Reducerï¼å¯¹äºè¶
é«åºç»´åº¦ï¼å¯ä»¥éè¿ä»¥ä¸åæ°å¢å Reducer 个æ°<br />
+- <code class="highlighter-rouge">kylin.engine.mr.build-uhc-dict-in-additional-step</code>ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">FALSE</code>ï¼è®¾ç½®ä¸º <code class="highlighter-rouge">TRUE</code><br />
+- <code class="highlighter-rouge">kylin.engine.mr.uhc-reducer-count</code>ï¼é»è®¤å¼ä¸º 1ï¼å¯ä»¥è®¾ç½®ä¸º 5ï¼å³ä¸ºæ¯ä¸ªè¶
é«åºçååé
5 个 Reducerã</p>
+
+<h3 id="spark-cubing">Spark æ建å¼æ</h3>
+
+<p>Kylin æ¯æä½¿ç¨ Spark ä½ä¸º Cube çæ建å¼æï¼è¯¦æ
请åè <a href="/docs/tutorial/cube_spark.html">ç¨ Spark æ建 Cube</a>ã<br />
+ä¸ Spark Cubing æå
³çåæ°å¦ä¸ï¼</p>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.master</code>ï¼æå® Spark è¿è¡æ¨¡å¼ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">yarn</code></li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.submit.deployMode</code>ï¼æå® Spark on YARN çé¨ç½²æ¨¡å¼ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">cluster</code></li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.yarn.queue</code>ï¼æå® Spark èµæºéåï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">default</code></li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.driver.memory</code>ï¼æå® Spark Driver å
å大å°ï¼é»è®¤å¼ä¸º 2G</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.executor.memory</code>ï¼æå® Spark Executor å
å大å°ï¼é»è®¤å¼ä¸º 4G</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.yarn.executor.memoryOverhead</code>ï¼æå® Spark Executor å å¤å
å大å°ï¼é»è®¤å¼ä¸º 1024(M)</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.executor.cores</code>ï¼æå®å个 Spark Executorå¯ç¨æ ¸å¿æ°ï¼é»è®¤å¼ä¸º 1</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.network.timeout</code>ï¼æå® Spark ç½ç»è¶
æ¶æ¶é´ï¼600</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.executor.instances</code>ï¼æå®ä¸ä¸ª Application æ¥æç Spark Executor æ°éï¼é»è®¤å¼ä¸º 1</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.eventLog.enabled</code>ï¼æ¯å¦è®°å½ Spark æ¶é´ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.hadoop.dfs.replication</code>ï¼HDFS çå¯æ¬æ°ï¼é»è®¤å¼ä¸º 2</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.hadoop.mapreduce.output.fileoutputformat.compress</code>ï¼æ¯å¦å缩è¾åºï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.hadoop.mapreduce.output.fileoutputformat.compress.codec</code>ï¼è¾åºæç¨å缩ï¼é»è®¤å¼ä¸º org.apache.hadoop.io.compress.DefaultCodec</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark.rdd-partition-cut-mb</code>ï¼Kylin ç¨è¯¥åæ°ç大å°æ¥åå² partitionï¼é»è®¤å¼ä¸º 10(MB)ï¼å¯ä»¥å¨ Cube 级å«éåè¿ä¸ªåæ°ï¼è°æ´è³æ´å¤§ï¼æ¥åå°ååºæ°</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark.min-partition</code>ï¼æå°ååºæ°ï¼é»è®¤å¼ä¸º 1</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark.max-partition</code>ï¼æ大ååºæ°ï¼é»è®¤å¼ä¸º 5000</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark.storage-level</code>ï¼RDD ååºæ°æ®ç¼å级å«ï¼é»è®¤å¼ä¸º MEMORY_AND_DISK_SER</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf-mergedict.spark.executor.memory</code>ï¼ä¸ºå并åå
¸ç³è¯·æ´å¤çå
åï¼é»è®¤å¼ä¸º 6G</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf-mergedict.spark.memory.fraction</code>ï¼ç»ç³»ç»é¢ççå
åç¾åæ¯ï¼é»è®¤å¼ä¸º 0.2</li>
+</ul>
+
+<h3 id="dynamic-allocation">Spark èµæºå¨æåé
</h3>
+
+<p>Spark èµæºå¨æåé
ç详ç»ä»ç»è¯·åèå®æ¹ææ¡£ï¼<a href="http://spark.apache.org/docs/1.6.2/job-scheduling.html#dynamic-resource-allocation">Dynamic Resource Allocation</a>ã<br />
+å¯ç¨ Spark èµæºå¨æåé
ï¼éè¦ä¿®æ¹é群çèµæºç®¡çå¨ç¸å
³é
ç½®ï¼ä¼æ ¹æ®èµæºç®¡çå¨çä¸åï¼YARNãMesos æ Standaloneï¼æä¸åçé
ç½®æ¹æ³ï¼å¦å¤éè¦å¨ <code class="highlighter-rouge">kylin.properties</code> ä¸è¿è¡å¦ä¸é
ç½®ï¼</p>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.shuffle.service.enabled</code>ï¼æ¯å¦å¼å¯ shuffle service</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.dynamicAllocation.enabled</code>ï¼æ¯å¦å¯ç¨ Spark èµæºå¨æåé
</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.dynamicAllocation.initialExecutors</code>ï¼å¦æææç Executor é½ç§»é¤äºï¼éæ°è¯·æ±å¯å¨æ¶åå§ Executor æ°é</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.dynamicAllocation.minExecutors</code>ï¼æå°ä¿çç Executor æ°é</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.dynamicAllocation.maxExecutors</code>ï¼æå¤ç³è¯·ç Executor æ°é</li>
+ <li><code class="highlighter-rouge">kylin.engine.spark-conf.spark.dynamicAllocation.executorIdleTimeout</code>ï¼Executor 空é²æ¶é´è¶
è¿è®¾ç½®çå¼åï¼é¤éæç¼åæ°æ®ï¼ä¸ç¶ä¼è¢«ç§»é¤ï¼é»è®¤å¼ä¸º 60(s)</li>
+</ul>
+
+<h3 id="job-config">ä»»å¡ç¸å
³</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.job.log-dir</code>ï¼é»è®¤å¼ä¸º /tmp/kylin/logs</li>
+ <li><code class="highlighter-rouge">kylin.job.allow-empty-segment</code>ï¼æ¯å¦å®¹å¿æ°æ®æºä¸ºç©ºï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.job.max-concurrent-jobs</code>ï¼æ大æ建并åæ°ï¼é»è®¤å¼ä¸º 10</li>
+ <li><code class="highlighter-rouge">kylin.job.retry</code>ï¼æ建任å¡å¤±è´¥åçéè¯æ¬¡æ°ï¼é»è®¤å¼ä¸º 0</li>
+ <li><code class="highlighter-rouge">kylin.job.scheduler.priority-considered</code>ï¼æ¯å¦èèä»»å¡ä¼å
级ï¼é»è®¤å¼ä¸º FALSE</li>
+ <li><code class="highlighter-rouge">kylin.job.scheduler.priority-bar-fetch-from-queue</code>ï¼æå®ä»ä¼å
级éåä¸è·åä»»å¡çæ¶é´é´éï¼é»è®¤å¼ä¸º 20(s)</li>
+ <li><code class="highlighter-rouge">kylin.job.scheduler.poll-interval-second</code>ï¼ä»éåä¸è·åä»»å¡çæ¶é´é´éï¼é»è®¤å¼ä¸º 30(s)</li>
+ <li><code class="highlighter-rouge">kylin.job.error-record-threshold</code>ï¼æå®ä»»å¡æåºé误信æ¯çéå¼ï¼é»è®¤å¼ä¸º 0</li>
+ <li><code class="highlighter-rouge">kylin.job.cube-auto-ready-enabled</code>ï¼æ¯å¦å¨æ建å®æåèªå¨å¯ç¨ Cubeï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.cube.max-building-segments</code>ï¼æå®å¯¹åä¸ä¸ª Cube çæ大æ建æ°éï¼é»è®¤å¼ä¸º 10</li>
+</ul>
+
+<h3 id="email-notification">å¯ç¨é®ä»¶éç¥</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.job.notification-enabled</code>ï¼æ¯å¦å¨ä»»å¡æåæè
失败æ¶è¿è¡é®ä»¶éç¥ï¼é»è®¤å¼ä¸º FALSE</li>
+ <li><code class="highlighter-rouge">kylin.job.notification-mail-enable-starttls</code>ï¼# æ¯å¦å¯ç¨ starttlsï¼é»è®¤å¼ä¸º FALSE</li>
+ <li><code class="highlighter-rouge">kylin.job.notification-mail-host</code>ï¼æå®é®ä»¶ç SMTP æå¡å¨å°å</li>
+ <li><code class="highlighter-rouge">kylin.job.notification-mail-port</code>ï¼æå®é®ä»¶ç SMTP æå¡å¨ç«¯å£ï¼é»è®¤ä¸º 25</li>
+ <li><code class="highlighter-rouge">kylin.job.notification-mail-username</code>ï¼æå®é®ä»¶çç»å½ç¨æ·å</li>
+ <li><code class="highlighter-rouge">kylin.job.notification-mail-password</code>ï¼æå®é®ä»¶çç¨æ·åå¯ç </li>
+ <li><code class="highlighter-rouge">kylin.job.notification-mail-sender</code>ï¼æå®é®ä»¶çåéé®ç®±å°å</li>
+ <li><code class="highlighter-rouge">kylin.job.notification-admin-emails</code>ï¼æå®é®ä»¶éç¥ç管çåé®ç®±</li>
+</ul>
+
+<h3 id="cube-planner">å¯ç¨ Cube Planner</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.cube.cubeplanner.enabled</code>ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.server.query-metrics2-enabled</code>ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.metrics.reporter-query-enabled</code>ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.metrics.reporter-job-enabled</code>ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.metrics.monitor-enabled</code>ï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.cube.cubeplanner.enabled</code>ï¼æ¯å¦å¯ç¨ Cube Plannerï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.cube.cubeplanner.enabled-for-existing-cube</code>ï¼æ¯å¦å¯¹å·²æç Cube å¯ç¨ Cube Plannerï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.cube.cubeplanner.algorithm-threshold-greedy</code>ï¼é»è®¤å¼ä¸º 8</li>
+ <li><code class="highlighter-rouge">kylin.cube.cubeplanner.expansion-threshold</code>ï¼é»è®¤å¼ä¸º 15.0</li>
+ <li><code class="highlighter-rouge">kylin.cube.cubeplanner.recommend-cache-max-size</code>ï¼é»è®¤å¼ä¸º 200</li>
+ <li><code class="highlighter-rouge">kylin.cube.cubeplanner.mandatory-rollup-threshold</code>ï¼é»è®¤å¼ä¸º 1000</li>
+ <li><code class="highlighter-rouge">kylin.cube.cubeplanner.algorithm-threshold-genetic</code>ï¼é»è®¤å¼ä¸º 23</li>
+</ul>
+
+<blockquote>
+ <p>æ示ï¼æ´å¤ä¿¡æ¯è¯·åè <a href="/docs/tutorial/use_cube_planner.html">ä½¿ç¨ Cube Planner</a>ã</p>
+</blockquote>
+
+<h3 id="hbase-config">HBase åå¨</h3>
+
+<ul>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.table-name-prefix</code>ï¼é»è®¤å¼ä¸º KYLIN_</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.namespace</code>ï¼æå® HBase åå¨é»è®¤ç namespaceï¼é»è®¤å¼ä¸º default</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.coprocessor-local-jar</code>ï¼æå HBase åå¤çå¨æå
³ jar å
</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.coprocessor-mem-gb</code>ï¼è®¾ç½® HBase åå¤çå¨å
å大å°ï¼é»è®¤å¼ä¸º 3.0(GB)</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.run-local-coprocessor</code>ï¼æ¯å¦è¿è¡æ¬å° HBase åå¤çå¨ï¼é»è®¤å¼ä¸º FALSE</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.coprocessor-timeout-seconds</code>ï¼è®¾ç½®è¶
æ¶æ¶é´ï¼é»è®¤å¼ä¸º 0</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.region-cut-gb</code>ï¼å个 Region ç大å°ï¼é»è®¤å¼ä¸º 5.0</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.min-region-count</code>ï¼æå®æå° Region 个æ°ï¼é»è®¤å¼ä¸º 1</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.max-region-count</code>ï¼æå®æ大 Region 个æ°ï¼é»è®¤å¼ä¸º 500</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.hfile-size-gb</code>ï¼æå® HFile 大å°ï¼é»è®¤å¼ä¸º 2.0(GB)</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.max-scan-result-bytes</code>ï¼æå®æ«æè¿åç»æçæ大å¼ï¼é»è®¤å¼ä¸º 5242880(byte)ï¼å³ 5(MB)</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.compression-codec</code>ï¼æ¯å¦å缩ï¼é»è®¤å¼ä¸º noneï¼å³ä¸å¼å¯å缩</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.rowkey-encoding</code>ï¼æå® Rowkey çç¼ç æ¹å¼ï¼é»è®¤å¼ä¸º FAST_DIFF</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.block-size-bytes</code>ï¼é»è®¤å¼ä¸º 1048576</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.small-family-block-size-bytes</code>ï¼æå® Block 大å°ï¼é»è®¤å¼ä¸º 65536(byte)ï¼å³ 64(KB)</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.owner-tag</code>ï¼æå® Kylin å¹³å°çæå±äººï¼é»è®¤å¼ä¸º whoami@kylin.apache.org</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.endpoint-compress-result</code>ï¼æ¯å¦è¿åå缩ç»æï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.max-hconnection-threads</code>ï¼æå®è¿æ¥çº¿ç¨æ°éçæ大å¼ï¼é»è®¤å¼ä¸º 2048</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.core-hconnection-threads</code>ï¼æå®æ ¸å¿è¿æ¥çº¿ç¨çæ°éï¼é»è®¤å¼ä¸º 2048</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.hconnection-threads-alive-seconds</code>ï¼æå®çº¿ç¨åæ´»æ¶é´ï¼é»è®¤å¼ä¸º 60</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.replication-scope</code>ï¼æå®é群å¤å¶èå´ï¼é»è®¤å¼ä¸º 0</li>
+ <li><code class="highlighter-rouge">kylin.storage.hbase.scan-cache-rows</code>ï¼æå®æ«æç¼åè¡æ°ï¼é»è®¤å¼ä¸º 1024</li>
+</ul>
+
+<h3 id="compress-config">å¯ç¨å缩</h3>
+
+<p>Kylin å¨é»è®¤ç¶æä¸ä¸ä¼å¯ç¨å缩ï¼ä¸æ¯æçå缩ç®æ³ä¼é»ç¢ Kylin çæ建任å¡ï¼ä½æ¯ä¸ä¸ªåéçå缩ç®æ³å¯ä»¥åå°åå¨å¼éåç½ç»å¼éï¼æé«æ´ä½ç³»ç»è¿è¡æçã<br />
+Kylin å¯ä»¥ä½¿ç¨ä¸ç§ç±»åçå缩ï¼åå«æ¯ HBase 表å缩ï¼Hive è¾åºå缩 å MapReduce ä»»å¡è¾åºå缩ã <br />
+> <strong>注æ</strong>ï¼å缩设置åªæå¨éå¯ Kylin å®ä¾åæä¼çæã</p>
+
+<ul>
+ <li>HBase 表å缩</li>
+</ul>
+
+<p>该项å缩éè¿ <code class="highlighter-rouge">kyiln.properties</code> ä¸ç <code class="highlighter-rouge">kylin.hbase.default.compression.codec</code> è¿è¡é
ç½®ï¼åæ°å¼å¯é <code class="highlighter-rouge">none</code>ï¼<code class="highlighter-rouge">snappy</code>ï¼<code class="highlighter-rouge">lzo</code>ï¼<code class="highlighter-rouge">gzip</code> å <code class="highlighter-rouge">lz4</code>ï¼é»è®¤å¼ä¸º <code class="highlighter-rouge">none</code>ï¼å³ä¸å缩æ°æ®ã<br />
+> <strong>注æ</strong>ï¼å¨ä¿®æ¹å缩ç®æ³åï¼è¯·ç¡®ä¿æ¨ç HBase é群æ¯ææéå缩ç®æ³ã</p>
+
+<ul>
+ <li>Hive è¾åºå缩</li>
+</ul>
+
+<p>该项å缩éè¿ <code class="highlighter-rouge">kylin_hive_conf.xml</code> è¿è¡é
ç½®ï¼é»è®¤é
置为空ï¼å³ç´æ¥ä½¿ç¨äº Hive çé»è®¤é
ç½®ãå¦ææ³éåé
ç½®ï¼è¯·å¨ <code class="highlighter-rouge">kylin_hive_conf.xml</code> ä¸æ·»å (ææ¿æ¢) ä¸åå±æ§ã以 SNAPPY å缩为ä¾ï¼</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="nt"><property></span>
+ <span class="nt"><name></span>mapreduce.map.output.compress.codec<span class="nt"></name></span>
+ <span class="nt"><value></span>org.apache.hadoop.io.compress.SnappyCodec<span class="nt"></value></span>
+ <span class="nt"><description></description></span>
+<span class="nt"></property></span>
+<span class="nt"><property></span>
+ <span class="nt"><name></span>mapreduce.output.fileoutputformat.compress.codec<span class="nt"></name></span>
+ <span class="nt"><value></span>org.apache.hadoop.io.compress.SnappyCodec<span class="nt"></value></span>
+ <span class="nt"><description></description></span>
+<span class="nt"></property></span>
+</code></pre>
+</div>
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">-bash-4.1# ls -l $KYLIN_HOME/conf
+<ul>
+ <li>MapReduce ä»»å¡è¾åºå缩</li>
+</ul>
+
+<p>该项å缩éè¿ <code class="highlighter-rouge">kylin_job_conf.xml</code> å <code class="highlighter-rouge">kylin_job_conf_inmem.xml</code> è¿è¡é
ç½®ãé»è®¤ä¸ºç©ºï¼å³ä½¿ç¨ MapReduce çé»è®¤é
ç½®ãå¦ææ³éåé
ç½®ï¼è¯·å¨ <code class="highlighter-rouge">kylin_job_conf.xml</code> å <code class="highlighter-rouge">kylin_job_conf_inmem.xml</code> ä¸æ·»å (ææ¿æ¢) ä¸åå±æ§ã以 SNAPPY å缩为ä¾ï¼</p>
+
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="nt"><property></span>
+ <span class="nt"><name></span>mapreduce.map.output.compress.codec<span class="nt"></name></span>
+ <span class="nt"><value></span>org.apache.hadoop.io.compress.SnappyCodec<span class="nt"></value></span>
+ <span class="nt"><description></description></span>
+<span class="nt"></property></span>
+<span class="nt"><property></span>
+ <span class="nt"><name></span>mapreduce.output.fileoutputformat.compress.codec<span class="nt"></name></span>
+ <span class="nt"><value></span>org.apache.hadoop.io.compress.SnappyCodec<span class="nt"></value></span>
+ <span class="nt"><description></description></span>
+<span class="nt"></property></span>
+</code></pre>
+</div>
+
+<h3 id="kylin-query">æ¥è¯¢é
ç½® {$kylin-query}</h3>
+
+<p>æ¬å°èä»ç» Kylin æ¥è¯¢æå
³çé
ç½®ã</p>
-kylin_hive_conf.xml
-kylin_job_conf_inmem.xml
-kylin_job_conf.xml
-kylin-kafka-consumer.xml
-kylin.properties
-kylin-server-log4j.properties
-kylin-tools-log4j.properties
-setenv.sh</code></pre></div>
-
-<h2 id="kylinhiveconfxml">kylin_hive_conf.xml</h2>
-
-<p>Kylin ä» Hive ä¸åæ°æ®æ¶åºç¨ç Hive é
ç½®ã</p>
-
-<h2 id="kylinjobconfxml-and-kylinjobconfinmemxml">kylin_job_conf.xml and kylin_job_conf_inmem.xml</h2>
-
-<p>Kylin è¿è¡ MapReduce jobs æ¶ç Hadoop MR é
ç½®ãå¨ Kylin ç âIn-mem cubingâ job çæ¶åï¼âkylin_job_conf_inmem.xmlâ éè¦æ´å¤ç memory ç» mapperã</p>
-
-<h2 id="kylin-kafka-consumerxml">kylin-kafka-consumer.xml</h2>
-
-<p>Kylin ä» Kafka brokers ä¸åæ°æ®æ¶åºç¨ç Kafka é
ç½®ã</p>
-
-<h2 id="kylin-server-log4jproperties">kylin-server-log4j.properties</h2>
-
-<p>Kylin æå¡å¨çæ¥å¿é
ç½®ã</p>
-
-<h2 id="kylin-tools-log4jproperties">kylin-tools-log4j.properties</h2>
-
-<p>Kylin å½ä»¤è¡çæ¥å¿é
ç½®ã</p>
-
-<h2 id="setenvsh">setenv.sh</h2>
-
-<p>设置ç¯å¢åéç shell èæ¬ãå®å°å¨ âkylin.shâ å âbinâ æ件夹ä¸çå
¶å®èæ¬ä¸è¢«è°ç¨ãé常ï¼æ¨å¯ä»¥å¨è¿éè°æ´ Kylin JVM æ ç大å°ï¼ä¸å¯ä»¥è®¾ç½® âKAFKA_HOMEâ åå
¶ä»ç¯å¢åéã</p>
-
-<h2 id="kylinproperties">kylin.properties</h2>
-
-<p>Kylin ç主è¦é
ç½®æ件ã</p>
-
-<table>
- <thead>
- <tr>
- <th>Key</th>
- <th>Default value</th>
- <th>Description</th>
- <th>Overwritten at Cube</th>
- </tr>
- </thead>
- <tbody>
- <tr>
- <td>kylin.env</td>
- <td>Dev</td>
- <td>Whether this env is a Dev, QA, or Prod environment</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.env.hdfs-working-dir</td>
- <td>/kylin</td>
- <td>Working directory on HDFS</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.env.zookeeper-base-path</td>
- <td>/kylin</td>
- <td>Path on ZK</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.env.zookeeper-connect-string</td>
- <td>Â </td>
- <td>ZK connection string; If blank, use HBaseâs ZK</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.env.zookeeper-acl-enabled</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.env.zookeeper.zk-auth</td>
- <td>digest:ADMIN:KYLIN</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.env.zookeeper.zk-acl</td>
- <td>world:anyone:rwcda</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.metadata.dimension-encoding-max-length</td>
- <td>256</td>
- <td>Max length for one dimensionâs encoding</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.metadata.url</td>
- <td>kylin_metadata@hbase</td>
- <td>Kylin metadata storage</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.metadata.sync-retries</td>
- <td>3</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.metadata.sync-error-handler</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.metadata.check-copy-on-write</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.metadata.hbase-client-scanner-timeout-period</td>
- <td>10000</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.metadata.hbase-rpc-timeout</td>
- <td>5000</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.metadata.hbase-client-retries-number</td>
- <td>1</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.metadata.jdbc.dialect</td>
- <td>mysql</td>
- <td>clarify the type of dialect</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.metadata.resource-store-provider.jdbc</td>
- <td>org.apache.kylin.common.persistence.JDBCResourceStore</td>
- <td>specify the class that jdbc used</td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.metadata.jdbc.json-always-small-cell</td>
- <td>true</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.metadata.jdbc.small-cell-meta-size-warning-threshold</td>
- <td>100mb</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.metadata.jdbc.small-cell-meta-size-error-threshold</td>
- <td>1gb</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.metadata.jdbc.max-cell-size</td>
- <td>1mb</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.dictionary.use-forest-trie</td>
- <td>true</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.dictionary.forest-trie-max-mb</td>
- <td>500</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.dictionary.max-cache-entry</td>
- <td>3000</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.dictionary.growing-enabled</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.dictionary.append-entry-size</td>
- <td>10000000</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.dictionary.append-max-versions</td>
- <td>3</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.dictionary.append-version-ttl</td>
- <td>259200000</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.dictionary.resuable</td>
- <td>false</td>
- <td>Whether reuse dict</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.dictionary.shrunken-from-global-enabled</td>
- <td>false</td>
- <td>Whether shrink global dict</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.snapshot.max-cache-entry</td>
- <td>500</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.snapshot.max-mb</td>
- <td>300</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.snapshot.ext.shard-mb</td>
- <td>500</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.snapshot.ext.local.cache.path</td>
- <td>lookup_cache</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.snapshot.ext.local.cache.max-size-gb</td>
- <td>200</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.cube.size-estimate-ratio</td>
- <td>0.25</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.size-estimate-memhungry-ratio</td>
- <td>0.05</td>
- <td>Deprecated</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.size-estimate-countdistinct-ratio</td>
- <td>0.5</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.size-estimate-topn-ratio</td>
- <td>0.5</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.algorithm</td>
- <td>auto</td>
- <td>Cubing algorithm for MR engine, other options: layer, inmem</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.algorithm.layer-or-inmem-threshold</td>
- <td>7</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.algorithm.inmem-split-limit</td>
- <td>500</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.algorithm.inmem-concurrent-threads</td>
- <td>1</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.ignore-signature-inconsistency</td>
- <td>false</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.cube.aggrgroup.max-combination</td>
- <td>32768</td>
- <td>Max cuboid numbers in a Cube</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.aggrgroup.is-mandatory-only-valid</td>
- <td>false</td>
- <td>Whether allow a Cube only has the base cuboid.</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.cubeplanner.enabled</td>
- <td>true</td>
- <td>Whether enable cubeplanner</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.cubeplanner.enabled-for-existing-cube</td>
- <td>true</td>
- <td>Whether enable cubeplanner for existing cube</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.cubeplanner.algorithm-threshold-greedy</td>
- <td>8</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.cubeplanner.expansion-threshold</td>
- <td>15.0</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.cubeplanner.recommend-cache-max-size</td>
- <td>200</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.cube.cubeplanner.mandatory-rollup-threshold</td>
- <td>1000</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.cubeplanner.algorithm-threshold-genetic</td>
- <td>23</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.rowkey.max-size</td>
- <td>63</td>
- <td>Max columns in Rowkey</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.cube.max-building-segments</td>
- <td>10</td>
- <td>Max building segments in one Cube</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.cube.allow-appear-in-multiple-projects</td>
- <td>false</td>
- <td>Whether allow a Cueb appeared in multiple projects</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.cube.gtscanrequest-serialization-level</td>
- <td>1</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.cube.is-automerge-enabled</td>
- <td>true</td>
- <td>Whether enable auto merge.</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.job.log-dir</td>
- <td>/tmp/kylin/logs</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.job.allow-empty-segment</td>
- <td>true</td>
- <td>Whether tolerant data source is emtpy.</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.job.max-concurrent-jobs</td>
- <td>10</td>
- <td>Max concurrent running jobs</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.sampling-percentage</td>
- <td>100</td>
- <td>Data sampling percentage, to calculate Cube statistics; Default be all.</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.job.notification-enabled</td>
- <td>false</td>
- <td>Whether send email notification on job error/succeed.</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.notification-mail-enable-starttls</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.notification-mail-port</td>
- <td>25</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.notification-mail-host</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.notification-mail-username</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.notification-mail-password</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.notification-mail-sender</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.notification-admin-emails</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.retry</td>
- <td>0</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.job.scheduler.priority-considered</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.scheduler.priority-bar-fetch-from-queue</td>
- <td>20</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.scheduler.poll-interval-second</td>
- <td>30</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.error-record-threshold</td>
- <td>0</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.job.cube-auto-ready-enabled</td>
- <td>true</td>
- <td>Whether enable the cube automatically when finish build</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.source.hive.keep-flat-table</td>
- <td>false</td>
- <td>Whether keep the intermediate Hive table after job finished.</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.database-for-flat-table</td>
- <td>default</td>
- <td>Hive database to create the intermediate table.</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.flat-table-storage-format</td>
- <td>SEQUENCEFILE</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.flat-table-field-delimiter</td>
- <td>\u001F</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.redistribute-flat-table</td>
- <td>true</td>
- <td>Whether or not to redistribute the flat table.</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.source.hive.redistribute-column-count</td>
- <td>3</td>
- <td>The number of redistribute column</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.source.hive.client</td>
- <td>cli</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.beeline-shell</td>
- <td>beeline</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.beeline-params</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.enable-sparksql-for-table-ops</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.sparksql-beeline-shell</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.sparksql-beeline-params</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.table-dir-create-first</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.flat-table-cluster-by-dict-column</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.source.hive.default-varchar-precision</td>
- <td>256</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.default-char-precision</td>
- <td>255</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.default-decimal-precision</td>
- <td>19</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.hive.default-decimal-scale</td>
- <td>4</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.source.jdbc.connection-url</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.source.jdbc.driver</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.source.jdbc.dialect</td>
- <td>default</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.source.jdbc.user</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.source.jdbc.pass</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.source.jdbc.sqoop-home</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.source.jdbc.sqoop-mapper-num</td>
- <td>4</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.source.jdbc.field-delimiter</td>
- <td>|</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.default</td>
- <td>2</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.table-name-prefix</td>
- <td>KYLIN_</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.namespace</td>
- <td>default</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.cluster-fs</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.cluster-hdfs-config-file</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.coprocessor-local-jar</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.min-region-count</td>
- <td>1</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.max-region-count</td>
- <td>500</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.hfile-size-gb</td>
- <td>2.0</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.run-local-coprocessor</td>
- <td>false</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.coprocessor-mem-gb</td>
- <td>3.0</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.partition.aggr-spill-enabled</td>
- <td>true</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.partition.max-scan-bytes</td>
- <td>3221225472</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.coprocessor-timeout-seconds</td>
- <td>0</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.max-fuzzykey-scan</td>
- <td>200</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.max-fuzzykey-scan-split</td>
- <td>1</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.max-visit-scanrange</td>
- <td>1000000</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.scan-cache-rows</td>
- <td>1024</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.region-cut-gb</td>
- <td>5.0</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.max-scan-result-bytes</td>
- <td>5242880</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.compression-codec</td>
- <td>none</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.rowkey-encoding</td>
- <td>FAST_DIFF</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.block-size-bytes</td>
- <td>1048576</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.small-family-block-size-bytes</td>
- <td>65536</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.owner-tag</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.endpoint-compress-result</td>
- <td>true</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.max-hconnection-threads</td>
- <td>2048</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.core-hconnection-threads</td>
- <td>2048</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.hconnection-threads-alive-seconds</td>
- <td>60</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.storage.hbase.replication-scope</td>
- <td>0</td>
- <td>whether config hbase cluster replication</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.engine.mr.lib-dir</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.reduce-input-mb</td>
- <td>500</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.reduce-count-ratio</td>
- <td>1.0</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.min-reducer-number</td>
- <td>1</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.max-reducer-number</td>
- <td>500</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.mapper-input-rows</td>
- <td>1000000</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.max-cuboid-stats-calculator-number</td>
- <td>1</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.uhc-reducer-count</td>
- <td>1</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.build-uhc-dict-in-additional-step</td>
- <td>false</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.build-dict-in-reducer</td>
- <td>true</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.mr.yarn-check-interval-seconds</td>
- <td>10</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.env.hadoop-conf-dir</td>
- <td>Â </td>
- <td>Hadoop conf directory; If not specified, parse from environment.</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.engine.spark.rdd-partition-cut-mb</td>
- <td>10.0</td>
- <td>Spark Cubing RDD partition split size.</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.engine.spark.min-partition</td>
- <td>1</td>
- <td>Spark Cubing RDD min partition number</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.engine.spark.max-partition</td>
- <td>5000</td>
- <td>RDD max partition number</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.engine.spark.storage-level</td>
- <td>MEMORY_AND_DISK_SER</td>
- <td>RDD persistent level.</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.engine.spark-conf.spark.hadoop.dfs.replication</td>
- <td>2</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.spark-conf.spark.hadoop.mapreduce.output.fileoutputformat.compress</td>
- <td>true</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.spark-conf.spark.hadoop.mapreduce.output.fileoutputformat.compress.codec</td>
- <td>org.apache.hadoop.io.compress.DefaultCodec</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.engine.spark-conf-mergedict.spark.executor.memory</td>
- <td>6G</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.engine.spark-conf-mergedict.spark.memory.fraction</td>
- <td>0.2</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.skip-empty-segments</td>
- <td>true</td>
- <td>Whether directly skip empty segment (metadata shows size be 0) when run SQL query.</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.force-limit</td>
- <td>-1</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.max-scan-bytes</td>
- <td>0</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.max-return-rows</td>
- <td>5000000</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.large-query-threshold</td>
- <td>1000000</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.cache-threshold-duration</td>
- <td>2000</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.cache-threshold-scan-count</td>
- <td>10240</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.cache-threshold-scan-bytes</td>
- <td>1048576</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.security-enabled</td>
- <td>true</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.cache-enabled</td>
- <td>true</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.timeout-seconds</td>
- <td>0</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.timeout-seconds-coefficient</td>
- <td>0.5</td>
- <td>the coefficient to controll query timeout seconds</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.runner-class-name</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.update-enabled</td>
- <td>false</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.cache-enabled</td>
- <td>false</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.jdbc.url</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.jdbc.driver</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.jdbc.username</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.jdbc.password</td>
- <td>Â </td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.jdbc.pool-max-total</td>
- <td>8</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.jdbc.pool-max-idle</td>
- <td>8</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.pushdown.jdbc.pool-min-idle</td>
- <td>0</td>
- <td>Â </td>
- <td>Â </td>
- </tr>
- <tr>
- <td>kylin.query.security.table-acl-enabled</td>
- <td>true</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.query.calcite.extras-props.conformance</td>
- <td>LENIENT</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.calcite.extras-props.caseSensitive</td>
- <td>true</td>
- <td>Whether enable case sensitive</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.calcite.extras-props.unquotedCasing</td>
- <td>TO_UPPER</td>
- <td>Options: UNCHANGED, TO_UPPER, TO_LOWER</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.calcite.extras-props.quoting</td>
- <td>DOUBLE_QUOTE</td>
- <td>Options: DOUBLE_QUOTE, BACK_TICK, BRACKET</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.statement-cache-max-num</td>
- <td>50000</td>
- <td>Max number for cache query statement</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.statement-cache-max-num-per-key</td>
- <td>50</td>
- <td>Â </td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.enable-dict-enumerator</td>
- <td>false</td>
- <td>Whether enable dict enumerator</td>
- <td>Yes</td>
- </tr>
- <tr>
- <td>kylin.query.enable-dynamic-column</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.server.mode</td>
- <td>all</td>
- <td>Kylin node mode: all|job|query.</td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.server.cluster-servers</td>
- <td>localhost:7070</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.server.cluster-name</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.server.query-metrics-enabled</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.server.query-metrics2-enabled</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.server.auth-user-cache.expire-seconds</td>
- <td>300</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.server.auth-user-cache.max-entries</td>
- <td>100</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.server.external-acl-provider</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.security.ldap.user-search-base</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.security.ldap.user-group-search-base</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.security.acl.admin-role</td>
- <td>Â </td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.web.timezone</td>
- <td>PST</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.web.cross-domain-enabled</td>
- <td>true</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.web.export-allow-admin</td>
- <td>true</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.web.export-allow-other</td>
- <td>true</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- <tr>
- <td>kylin.web.dashboard-enabled</td>
- <td>false</td>
- <td>Â </td>
- <td>No</td>
- </tr>
- </tbody>
-</table>
+<h3 id="query-config">æ¥è¯¢ç¸å
³</h3>
+<ul>
+ <li><code class="highlighter-rouge">kylin.query.skip-empty-segments</code>ï¼æ¥è¯¢æ¯å¦è·³è¿æ°æ®é为 0 ç segmentï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.query.large-query-threshold</code>ï¼æå®æ大è¿åè¡æ°ï¼é»è®¤å¼ä¸º 1000000</li>
+ <li><code class="highlighter-rouge">kylin.query.security-enabled</code>ï¼æ¯å¦å¨æ¥è¯¢æ¶æ£æ¥ ACLï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.query.security.table-acl-enabled</code>ï¼æ¯å¦å¨æ¥è¯¢æ¶æ£æ¥å¯¹åºè¡¨ç ACLï¼é»è®¤å¼ä¸º TRUE</li>
+ <li><code class="highlighter-rouge">kylin.query.calcite.extras-props.conformance</code>ï¼æ¯å¦ä¸¥æ ¼è§£æï¼é»è®¤å¼ä¸º LENIENT</li>
+ <li><code class="highlighter-rouge">kylin.query.calcite.extras-props.caseSensitive</code>ï¼æ¯å¦å¤§å°åææï¼é»è®¤å¼ä¸º TRUE</li>
+ <li>
+ <table>
+ <tbody>
+ <tr>
[... 509 lines stripped ...]