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/07/02 06:08:51 UTC
svn commit: r1834820 [3/48] - 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/docs23/howto/howto_backup_metadata.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/howto/howto_backup_metadata.html?rev=1834820&r1=1834819&r2=1834820&view=diff
==============================================================================
--- kylin/site/cn/docs23/howto/howto_backup_metadata.html (original)
+++ kylin/site/cn/docs23/howto/howto_backup_metadata.html Mon Jul 2 06:08:48 2018
@@ -160,7 +160,61 @@ var _hmt = _hmt || [];
<div class="container">
- <div class="row">
+ <div class="row" style="clear:both;">
+ <div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2" style="float:right;">
+ <div id="container" class="docs">
+ <div id="pjax">
+ <h1 class="post-title">å¤ä»½å
æ°æ®</h1>
+ <article class="post-content" >
+ <p>Kylinå°å®å
¨é¨çå
æ°æ®ï¼å
æ¬cubeæè¿°åå®ä¾ã项ç®ãåæç´¢å¼æè¿°åå®ä¾ãä»»å¡ã表ååå
¸ï¼ç»ç»æå±çº§æ件系ç»çå½¢å¼ãç¶èï¼Kylin使ç¨hbaseæ¥åå¨å
æ°æ®ï¼èä¸æ¯ä¸ä¸ªæ®éçæ件系ç»ãå¦æä½ æ¥çè¿Kylinçé
ç½®æ件ï¼kylin.propertiesï¼ï¼ä½ ä¼åç°è¿æ ·ä¸è¡ï¼</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">## The metadata store in hbase
+kylin.metadata.url=kylin_metadata@hbase</code></pre></div>
+
+<p>è¿è¡¨æå
æ°æ®ä¼è¢«ä¿åå¨ä¸ä¸ªå«ä½âkylin_metadataâçhtableéãä½ å¯ä»¥å¨hbase shelléscan该htbaleæ¥è·åå®ã</p>
+
+<h2 id="metadata-store">使ç¨äºè¿å¶å
æ¥å¤ä»½Metadata Store</h2>
+
+<p>ææ¶ä½ éè¦å°KylinçMetadata Storeä»hbaseå¤ä»½å°ç£çæ件系ç»ãå¨è¿ç§æ
åµä¸ï¼åè®¾ä½ å¨é¨ç½²Kylinçhadoopå½ä»¤è¡ï¼ææ²çï¼éï¼ä½ å¯ä»¥å°KYLIN_HOME并è¿è¡ï¼</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh backup</code></pre></div>
+
+<p>æ¥å°ä½ çå
æ°æ®å¯¼åºå°æ¬å°ç®å½ï¼è¿ä¸ªç®å½å¨KYLIN_HOME/metadata_backpsä¸ï¼å®çå½åè§å使ç¨äºå½åæ¶é´ä½ä¸ºåæ°ï¼KYLIN_HOME/meta_backups/meta_year_month_day_hour_minute_second ã</p>
+
+<h2 id="metatdara-store">使ç¨äºè¿å¶å
æ¥æ¢å¤Metatdara Store</h2>
+
+<p>ä¸ä¸ä½ åç°ä½ çå
æ°æ®è¢«æå¾ä¸å¢ç³ï¼æ³è¦æ¢å¤å
åçå¤ä»½ï¼</p>
+
+<p>é¦å
ï¼éç½®Metatdara Storeï¼è¿ä¸ªä¼æ¸
çKylinå¨hbaseçMetadata Storeçææä¿¡æ¯ï¼è¯·ç¡®ä¿å
å¤ä»½ï¼ï¼</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh reset</code></pre></div>
+
+<p>ç¶åä¸ä¼ å¤ä»½çå
æ°æ®å°KylinçMetadata Storeï¼</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh restore $KYLIN_HOME/meta_backups/meta_xxxx_xx_xx_xx_xx_xx</code></pre></div>
+
+<h2 id="section">å¨å¼åç¯å¢å¤ä»½/æ¢å¤å
æ°æ®ï¼0.7.3çæ¬ä»¥ä¸å¯ç¨ï¼</h2>
+
+<p>å¨å¼åè°è¯Kylinæ¶ï¼å
¸åçç¯å¢æ¯ä¸å°è£
æIDEçå¼åæºä¸åä¸ä¸ªåå°çæ²çï¼éå¸¸ä½ ä¼å代ç 并å¨å¼åæºä¸è¿è¡æµè¯æ¡ä¾ï¼ä½æ¯æ¬¡é½éè¦å°äºè¿å¶å
æ¾å°æ²çé以æ£æ¥å
æ°æ®æ¯å¾éº»ç¦çãè¿æ¶æä¸ä¸ªå为SandboxMetastoreCLIå·¥å
·ç±»å¯ä»¥å¸®å©ä½ å¨å¼åæºæ¬å°ä¸è½½/ä¸ä¼ å
æ°æ®ã</p>
+
+<h2 id="metadata-store073">ä»Metadata Storeæ¸
çæ ç¨çèµæºï¼0.7.3çæ¬ä»¥ä¸å¯ç¨ï¼</h2>
+<p>éçè¿è¡æ¶é´å¢é¿ï¼ç±»ä¼¼åå
¸ã表快ç
§çèµæºåå¾æ²¡æç¨ï¼cube segment被丢å¼æè
å并äºï¼ï¼ä½æ¯å®ä»¬ä¾æ§å ç¨ç©ºé´ï¼ä½ å¯ä»¥è¿è¡å½ä»¤æ¥æ¾å°å¹¶æ¸
é¤å®ä»¬ï¼</p>
+
+<p>é¦å
ï¼è¿è¡ä¸ä¸ªæ£æ¥ï¼è¿æ¯å®å
¨çå 为å®ä¸ä¼æ¹åä»»ä½ä¸è¥¿ï¼</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh clean</code></pre></div>
+
+<p>å°è¦è¢«å é¤çèµæºä¼è¢«ååºæ¥ï¼</p>
+
+<p>æ¥ä¸æ¥ï¼å¢å ââdelete trueâåæ°æ¥æ¸
çè¿äºèµæºï¼å¨è¿ä¹åï¼ä½ åºè¯¥ç¡®ä¿å·²ç»å¤ä»½metadata storeï¼</p>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh clean --delete true</code></pre></div>
+
+
+ </article>
+ </div>
+ </div>
+ </div>
<!--
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
@@ -252,6 +306,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink ">æ¦è¿°</a>
</li>
@@ -355,33 +413,13 @@ var _hmt = _hmt || [];
-
-
<li class="navlist">
- <a href="/cn/docs23/install/manual_install_guide.html" class="list-group-item-lay pjaxlink ">æå¨å®è£
æå</a>
+ <a href="/cn/docs23/install/index.html" class="list-group-item-lay pjaxlink ">å®è£
æå</a>
</li>
-
-
-
-
- <ul>
- </div>
-</div>
-
- <li><a href="#titleæç¨" data-toggle="collapse" class="navtitle">æç¨</a></li>
- <div class="collapse in">
- <div class="list-group" id="list1">
- <ul>
-
-
-
-
-
-
@@ -468,14 +506,8 @@ var _hmt = _hmt || [];
-
-
-
-
-
-
<li class="navlist">
- <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube å建</a>
+ <a href="/cn/docs23/install/kylin_cluster.html" class="list-group-item-lay pjaxlink ">Cluster 模å¼ä¸é¨ç½²</a>
</li>
@@ -553,32 +585,8 @@ var _hmt = _hmt || [];
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
<li class="navlist">
- <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube æ建å Job çæ§</a>
+ <a href="/cn/docs23/install/configuration.html" class="list-group-item-lay pjaxlink ">Kylin é
ç½®</a>
</li>
@@ -652,22 +660,21 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/install/advance_settings.html" class="list-group-item-lay pjaxlink ">é«çº§è®¾ç½®</a>
+ </li>
+
+
+
+
-
-
-
-
-
-
-
-
-
-
-
+
-
+
+
+
@@ -742,7 +749,10 @@ var _hmt = _hmt || [];
-
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink ">å¨ AWS EMR ä¸ å®è£
Kylin</a>
+ </li>
+
@@ -836,11 +846,40 @@ var _hmt = _hmt || [];
-
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_docker.html" class="list-group-item-lay pjaxlink ">ç¨ Docker è¿è¡ Kylin</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#titleæç¨" data-toggle="collapse" class="navtitle">æç¨</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
@@ -902,21 +941,12 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web çé¢</a>
- </li>
-
-
-
-
-
+
-
-
-
+
@@ -979,9 +1009,22 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink ">æ ·ä¾ Cube å¿«éå
¥é¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
@@ -1023,21 +1066,12 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客æ·ç«¯å·¥å
ጼ</a>
- </li>
-
-
-
-
-
+
-
-
-
+
@@ -1175,7 +1209,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau</a>
+ <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web çé¢</a>
</li>
@@ -1287,14 +1321,21 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube å建</a>
+ </li>
+
+
+
+
-
-
-
+
-
+
+
+
@@ -1329,22 +1370,9 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
- </li>
-
-
-
-
-
-
-
-
-
-
@@ -1410,12 +1438,2451 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube æ建å Job çæ§</a>
+ </li>
+
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink ">Project Level ACL</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink ">ç¨ Spark æ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink ">ä» Kafka æµæ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客æ·ç«¯</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink ">建ç«ç³»ç» Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink ">ä½¿ç¨ Cube Planner</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink ">ä½¿ç¨ Dashboard</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink ">å»ºç« JDBC æ°æ®æº</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#titleå·¥å
·éæ" data-toggle="collapse" class="navtitle">å·¥å
·éæ</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/jdbc.html" class="list-group-item-lay pjaxlink ">JDBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau 8</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">Excel å Power BI æç¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -1462,22 +3929,9 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">MS ExcelåPower BIæç¨</a>
- </li>
-
-
-
-
-
-
-
-
-
-
@@ -1592,7 +4046,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱å¨ç¨åº</a>
+ <a href="/cn/docs23/tutorial/squirrel.html" class="list-group-item-lay pjaxlink ">SQuirreL</a>
</li>
@@ -1682,6 +4136,20 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li class="navlist">
<a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink ">Qlik Sense éæ</a>
</li>
@@ -1727,8 +4195,46 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li class="navlist">
- <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">å¤ä»½å
æ°æ®</a>
+ <a href="/cn/docs23/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink ">Use RESTful API</a>
</li>
@@ -1793,8 +4299,26 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li class="navlist">
- <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">æ¸
çåå¨</a>
+ <a href="/cn/docs23/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink ">ä¼å Cube 设计</a>
</li>
@@ -1836,8 +4360,14 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
<li class="navlist">
- <a href="/cn/docs23/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink ">Kylin JDBC Driver</a>
+ <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
</li>
@@ -1863,9 +4393,22 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">å¤ä»½å
æ°æ®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
@@ -1886,7 +4429,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
+ <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">æ¸
çåå¨</a>
</li>
@@ -1903,60 +4446,6 @@ var _hmt = _hmt || [];
</ul>
</div>
- <div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2">
- <div id="container" class="docs">
- <div id="pjax">
- <h1 class="post-title">å¤ä»½å
æ°æ®</h1>
- <article class="post-content" >
- <p>Kylinå°å®å
¨é¨çå
æ°æ®ï¼å
æ¬cubeæè¿°åå®ä¾ã项ç®ãåæç´¢å¼æè¿°åå®ä¾ãä»»å¡ã表ååå
¸ï¼ç»ç»æå±çº§æ件系ç»çå½¢å¼ãç¶èï¼Kylin使ç¨hbaseæ¥åå¨å
æ°æ®ï¼èä¸æ¯ä¸ä¸ªæ®éçæ件系ç»ãå¦æä½ æ¥çè¿Kylinçé
ç½®æ件ï¼kylin.propertiesï¼ï¼ä½ ä¼åç°è¿æ ·ä¸è¡ï¼</p>
-
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">## The metadata store in hbase
-kylin.metadata.url=kylin_metadata@hbase</code></pre></div>
-
-<p>è¿è¡¨æå
æ°æ®ä¼è¢«ä¿åå¨ä¸ä¸ªå«ä½âkylin_metadataâçhtableéãä½ å¯ä»¥å¨hbase shelléscan该htbaleæ¥è·åå®ã</p>
-
-<h2 id="metadata-store">使ç¨äºè¿å¶å
æ¥å¤ä»½Metadata Store</h2>
-
-<p>ææ¶ä½ éè¦å°KylinçMetadata Storeä»hbaseå¤ä»½å°ç£çæ件系ç»ãå¨è¿ç§æ
åµä¸ï¼åè®¾ä½ å¨é¨ç½²Kylinçhadoopå½ä»¤è¡ï¼ææ²çï¼éï¼ä½ å¯ä»¥å°KYLIN_HOME并è¿è¡ï¼</p>
-
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh backup</code></pre></div>
-
-<p>æ¥å°ä½ çå
æ°æ®å¯¼åºå°æ¬å°ç®å½ï¼è¿ä¸ªç®å½å¨KYLIN_HOME/metadata_backpsä¸ï¼å®çå½åè§å使ç¨äºå½åæ¶é´ä½ä¸ºåæ°ï¼KYLIN_HOME/meta_backups/meta_year_month_day_hour_minute_second ã</p>
-
-<h2 id="metatdara-store">使ç¨äºè¿å¶å
æ¥æ¢å¤Metatdara Store</h2>
-
-<p>ä¸ä¸ä½ åç°ä½ çå
æ°æ®è¢«æå¾ä¸å¢ç³ï¼æ³è¦æ¢å¤å
åçå¤ä»½ï¼</p>
-
-<p>é¦å
ï¼éç½®Metatdara Storeï¼è¿ä¸ªä¼æ¸
çKylinå¨hbaseçMetadata Storeçææä¿¡æ¯ï¼è¯·ç¡®ä¿å
å¤ä»½ï¼ï¼</p>
-
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh reset</code></pre></div>
-
-<p>ç¶åä¸ä¼ å¤ä»½çå
æ°æ®å°KylinçMetadata Storeï¼</p>
-
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh restore $KYLIN_HOME/meta_backups/meta_xxxx_xx_xx_xx_xx_xx</code></pre></div>
-
-<h2 id="section">å¨å¼åç¯å¢å¤ä»½/æ¢å¤å
æ°æ®ï¼0.7.3çæ¬ä»¥ä¸å¯ç¨ï¼</h2>
-
-<p>å¨å¼åè°è¯Kylinæ¶ï¼å
¸åçç¯å¢æ¯ä¸å°è£
æIDEçå¼åæºä¸åä¸ä¸ªåå°çæ²çï¼éå¸¸ä½ ä¼å代ç 并å¨å¼åæºä¸è¿è¡æµè¯æ¡ä¾ï¼ä½æ¯æ¬¡é½éè¦å°äºè¿å¶å
æ¾å°æ²çé以æ£æ¥å
æ°æ®æ¯å¾éº»ç¦çãè¿æ¶æä¸ä¸ªå为SandboxMetastoreCLIå·¥å
·ç±»å¯ä»¥å¸®å©ä½ å¨å¼åæºæ¬å°ä¸è½½/ä¸ä¼ å
æ°æ®ã</p>
-
-<h2 id="metadata-store073">ä»Metadata Storeæ¸
çæ ç¨çèµæºï¼0.7.3çæ¬ä»¥ä¸å¯ç¨ï¼</h2>
-<p>éçè¿è¡æ¶é´å¢é¿ï¼ç±»ä¼¼åå
¸ã表快ç
§çèµæºåå¾æ²¡æç¨ï¼cube segment被丢å¼æè
å并äºï¼ï¼ä½æ¯å®ä»¬ä¾æ§å ç¨ç©ºé´ï¼ä½ å¯ä»¥è¿è¡å½ä»¤æ¥æ¾å°å¹¶æ¸
é¤å®ä»¬ï¼</p>
-
-<p>é¦å
ï¼è¿è¡ä¸ä¸ªæ£æ¥ï¼è¿æ¯å®å
¨çå 为å®ä¸ä¼æ¹åä»»ä½ä¸è¥¿ï¼</p>
-
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh clean</code></pre></div>
-
-<p>å°è¦è¢«å é¤çèµæºä¼è¢«ååºæ¥ï¼</p>
-
-<p>æ¥ä¸æ¥ï¼å¢å ââdelete trueâåæ°æ¥æ¸
çè¿äºèµæºï¼å¨è¿ä¹åï¼ä½ åºè¯¥ç¡®ä¿å·²ç»å¤ä»½metadata storeï¼</p>
-
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">./bin/metastore.sh clean --delete true</code></pre></div>
-
-
- </article>
- </div>
- </div>
- </div>
</div>
</div>
<!--
Modified: kylin/site/cn/docs23/howto/howto_build_cube_with_restapi.html
URL: http://svn.apache.org/viewvc/kylin/site/cn/docs23/howto/howto_build_cube_with_restapi.html?rev=1834820&r1=1834819&r2=1834820&view=diff
==============================================================================
--- kylin/site/cn/docs23/howto/howto_build_cube_with_restapi.html (original)
+++ kylin/site/cn/docs23/howto/howto_build_cube_with_restapi.html Mon Jul 2 06:08:48 2018
@@ -160,7 +160,74 @@ var _hmt = _hmt || [];
<div class="container">
- <div class="row">
+ <div class="row" style="clear:both;">
+ <div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2" style="float:right;">
+ <div id="container" class="docs">
+ <div id="pjax">
+ <h1 class="post-title">ç¨ API æ建 Cube</h1>
+ <article class="post-content" >
+ <h3 id="section">1. 认è¯</h3>
+<ul>
+ <li>ç®åKylin使ç¨<a href="http://en.wikipedia.org/wiki/Basic_access_authentication">basic authentication</a>ã</li>
+ <li>ç»ç¬¬ä¸ä¸ªè¯·æ±å ä¸ç¨äºè®¤è¯ç Authorization 头é¨ã</li>
+ <li>æè
è¿è¡ä¸ä¸ªç¹å®ç请æ±: POST http://localhost:7070/kylin/api/user/authentication ã</li>
+ <li>å®æ认è¯å, 客æ·ç«¯å¯ä»¥å¨æ¥ä¸æ¥ç请æ±é带ä¸cookieã</li>
+</ul>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">POST http://localhost:7070/kylin/api/user/authentication
+
+Authorization:Basic xxxxJD124xxxGFxxxSDF
+Content-Type: application/json;charset=UTF-8</code></pre></div>
+
+<h3 id="cube">2. è·åCubeç详ç»ä¿¡æ¯</h3>
+<ul>
+ <li><code class="highlighter-rouge">GET http://localhost:7070/kylin/api/cubes?cubeName={cube_name}&limit=15&offset=0</code></li>
+ <li>ç¨æ·å¯ä»¥å¨è¿åçcube详ç»ä¿¡æ¯éæ¾å°cubeçsegmentæ¥æèå´ã</li>
+</ul>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">GET http://localhost:7070/kylin/api/cubes?cubeName=test_kylin_cube_with_slr&limit=15&offset=0
+
+Authorization:Basic xxxxJD124xxxGFxxxSDF
+Content-Type: application/json;charset=UTF-8</code></pre></div>
+
+<h3 id="cube-1">3. ç¶åæ交cubeæ建任å¡</h3>
+<ul>
+ <li><code class="highlighter-rouge">PUT http://localhost:7070/kylin/api/cubes/{cube_name}/rebuild</code></li>
+ <li>å
³äº put ç请æ±ä½ç»è请åè Build Cube API
+ <ul>
+ <li><code class="highlighter-rouge">startTime</code> å <code class="highlighter-rouge">endTime</code> åºè¯¥æ¯utcæ¶é´ã</li>
+ <li><code class="highlighter-rouge">buildType</code> å¯ä»¥æ¯ <code class="highlighter-rouge">BUILD</code> ã <code class="highlighter-rouge">MERGE</code> æ <code class="highlighter-rouge">REFRESH</code>ã <code class="highlighter-rouge">BUILD</code> ç¨äºæ建ä¸ä¸ªæ°çsegmentï¼ <code class="highlighter-rouge">REFRESH</code> ç¨äºå·æ°ä¸ä¸ªå·²æçsegmentï¼ <code class="highlighter-rouge">MERGE</code> ç¨äºå并å¤ä¸ªå·²æçsegmentçæä¸ä¸ªè¾å¤§çsegmentã</li>
+ </ul>
+ </li>
+ <li>è¿ä¸ªæ¹æ³ä¼è¿åä¸ä¸ªæ°å»ºçä»»å¡å®ä¾ï¼å®çuuidæ¯ä»»å¡çå¯ä¸idï¼ç¨äºè¿½è¸ªä»»å¡ç¶æã</li>
+</ul>
+
+<div class="highlight"><pre><code class="language-groff" data-lang="groff">PUT http://localhost:7070/kylin/api/cubes/test_kylin_cube_with_slr/rebuild
+
+Authorization:Basic xxxxJD124xxxGFxxxSDF
+Content-Type: application/json;charset=UTF-8
+
+{
+ "startTime": 0,
+ "endTime": 1388563200000,
+ "buildType": "BUILD"
+}</code></pre></div>
+
+<h3 id="section-1">4. è·è¸ªä»»å¡ç¶æ</h3>
+<ul>
+ <li><code class="highlighter-rouge">GET http://localhost:7070/kylin/api/jobs/{job_uuid}</code></li>
+ <li>
+ <p>è¿åç <code class="highlighter-rouge">job_status</code> 代表jobçå½åç¶æã</p>
+
+ <h2 id="section-2">5. å¦ææ建任å¡åºç°é误ï¼å¯ä»¥éæ°å¼å§å®</h2>
+ </li>
+ <li><code class="highlighter-rouge">PUT http://localhost:7070/kylin/api/jobs/{job_uuid}/resume</code></li>
+</ul>
+
+ </article>
+ </div>
+ </div>
+ </div>
<!--
* Licensed to the Apache Software Foundation (ASF) under one
* or more contributor license agreements. See the NOTICE file
@@ -252,6 +319,10 @@ var _hmt = _hmt || [];
+
+
+
+
<li class="navlist">
<a href="/cn/docs23/index.html" class="list-group-item-lay pjaxlink ">æ¦è¿°</a>
</li>
@@ -355,33 +426,13 @@ var _hmt = _hmt || [];
-
-
<li class="navlist">
- <a href="/cn/docs23/install/manual_install_guide.html" class="list-group-item-lay pjaxlink ">æå¨å®è£
æå</a>
+ <a href="/cn/docs23/install/index.html" class="list-group-item-lay pjaxlink ">å®è£
æå</a>
</li>
-
-
-
-
- <ul>
- </div>
-</div>
-
- <li><a href="#titleæç¨" data-toggle="collapse" class="navtitle">æç¨</a></li>
- <div class="collapse in">
- <div class="list-group" id="list1">
- <ul>
-
-
-
-
-
-
@@ -468,14 +519,8 @@ var _hmt = _hmt || [];
-
-
-
-
-
-
<li class="navlist">
- <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube å建</a>
+ <a href="/cn/docs23/install/kylin_cluster.html" class="list-group-item-lay pjaxlink ">Cluster 模å¼ä¸é¨ç½²</a>
</li>
@@ -553,6 +598,57 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/install/configuration.html" class="list-group-item-lay pjaxlink ">Kylin é
ç½®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -578,7 +674,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube æ建å Job çæ§</a>
+ <a href="/cn/docs23/install/advance_settings.html" class="list-group-item-lay pjaxlink ">é«çº§è®¾ç½®</a>
</li>
@@ -666,12 +762,21 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_aws_emr.html" class="list-group-item-lay pjaxlink ">å¨ AWS EMR ä¸ å®è£
Kylin</a>
+ </li>
+
+
+
+
-
+
-
+
+
+
@@ -743,18 +848,8 @@ var _hmt = _hmt || [];
-
-
-
-
-
-
-
-
-
-
@@ -764,15 +859,40 @@ var _hmt = _hmt || [];
-
+ <li class="navlist">
+ <a href="/cn/docs23/install/kylin_docker.html" class="list-group-item-lay pjaxlink ">ç¨ Docker è¿è¡ Kylin</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
-
+ <li><a href="#titleæç¨" data-toggle="collapse" class="navtitle">æç¨</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
-
+
+
+
+
+
@@ -903,7 +1023,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web çé¢</a>
+ <a href="/cn/docs23/tutorial/kylin_sample.html" class="list-group-item-lay pjaxlink ">æ ·ä¾ Cube å¿«éå
¥é¨</a>
</li>
@@ -1023,22 +1143,9 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客æ·ç«¯å·¥å
ጼ</a>
- </li>
-
-
-
-
-
-
-
-
-
-
@@ -1114,11 +1221,22 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/web.html" class="list-group-item-lay pjaxlink ">Web çé¢</a>
+ </li>
+
+
+
+
-
+
+
+
+
+
@@ -1174,21 +1292,12 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau</a>
- </li>
-
-
-
-
-
+
-
-
-
+
@@ -1225,9 +1334,22 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/create_cube.html" class="list-group-item-lay pjaxlink ">Cube å建</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
@@ -1330,7 +1452,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
+ <a href="/cn/docs23/tutorial/cube_build_job.html" class="list-group-item-lay pjaxlink ">Cube æ建å Job çæ§</a>
</li>
@@ -1462,10 +1584,2305 @@ var _hmt = _hmt || [];
- <li class="navlist">
- <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">MS ExcelåPower BIæç¨</a>
- </li>
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/project_level_acl.html" class="list-group-item-lay pjaxlink ">Project Level ACL</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_spark.html" class="list-group-item-lay pjaxlink ">ç¨ Spark æ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_streaming.html" class="list-group-item-lay pjaxlink ">ä» Kafka æµæ建 Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/cube_build_performance.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/kylin_client_tool.html" class="list-group-item-lay pjaxlink ">Python 客æ·ç«¯</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/setup_systemcube.html" class="list-group-item-lay pjaxlink ">建ç«ç³»ç» Cube</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/use_cube_planner.html" class="list-group-item-lay pjaxlink ">ä½¿ç¨ Cube Planner</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/use_dashboard.html" class="list-group-item-lay pjaxlink ">ä½¿ç¨ Dashboard</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/setup_jdbc_datasource.html" class="list-group-item-lay pjaxlink ">å»ºç« JDBC æ°æ®æº</a>
+ </li>
+
+
+
+
+
+
+
+
+ <ul>
+ </div>
+</div>
+
+ <li><a href="#titleå·¥å
·éæ" data-toggle="collapse" class="navtitle">å·¥å
·éæ</a></li>
+ <div class="collapse in">
+ <div class="list-group" id="list1">
+ <ul>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/jdbc.html" class="list-group-item-lay pjaxlink ">JDBC 驱å¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/tableau.html" class="list-group-item-lay pjaxlink ">Tableau 8</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/tableau_91.html" class="list-group-item-lay pjaxlink ">Tableau 9</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="navlist">
+ <a href="/cn/docs23/tutorial/powerbi.html" class="list-group-item-lay pjaxlink ">Excel å Power BI æç¨</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -1591,8 +4008,58 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li class="navlist">
- <a href="/cn/docs23/tutorial/odbc.html" class="list-group-item-lay pjaxlink ">ODBC 驱å¨ç¨åº</a>
+ <a href="/cn/docs23/tutorial/squirrel.html" class="list-group-item-lay pjaxlink ">SQuirreL</a>
</li>
@@ -1682,6 +4149,20 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li class="navlist">
<a href="/cn/docs23/tutorial/Qlik.html" class="list-group-item-lay pjaxlink ">Qlik Sense éæ</a>
</li>
@@ -1727,8 +4208,46 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li class="navlist">
- <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">å¤ä»½å
æ°æ®</a>
+ <a href="/cn/docs23/howto/howto_use_restapi.html" class="list-group-item-lay pjaxlink ">Use RESTful API</a>
</li>
@@ -1793,8 +4312,26 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
<li class="navlist">
- <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">æ¸
çåå¨</a>
+ <a href="/cn/docs23/howto/howto_optimize_cubes.html" class="list-group-item-lay pjaxlink ">ä¼å Cube 设计</a>
</li>
@@ -1836,8 +4373,14 @@ var _hmt = _hmt || [];
+
+
+
+
+
+
<li class="navlist">
- <a href="/cn/docs23/howto/howto_jdbc.html" class="list-group-item-lay pjaxlink ">Kylin JDBC Driver</a>
+ <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
</li>
@@ -1863,9 +4406,22 @@ var _hmt = _hmt || [];
+ <li class="navlist">
+ <a href="/cn/docs23/howto/howto_backup_metadata.html" class="list-group-item-lay pjaxlink ">å¤ä»½å
æ°æ®</a>
+ </li>
+
+
+
+
+
+
+
+
+
+
@@ -1886,7 +4442,7 @@ var _hmt = _hmt || [];
<li class="navlist">
- <a href="/cn/docs23/howto/howto_optimize_build.html" class="list-group-item-lay pjaxlink ">ä¼å Cube æ建</a>
+ <a href="/cn/docs23/howto/howto_cleanup_storage.html" class="list-group-item-lay pjaxlink ">æ¸
çåå¨</a>
</li>
@@ -1903,73 +4459,6 @@ var _hmt = _hmt || [];
</ul>
</div>
- <div class="col-md-8 col-lg-8 col-xs-12 col-sm-12 aside2">
- <div id="container" class="docs">
- <div id="pjax">
- <h1 class="post-title">ç¨ API æ建 Cube</h1>
- <article class="post-content" >
- <h3 id="section">1. 认è¯</h3>
-<ul>
- <li>ç®åKylin使ç¨<a href="http://en.wikipedia.org/wiki/Basic_access_authentication">basic authentication</a>ã</li>
- <li>ç»ç¬¬ä¸ä¸ªè¯·æ±å ä¸ç¨äºè®¤è¯ç Authorization 头é¨ã</li>
- <li>æè
è¿è¡ä¸ä¸ªç¹å®ç请æ±: POST http://localhost:7070/kylin/api/user/authentication ã</li>
- <li>å®æ认è¯å, 客æ·ç«¯å¯ä»¥å¨æ¥ä¸æ¥ç请æ±é带ä¸cookieã</li>
-</ul>
-
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">POST http://localhost:7070/kylin/api/user/authentication
-
-Authorization:Basic xxxxJD124xxxGFxxxSDF
-Content-Type: application/json;charset=UTF-8</code></pre></div>
-
-<h3 id="cube">2. è·åCubeç详ç»ä¿¡æ¯</h3>
-<ul>
- <li><code class="highlighter-rouge">GET http://localhost:7070/kylin/api/cubes?cubeName={cube_name}&limit=15&offset=0</code></li>
- <li>ç¨æ·å¯ä»¥å¨è¿åçcube详ç»ä¿¡æ¯éæ¾å°cubeçsegmentæ¥æèå´ã</li>
-</ul>
-
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">GET http://localhost:7070/kylin/api/cubes?cubeName=test_kylin_cube_with_slr&limit=15&offset=0
-
-Authorization:Basic xxxxJD124xxxGFxxxSDF
-Content-Type: application/json;charset=UTF-8</code></pre></div>
-
-<h3 id="cube-1">3. ç¶åæ交cubeæ建任å¡</h3>
-<ul>
- <li><code class="highlighter-rouge">PUT http://localhost:7070/kylin/api/cubes/{cube_name}/rebuild</code></li>
- <li>å
³äº put ç请æ±ä½ç»è请åè Build Cube API
- <ul>
- <li><code class="highlighter-rouge">startTime</code> å <code class="highlighter-rouge">endTime</code> åºè¯¥æ¯utcæ¶é´ã</li>
- <li><code class="highlighter-rouge">buildType</code> å¯ä»¥æ¯ <code class="highlighter-rouge">BUILD</code> ã <code class="highlighter-rouge">MERGE</code> æ <code class="highlighter-rouge">REFRESH</code>ã <code class="highlighter-rouge">BUILD</code> ç¨äºæ建ä¸ä¸ªæ°çsegmentï¼ <code class="highlighter-rouge">REFRESH</code> ç¨äºå·æ°ä¸ä¸ªå·²æçsegmentï¼ <code class="highlighter-rouge">MERGE</code> ç¨äºå并å¤ä¸ªå·²æçsegmentçæä¸ä¸ªè¾å¤§çsegmentã</li>
- </ul>
- </li>
- <li>è¿ä¸ªæ¹æ³ä¼è¿åä¸ä¸ªæ°å»ºçä»»å¡å®ä¾ï¼å®çuuidæ¯ä»»å¡çå¯ä¸idï¼ç¨äºè¿½è¸ªä»»å¡ç¶æã</li>
-</ul>
-
-<div class="highlight"><pre><code class="language-groff" data-lang="groff">PUT http://localhost:7070/kylin/api/cubes/test_kylin_cube_with_slr/rebuild
-
-Authorization:Basic xxxxJD124xxxGFxxxSDF
-Content-Type: application/json;charset=UTF-8
-
-{
- "startTime": 0,
- "endTime": 1388563200000,
- "buildType": "BUILD"
-}</code></pre></div>
-
-<h3 id="section-1">4. è·è¸ªä»»å¡ç¶æ</h3>
-<ul>
- <li><code class="highlighter-rouge">GET http://localhost:7070/kylin/api/jobs/{job_uuid}</code></li>
- <li>
- <p>è¿åç <code class="highlighter-rouge">job_status</code> 代表jobçå½åç¶æã</p>
-
- <h2 id="section-2">5. å¦ææ建任å¡åºç°é误ï¼å¯ä»¥éæ°å¼å§å®</h2>
- </li>
- <li><code class="highlighter-rouge">PUT http://localhost:7070/kylin/api/jobs/{job_uuid}/resume</code></li>
-</ul>
-
- </article>
- </div>
- </div>
- </div>
</div>
</div>
<!--