Author: lidong Date: Fri Aug 10 14:09:45 2018 New Revision: 1837805 URL: http://svn.apache.org/viewvc?rev=1837805&view=rev Log: update superset tutorial
Modified: kylin/site/cn/docs/tutorial/cube_spark.html kylin/site/cn/docs/tutorial/cube_streaming.html kylin/site/cn/docs/tutorial/superset.html kylin/site/cn/docs23/tutorial/cube_spark.html kylin/site/cn/docs23/tutorial/cube_streaming.html kylin/site/docs/tutorial/cube_streaming.html kylin/site/docs/tutorial/superset.html kylin/site/docs16/tutorial/cube_streaming.html kylin/site/docs20/tutorial/cube_streaming.html kylin/site/docs21/tutorial/cube_streaming.html kylin/site/docs23/tutorial/cube_streaming.html kylin/site/feed.xml Modified: kylin/site/cn/docs/tutorial/cube_spark.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/cube_spark.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/cube_spark.html (original) +++ kylin/site/cn/docs/tutorial/cube_spark.html Fri Aug 10 14:09:45 2018 @@ -276,7 +276,7 @@ $KYLIN_HOME/bin/kylin.sh start</code></p <p>å½åºç° errorï¼æ¨å¯ä»¥é¦å æ¥ç âlogs/kylin.logâ. å ¶ä¸å å« Kylin æ§è¡çææ Spark å½ä»¤ï¼ä¾å¦:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">2017-03-06 14:44:38,574 INFO [Job 2d5c1178-c6f6-4b50-8937-8e5e3b39227e-306] spark.SparkExecutable:121 : cmd:export HADOOP_CONF_DIR=/usr/local/apache-kylin-2.1.0-bin-hbase1x/hadoop-conf && /usr/local/apache-kylin-2.1.0-bin-hbase1x/spark/bin/spark-submit --class org.apache.kylin.common.util.SparkEntry --conf spark.executor.instances=1 --conf spark.yarn.queue=default --conf spark.yarn.am.extraJavaOptions=-Dhdp.version=current --conf spark.history.fs.logDirectory=hdfs:///kylin/spark-history --conf spark.driver.extraJavaOptions=-Dhdp.version=current --conf spark.master=yarn --conf spark.executor.extraJavaOptions=-Dhdp.version=current --conf spark.executor.memory=1G --conf spark.eventLog.enabled=true --conf spark.eventLog.dir=hdfs:///kylin/spark-history --conf spark.executor.cores=2 --conf spark.submit.deployMode=cluster --files /etc/hbase/2.4.0.0-169/0/hbase-site.xml --jars /usr/hdp/2.4.0.0-16 9/hbase/lib/htrace-core-3.1.0-incubating.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-client-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-common-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-protocol-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/metrics-core-2.2.0.jar,/usr/hdp/2.4.0.0-169/hbase/lib/guava-12.0.1.jarï¼/usr/local/apache-kylin-2.1.0-bin-hbase1x/lib/kylin-job-2.1.0.jar -className org.apache.kylin.engine.spark.SparkCubingByLayer -hiveTable kylin_intermediate_kylin_sales_cube_555c4d32_40bb_457d_909a_1bb017bf2d9e -segmentId 555c4d32-40bb-457d-909a-1bb017bf2d9e -confPath /usr/local/apache-kylin-2.1.0-bin-hbase1x/conf -output hdfs:///kylin/kylin_metadata/kylin-2d5c1178-c6f6-4b50-8937-8e5e3b39227e/kylin_sales_cube/cuboid/ -cubename kylin_sales_cube</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">2017-03-06 14:44:38,574 INFO [Job 2d5c1178-c6f6-4b50-8937-8e5e3b39227e-306] spark.SparkExecutable:121 : cmd:export HADOOP_CONF_DIR=/usr/local/apache-kylin-2.1.0-bin-hbase1x/hadoop-conf && /usr/local/apache-kylin-2.1.0-bin-hbase1x/spark/bin/spark-submit --class org.apache.kylin.common.util.SparkEntry --conf spark.executor.instances=1 --conf spark.yarn.queue=default --conf spark.yarn.am.extraJavaOptions=-Dhdp.version=current --conf spark.history.fs.logDirectory=hdfs:///kylin/spark-history --conf spark.driver.extraJavaOptions=-Dhdp.version=current --conf spark.master=yarn --conf spark.executor.extraJavaOptions=-Dhdp.version=current --conf spark.executor.memory=1G --conf spark.eventLog.enabled=true --conf spark.eventLog.dir=hdfs:///kylin/spark-history --conf spark.executor.cores=2 --conf spark.submit.deployMode=cluster --files /etc/hbase/2.4.0.0-169/0/hbase-site.xml --jars /usr/hdp/2.4.0.0-16 9/hbase/lib/htrace-core-3.1.0-incubating.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-client-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-common-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-protocol-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/metrics-core-2.2.0.jar,/usr/hdp/2.4.0.0-169/hbase/lib/guava-12.0.1.jar,/usr/local/apache-kylin-2.1.0-bin-hbase1x/lib/kylin-job-2.1.0.jar -className org.apache.kylin.engine.spark.SparkCubingByLayer -hiveTable kylin_intermediate_kylin_sales_cube_555c4d32_40bb_457d_909a_1bb017bf2d9e -segmentId 555c4d32-40bb-457d-909a-1bb017bf2d9e -confPath /usr/local/apache-kylin-2.1.0-bin-hbase1x/conf -output hdfs:///kylin/kylin_metadata/kylin-2d5c1178-c6f6-4b50-8937-8e5e3b39227e/kylin_sales_cube/cuboid/ -cubename kylin_sales_cube</code></pre></div> <p>æ¨å¯ä»¥æ·è´ cmd ä»¥ä¾¿å¨ shell ä¸æå¨æ§è¡ï¼ç¶åå¿«éè¿è¡åæ°è°æ´ï¼æ§è¡æé´ï¼æ¨å¯ä»¥è®¿é® Yarn èµæºç®¡çå¨æ¥çæ´å¤çæ¶æ¯ãå¦æ job å·²ç»å®æäºï¼æ¨å¯ä»¥å¨ Spark history server ä¸æ¥çåå²ä¿¡æ¯ã</p> Modified: kylin/site/cn/docs/tutorial/cube_streaming.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/cube_streaming.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/cube_streaming.html (original) +++ kylin/site/cn/docs/tutorial/cube_streaming.html Fri Aug 10 14:09:45 2018 @@ -176,7 +176,7 @@ var _hmt = _hmt || []; <h2 id="kafka-01000--kylin">å®è£ Kafka 0.10.0.0 å Kylin</h2> <p>ä¸è¦ä½¿ç¨ HDP 2.2.4 èªå¸¦ç Kafkaï¼å 为å®å¤ªæ§äºï¼å¦æå ¶è¿è¡ç请å åæã</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s http://mirrors.tuna.tsinghua.edu.cn/apache/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s https://archive.apache.org/dist/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ cd /usr/local/kafka_2.10-0.10.0.0/ @@ -282,7 +282,7 @@ bin/kafka-console-consumer.sh --bootstra <p>æ¨å¯ä»¥å¨ web GUI 触å buildï¼éè¿ç¹å» âActionsâ -> âBuildâï¼æç¨ âcurlâ å½ä»¤åéä¸ä¸ªè¯·æ±å° Kylin RESTful API:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0ï¼"sourceOffsetEnd": 9223372036854775807ï¼"buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/build2</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0, "sourceOffsetEnd": 9223372036854775807, "buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/build2</code></pre></div> <p>请注æ API ç»ç«¯åæ®é cube ä¸ä¸æ · (è¿ä¸ª URL 以 âbuild2â ç»å°¾)ã</p> @@ -292,7 +292,7 @@ bin/kafka-console-consumer.sh --bootstra <h2 id="insight--sql-">ç¹å» âInsightâ æ ç¾ï¼ç¼å SQL è¿è¡ï¼ä¾å¦:</h2> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">select minute_startï¼count(*)ï¼sum(amount)ï¼sum(qty) from streaming_sales_table group by minute_start order by minute_start</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">select minute_start, count(*), sum(amount), sum(qty) from streaming_sales_table group by minute_start order by minute_start</code></pre></div> <p>ç»æå¦ä¸ã<br /> <img src="/images/tutorial/1.6/Kylin-Cube-Streaming-Tutorial/13_Query_result.png" alt="" /></p> @@ -302,7 +302,7 @@ bin/kafka-console-consumer.sh --bootstra <p>ä¸æ¦ç¬¬ä¸ä¸ª build åæ¥è¯¢æåäºï¼æ¨å¯ä»¥æç §ä¸å®çé¢çè°åº¦å¢é buildãKylin å°ä¼è®°å½æ¯ä¸ä¸ª build ç offsetsï¼å½æ¶å°ä¸ä¸ª build 请æ±ï¼å®å°ä¼ä»ä¸ä¸ä¸ªç»æçä½ç½®å¼å§ï¼ç¶åä» Kafka è·åææ°ç offsetsãæäº REST API æ¨å¯ä»¥ä½¿ç¨ä»»ä½å Linux cron è°åº¦å·¥å ·è§¦åå®:</p> <div class="highlight"><pre><code class="language-groff" data-lang="groff">crontab -e -*/5 * * * * curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0ï¼"sourceOffsetEnd": 9223372036854775807ï¼"buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/build2</code></pre></div> +*/5 * * * * curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0, "sourceOffsetEnd": 9223372036854775807, "buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/build2</code></pre></div> <p>ç°å¨æ¨å¯ä»¥è§ç cube ä» streaming ä¸èªå¨ builtãå½ cube segments 累积å°æ´å¤§çæ¶é´èå´ï¼Kylin å°ä¼èªå¨çå°å ¶å并å°ä¸ä¸ªæ´å¤§ç segment ä¸ã</p> @@ -353,7 +353,7 @@ Caused by: java.lang.ClassNotFoundExcept <li>å¦æ Kafka éå·²ç»æä¸ç»åå² message ä¸æ¨ä¸æ³ä»æå¼å§ buildï¼æ¨å¯ä»¥è§¦åä¸ä¸ªè°ç¨æ¥å°å½åçç»æä½ç½®è®¾ä¸º cube çå¼å§:</li> </ul> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0ï¼"sourceOffsetEnd": 9223372036854775807ï¼"buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/init_start_offsets</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0, "sourceOffsetEnd": 9223372036854775807, "buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/init_start_offsets</code></pre></div> <ul> <li>å¦æä¸äº build job åºéäºå¹¶ä¸æ¨å°å ¶ discardï¼Cube ä¸å°±ä¼çæä¸ä¸ªæ´ï¼æ称为空éï¼ãæ¯ä¸æ¬¡ Kylin é½ä¼ä»æåçä½ç½® buildï¼æ¨ä¸å¯ææéè¿æ£å¸¸ç builds å°æ´å¡«è¡¥ãKylin æä¾äº API æ£æ¥åå¡«è¡¥æ´</li> @@ -361,11 +361,11 @@ Caused by: java.lang.ClassNotFoundExcept <p>æ£æ¥æ´:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> <p>å¦ææ¥è¯¢ç»ææ¯ä¸ä¸ªç©ºçæ°ç»ï¼æå³ç没ææ´ï¼å¦åï¼è§¦å Kylin å¡«è¡¥ä»ä»¬:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> </article> Modified: kylin/site/cn/docs/tutorial/superset.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs/tutorial/superset.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/cn/docs/tutorial/superset.html (original) +++ kylin/site/cn/docs/tutorial/superset.html Fri Aug 10 14:09:45 2018 @@ -200,18 +200,6 @@ var _hmt = _hmt || []; <h5 id="section-3">å ¶å®åè½</h5> <p>Apache Superset ä¹æ¯æå¯¼åº CSV, å ±äº«, 以åæ¥ç SQL æ¥è¯¢ã</p> -<h3 id="kyligence-insight-for-superset">Kyligence Insight for Superset</h3> -<p>å®å¶çç Supersetï¼Kyligence Insight for Supersetï¼ä½¿å¾ Kylin çç¨æ·å¤äºä¸ç§éæ©ãå ·ä½çå®è£ æ¥éª¤è¯·å¨ github ä¸æ¥ç <a href="https://github.com/Kyligence/Insight-for-Superset">è¿ä¸ªé¡¹ç®</a>ã</p> - -<h5 id="superset-">ç¸æ¯åç Superset, æä¾äºå¦ä¸å¢å¼ºåè½ï¼</h5> -<ol> - <li>ç»ä¸ç¨æ·ç®¡çï¼ç¨æ·æ éå¨ âSupersetâ ä¸é¢å¤å建ç¨æ·åèµäºæéï¼ç»ä¸å¨ Kylin å端管çç¨æ·è®¿é®æéï¼ç´æ¥ä½¿ç¨ Kylin è´¦æ·ç»å½ Supersetã</li> - <li>ä¸é®åæ¥ Kylin Cubeï¼æ éå¨ Superset 端éæ°å®ä¹æ°æ®æ¨¡åï¼ç´æ¥æ¥è¯¢ Cube.</li> - <li>æ¯æå¤è¡¨è¿æ¥æ¨¡åï¼æ¯æ inner join å outer join.</li> - <li>Docker 容å¨åé¨ç½² Supersetï¼ä¸é®å¯å¨ï¼éä½é¨ç½²åå级é¨æ§ã</li> - <li>èªå¨éé Kylin æ¥è¯¢è¯æ³ã</li> -</ol> - </article> </div> </div> Modified: kylin/site/cn/docs23/tutorial/cube_spark.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/cube_spark.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/cn/docs23/tutorial/cube_spark.html (original) +++ kylin/site/cn/docs23/tutorial/cube_spark.html Fri Aug 10 14:09:45 2018 @@ -276,7 +276,7 @@ $KYLIN_HOME/bin/kylin.sh start</code></p <p>å½åºç° errorï¼æ¨å¯ä»¥é¦å æ¥ç âlogs/kylin.logâ. å ¶ä¸å å« Kylin æ§è¡çææ Spark å½ä»¤ï¼ä¾å¦:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">2017-03-06 14:44:38,574 INFO [Job 2d5c1178-c6f6-4b50-8937-8e5e3b39227e-306] spark.SparkExecutable:121 : cmd:export HADOOP_CONF_DIR=/usr/local/apache-kylin-2.1.0-bin-hbase1x/hadoop-conf && /usr/local/apache-kylin-2.1.0-bin-hbase1x/spark/bin/spark-submit --class org.apache.kylin.common.util.SparkEntry --conf spark.executor.instances=1 --conf spark.yarn.queue=default --conf spark.yarn.am.extraJavaOptions=-Dhdp.version=current --conf spark.history.fs.logDirectory=hdfs:///kylin/spark-history --conf spark.driver.extraJavaOptions=-Dhdp.version=current --conf spark.master=yarn --conf spark.executor.extraJavaOptions=-Dhdp.version=current --conf spark.executor.memory=1G --conf spark.eventLog.enabled=true --conf spark.eventLog.dir=hdfs:///kylin/spark-history --conf spark.executor.cores=2 --conf spark.submit.deployMode=cluster --files /etc/hbase/2.4.0.0-169/0/hbase-site.xml --jars /usr/hdp/2.4.0.0-16 9/hbase/lib/htrace-core-3.1.0-incubating.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-client-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-common-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-protocol-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/metrics-core-2.2.0.jar,/usr/hdp/2.4.0.0-169/hbase/lib/guava-12.0.1.jarï¼/usr/local/apache-kylin-2.1.0-bin-hbase1x/lib/kylin-job-2.1.0.jar -className org.apache.kylin.engine.spark.SparkCubingByLayer -hiveTable kylin_intermediate_kylin_sales_cube_555c4d32_40bb_457d_909a_1bb017bf2d9e -segmentId 555c4d32-40bb-457d-909a-1bb017bf2d9e -confPath /usr/local/apache-kylin-2.1.0-bin-hbase1x/conf -output hdfs:///kylin/kylin_metadata/kylin-2d5c1178-c6f6-4b50-8937-8e5e3b39227e/kylin_sales_cube/cuboid/ -cubename kylin_sales_cube</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">2017-03-06 14:44:38,574 INFO [Job 2d5c1178-c6f6-4b50-8937-8e5e3b39227e-306] spark.SparkExecutable:121 : cmd:export HADOOP_CONF_DIR=/usr/local/apache-kylin-2.1.0-bin-hbase1x/hadoop-conf && /usr/local/apache-kylin-2.1.0-bin-hbase1x/spark/bin/spark-submit --class org.apache.kylin.common.util.SparkEntry --conf spark.executor.instances=1 --conf spark.yarn.queue=default --conf spark.yarn.am.extraJavaOptions=-Dhdp.version=current --conf spark.history.fs.logDirectory=hdfs:///kylin/spark-history --conf spark.driver.extraJavaOptions=-Dhdp.version=current --conf spark.master=yarn --conf spark.executor.extraJavaOptions=-Dhdp.version=current --conf spark.executor.memory=1G --conf spark.eventLog.enabled=true --conf spark.eventLog.dir=hdfs:///kylin/spark-history --conf spark.executor.cores=2 --conf spark.submit.deployMode=cluster --files /etc/hbase/2.4.0.0-169/0/hbase-site.xml --jars /usr/hdp/2.4.0.0-16 9/hbase/lib/htrace-core-3.1.0-incubating.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-client-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-common-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/hbase-protocol-1.1.2.2.4.0.0-169.jar,/usr/hdp/2.4.0.0-169/hbase/lib/metrics-core-2.2.0.jar,/usr/hdp/2.4.0.0-169/hbase/lib/guava-12.0.1.jar,/usr/local/apache-kylin-2.1.0-bin-hbase1x/lib/kylin-job-2.1.0.jar -className org.apache.kylin.engine.spark.SparkCubingByLayer -hiveTable kylin_intermediate_kylin_sales_cube_555c4d32_40bb_457d_909a_1bb017bf2d9e -segmentId 555c4d32-40bb-457d-909a-1bb017bf2d9e -confPath /usr/local/apache-kylin-2.1.0-bin-hbase1x/conf -output hdfs:///kylin/kylin_metadata/kylin-2d5c1178-c6f6-4b50-8937-8e5e3b39227e/kylin_sales_cube/cuboid/ -cubename kylin_sales_cube</code></pre></div> <p>æ¨å¯ä»¥æ·è´ cmd ä»¥ä¾¿å¨ shell ä¸æå¨æ§è¡ï¼ç¶åå¿«éè¿è¡åæ°è°æ´ï¼æ§è¡æé´ï¼æ¨å¯ä»¥è®¿é® Yarn èµæºç®¡çå¨æ¥çæ´å¤çæ¶æ¯ãå¦æ job å·²ç»å®æäºï¼æ¨å¯ä»¥å¨ Spark history server ä¸æ¥çåå²ä¿¡æ¯ã</p> Modified: kylin/site/cn/docs23/tutorial/cube_streaming.html URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/tutorial/cube_streaming.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/cn/docs23/tutorial/cube_streaming.html (original) +++ kylin/site/cn/docs23/tutorial/cube_streaming.html Fri Aug 10 14:09:45 2018 @@ -176,7 +176,7 @@ var _hmt = _hmt || []; <h2 id="kafka-01000--kylin">å®è£ Kafka 0.10.0.0 å Kylin</h2> <p>ä¸è¦ä½¿ç¨ HDP 2.2.4 èªå¸¦ç Kafkaï¼å 为å®å¤ªæ§äºï¼å¦æå ¶è¿è¡ç请å åæã</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s http://mirrors.tuna.tsinghua.edu.cn/apache/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s https://archive.apache.org/dist/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ cd /usr/local/kafka_2.10-0.10.0.0/ @@ -282,7 +282,7 @@ bin/kafka-console-consumer.sh --bootstra <p>æ¨å¯ä»¥å¨ web GUI 触å buildï¼éè¿ç¹å» âActionsâ -> âBuildâï¼æç¨ âcurlâ å½ä»¤åéä¸ä¸ªè¯·æ±å° Kylin RESTful API:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0ï¼"sourceOffsetEnd": 9223372036854775807ï¼"buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/build2</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0, "sourceOffsetEnd": 9223372036854775807, "buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/build2</code></pre></div> <p>请注æ API ç»ç«¯åæ®é cube ä¸ä¸æ · (è¿ä¸ª URL 以 âbuild2â ç»å°¾)ã</p> @@ -292,7 +292,7 @@ bin/kafka-console-consumer.sh --bootstra <h2 id="insight--sql-">ç¹å» âInsightâ æ ç¾ï¼ç¼å SQL è¿è¡ï¼ä¾å¦:</h2> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">select minute_startï¼count(*)ï¼sum(amount)ï¼sum(qty) from streaming_sales_table group by minute_start order by minute_start</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">select minute_start, count(*), sum(amount), sum(qty) from streaming_sales_table group by minute_start order by minute_start</code></pre></div> <p>ç»æå¦ä¸ã<br /> <img src="/images/tutorial/1.6/Kylin-Cube-Streaming-Tutorial/13_Query_result.png" alt="" /></p> @@ -302,7 +302,7 @@ bin/kafka-console-consumer.sh --bootstra <p>ä¸æ¦ç¬¬ä¸ä¸ª build åæ¥è¯¢æåäºï¼æ¨å¯ä»¥æç §ä¸å®çé¢çè°åº¦å¢é buildãKylin å°ä¼è®°å½æ¯ä¸ä¸ª build ç offsetsï¼å½æ¶å°ä¸ä¸ª build 请æ±ï¼å®å°ä¼ä»ä¸ä¸ä¸ªç»æçä½ç½®å¼å§ï¼ç¶åä» Kafka è·åææ°ç offsetsãæäº REST API æ¨å¯ä»¥ä½¿ç¨ä»»ä½å Linux cron è°åº¦å·¥å ·è§¦åå®:</p> <div class="highlight"><pre><code class="language-groff" data-lang="groff">crontab -e -*/5 * * * * curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0ï¼"sourceOffsetEnd": 9223372036854775807ï¼"buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/build2</code></pre></div> +*/5 * * * * curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0, "sourceOffsetEnd": 9223372036854775807, "buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/build2</code></pre></div> <p>ç°å¨æ¨å¯ä»¥è§ç cube ä» streaming ä¸èªå¨ builtãå½ cube segments 累积å°æ´å¤§çæ¶é´èå´ï¼Kylin å°ä¼èªå¨çå°å ¶å并å°ä¸ä¸ªæ´å¤§ç segment ä¸ã</p> @@ -353,7 +353,7 @@ Caused by: java.lang.ClassNotFoundExcept <li>å¦æ Kafka éå·²ç»æä¸ç»åå² message ä¸æ¨ä¸æ³ä»æå¼å§ buildï¼æ¨å¯ä»¥è§¦åä¸ä¸ªè°ç¨æ¥å°å½åçç»æä½ç½®è®¾ä¸º cube çå¼å§:</li> </ul> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0ï¼"sourceOffsetEnd": 9223372036854775807ï¼"buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/init_start_offsets</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" -d '{ "sourceOffsetStart": 0, "sourceOffsetEnd": 9223372036854775807, "buildType": "BUILD"}' http://localhost:7070/kylin/api/cubes/{your_cube_name}/init_start_offsets</code></pre></div> <ul> <li>å¦æä¸äº build job åºéäºå¹¶ä¸æ¨å°å ¶ discardï¼Cube ä¸å°±ä¼çæä¸ä¸ªæ´ï¼æ称为空éï¼ãæ¯ä¸æ¬¡ Kylin é½ä¼ä»æåçä½ç½® buildï¼æ¨ä¸å¯ææéè¿æ£å¸¸ç builds å°æ´å¡«è¡¥ãKylin æä¾äº API æ£æ¥åå¡«è¡¥æ´</li> @@ -361,11 +361,11 @@ Caused by: java.lang.ClassNotFoundExcept <p>æ£æ¥æ´:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> <p>å¦ææ¥è¯¢ç»ææ¯ä¸ä¸ªç©ºçæ°ç»ï¼æå³ç没ææ´ï¼å¦åï¼è§¦å Kylin å¡«è¡¥ä»ä»¬:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> </article> Modified: kylin/site/docs/tutorial/cube_streaming.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/cube_streaming.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/docs/tutorial/cube_streaming.html (original) +++ kylin/site/docs/tutorial/cube_streaming.html Fri Aug 10 14:09:45 2018 @@ -5611,7 +5611,7 @@ var _hmt = _hmt || []; <h2 id="install-kafka-01000-and-kylin">Install Kafka 0.10.0.0 and Kylin</h2> <p>Donât use HDP 2.2.4âs build-in Kafka as it is too old, stop it first if it is running.</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s http://mirrors.tuna.tsinghua.edu.cn/apache/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s https://archive.apache.org/dist/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ cd /usr/local/kafka_2.10-0.10.0.0/ @@ -5796,11 +5796,11 @@ Caused by: java.lang.ClassNotFoundExcept <p>Check holes:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> <p>If the result is an empty arrary, means there is no hole; Otherwise, trigger Kylin to fill them:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> </article> Modified: kylin/site/docs/tutorial/superset.html URL: http://svn.apache.org/viewvc/kylin/site/docs/tutorial/superset.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/docs/tutorial/superset.html (original) +++ kylin/site/docs/tutorial/superset.html Fri Aug 10 14:09:45 2018 @@ -5635,17 +5635,6 @@ var _hmt = _hmt || []; <h5 id="other-functionalities">Other functionalities</h5> <p>Apache Superset also supports exporting to CSV, sharing, and viewing SQL query.</p> -<h3 id="kyligence-insight-for-superset">Kyligence Insight for Superset</h3> -<p>A customized version of Superset: Kyligence Insight for Superset gives Kylin users a choice. Please check <a href="https://github.com/Kyligence/Insight-for-Superset">this project</a> on github for specific installation steps.</p> - -<h5 id="compared-to-the-native-superset-it-offers-the-following-enhancements">Compared to the native Superset, it offers the following enhancements:</h5> -<ol> - <li>Unified user management, users do not need to create additional users and permissions on âSupersetâ, manage user access rights on the Kylin backend, and log in to Superset directly using Kylin account.</li> - <li>One-click synchronization Kylin Cube, no need to redefine the data model on the Superset side, directly query Cube.</li> - <li>Support multi-table join model, support inner join and outer join.</li> - <li>Docker containerized deployment Superset, one-click startup, reducing deployment and upgrade thresholds.</li> - <li>Automatically adapt Kylin query syntax.</li> -</ol> </article> </div> Modified: kylin/site/docs16/tutorial/cube_streaming.html URL: http://svn.apache.org/viewvc/kylin/site/docs16/tutorial/cube_streaming.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/docs16/tutorial/cube_streaming.html (original) +++ kylin/site/docs16/tutorial/cube_streaming.html Fri Aug 10 14:09:45 2018 @@ -7807,7 +7807,7 @@ var _hmt = _hmt || []; <h2 id="install-kafka-01000-and-kylin">Install Kafka 0.10.0.0 and Kylin</h2> <p>Donât use HDP 2.2.4âs build-in Kafka as it is too old, stop it first if it is running.</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s http://mirrors.tuna.tsinghua.edu.cn/apache/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s https://archive.apache.org/dist/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ cd /usr/local/kafka_2.10-0.10.0.0/ @@ -7992,11 +7992,11 @@ Caused by: java.lang.ClassNotFoundExcept <p>Check holes:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> <p>If the result is an empty arrary, means there is no hole; Otherwise, trigger Kylin to fill them:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> </article> Modified: kylin/site/docs20/tutorial/cube_streaming.html URL: http://svn.apache.org/viewvc/kylin/site/docs20/tutorial/cube_streaming.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/docs20/tutorial/cube_streaming.html (original) +++ kylin/site/docs20/tutorial/cube_streaming.html Fri Aug 10 14:09:45 2018 @@ -8121,7 +8121,7 @@ var _hmt = _hmt || []; <h2 id="install-kafka-01000-and-kylin">Install Kafka 0.10.0.0 and Kylin</h2> <p>Donât use HDP 2.2.4âs build-in Kafka as it is too old, stop it first if it is running.</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s http://mirrors.tuna.tsinghua.edu.cn/apache/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s https://archive.apache.org/dist/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ cd /usr/local/kafka_2.10-0.10.0.0/ @@ -8306,11 +8306,11 @@ Caused by: java.lang.ClassNotFoundExcept <p>Check holes:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> <p>If the result is an empty arrary, means there is no hole; Otherwise, trigger Kylin to fill them:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> </article> Modified: kylin/site/docs21/tutorial/cube_streaming.html URL: http://svn.apache.org/viewvc/kylin/site/docs21/tutorial/cube_streaming.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/docs21/tutorial/cube_streaming.html (original) +++ kylin/site/docs21/tutorial/cube_streaming.html Fri Aug 10 14:09:45 2018 @@ -9475,7 +9475,7 @@ var _hmt = _hmt || []; <h2 id="install-kafka-01000-and-kylin">Install Kafka 0.10.0.0 and Kylin</h2> <p>Donât use HDP 2.2.4âs build-in Kafka as it is too old, stop it first if it is running.</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s http://mirrors.tuna.tsinghua.edu.cn/apache/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s https://archive.apache.org/dist/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ cd /usr/local/kafka_2.10-0.10.0.0/ @@ -9660,11 +9660,11 @@ Caused by: java.lang.ClassNotFoundExcept <p>Check holes:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> <p>If the result is an empty arrary, means there is no hole; Otherwise, trigger Kylin to fill them:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> </article> Modified: kylin/site/docs23/tutorial/cube_streaming.html URL: http://svn.apache.org/viewvc/kylin/site/docs23/tutorial/cube_streaming.html?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/docs23/tutorial/cube_streaming.html (original) +++ kylin/site/docs23/tutorial/cube_streaming.html Fri Aug 10 14:09:45 2018 @@ -5612,7 +5612,7 @@ var _hmt = _hmt || []; <h2 id="install-kafka-01000-and-kylin">Install Kafka 0.10.0.0 and Kylin</h2> <p>Donât use HDP 2.2.4âs build-in Kafka as it is too old, stop it first if it is running.</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s http://mirrors.tuna.tsinghua.edu.cn/apache/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -s https://archive.apache.org/dist/kafka/0.10.0.0/kafka_2.10-0.10.0.0.tgz | tar -xz -C /usr/local/ cd /usr/local/kafka_2.10-0.10.0.0/ @@ -5797,11 +5797,11 @@ Caused by: java.lang.ClassNotFoundExcept <p>Check holes:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X GET --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> <p>If the result is an empty arrary, means there is no hole; Otherwise, trigger Kylin to fill them:</p> -<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMINN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> +<div class="highlight"><pre><code class="language-groff" data-lang="groff">curl -X PUT --user ADMIN:KYLIN -H "Content-Type: application/json;charset=utf-8" http://localhost:7070/kylin/api/cubes/{your_cube_name}/holes</code></pre></div> </article> Modified: kylin/site/feed.xml URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1837805&r1=1837804&r2=1837805&view=diff ============================================================================== --- kylin/site/feed.xml (original) +++ kylin/site/feed.xml Fri Aug 10 14:09:45 2018 @@ -19,8 +19,8 @@ <description>Apache Kylin Home</description> <link>http://kylin.apache.org/</link> <atom:link href="http://kylin.apache.org/feed.xml" rel="self" type="application/rss+xml"/> - <pubDate>Tue, 07 Aug 2018 06:59:26 -0700</pubDate> - <lastBuildDate>Tue, 07 Aug 2018 06:59:26 -0700</lastBuildDate> + <pubDate>Fri, 10 Aug 2018 06:59:23 -0700</pubDate> + <lastBuildDate>Fri, 10 Aug 2018 06:59:23 -0700</lastBuildDate> <generator>Jekyll v2.5.3</generator> <item>