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 2020/05/25 14:13:31 UTC
svn commit: r1878099 [3/3] - in /kylin/site:
cn/docs/howto/howto_use_restapi.html docs/howto/howto_use_restapi.html
feed.xml
Modified: kylin/site/docs/howto/howto_use_restapi.html
URL: http://svn.apache.org/viewvc/kylin/site/docs/howto/howto_use_restapi.html?rev=1878099&r1=1878098&r2=1878099&view=diff
==============================================================================
--- kylin/site/docs/howto/howto_use_restapi.html (original)
+++ kylin/site/docs/howto/howto_use_restapi.html Mon May 25 14:13:30 2020
@@ -7718,78 +7718,81 @@ var _hmt = _hmt || [];
<article class="post-content" >
- <p>This page lists the major RESTful APIs provided by Kylin.</p>
-
-<ul>
- <li>Query
- <ul>
- <li><a href="#authentication">Authentication</a></li>
- <li><a href="#query">Query</a></li>
- <li><a href="#list-queryable-tables">List queryable tables</a></li>
- </ul>
- </li>
- <li>CUBE
- <ul>
- <li><a href="#create-cube">Create cube</a></li>
- <li><a href="#list-cubes">List cubes</a></li>
- <li><a href="#get-cube">Get cube</a></li>
- <li><a href="#get-cube-descriptor">Get cube descriptor (dimension, measure info, etc)</a></li>
- <li><a href="#get-data-model">Get data model (fact and lookup table info)</a></li>
- <li><a href="#build-cube">Build cube</a></li>
- <li><a href="#enable-cube">Enable cube</a></li>
- <li><a href="#disable-cube">Disable cube</a></li>
- <li><a href="#purge-cube">Purge cube</a></li>
- <li><a href="#delete-segment">Delete segment</a></li>
- <li><a href="#auto-merge-segment">Auto-Merge segment</a></li>
- </ul>
- </li>
- <li>MODEL
- <ul>
- <li><a href="#create-model">Create model</a></li>
- <li><a href="#get-modeldescdata">Get modelDescData</a></li>
- <li><a href="#delete-model">Delete model</a></li>
- </ul>
- </li>
- <li>JOB
- <ul>
- <li><a href="#resume-job">Resume job</a></li>
- <li><a href="#pause-job">Pause job</a></li>
- <li><a href="#drop-job">Drop job</a></li>
- <li><a href="#discard-job">Discard job</a></li>
- <li><a href="#get-job-status">Get job status</a></li>
- <li><a href="#get-job-step-output">Get job step output</a></li>
- <li><a href="#get-job-list">Get job list</a></li>
- </ul>
- </li>
- <li>Metadata
- <ul>
- <li><a href="#get-hive-table">Get Hive Table</a></li>
- <li><a href="#get-hive-tables">Get Hive Tables</a></li>
- <li><a href="#load-hive-tables">Load Hive Tables</a></li>
- </ul>
- </li>
- <li>Cache
- <ul>
- <li><a href="#wipe-cache">Wipe cache</a></li>
- </ul>
- </li>
- <li>Streaming
- <ul>
- <li><a href="#initiate-cube-start-position">Initiate cube start position</a></li>
- <li><a href="#build-stream-cube">Build stream cube</a></li>
- <li><a href="#check-segment-holes">Check segment holes</a></li>
- <li><a href="#fill-segment-holes">Fill segment holes</a></li>
- </ul>
- </li>
- <li>ACL
- <ul>
- <li><a href="#get-users-can-query-the-table">Get users can query the table</a></li>
- <li><a href="#get-users-cannot-query-the-table">Get users cannot query the table</a></li>
- <li><a href="#put-user-to-table-blacklist">Put user to table blacklist</a></li>
- <li><a href="#delete-user-from-table-blacklist">Delete user from table blacklist</a></li>
- </ul>
- </li>
-</ul>
+ <p>This page lists the major RESTful APIs provided by Kylin.<br />
+* Authentication<br />
+ * <a href="#authentication">Authentication</a><br />
+* Query<br />
+ * <a href="#query">Query</a><br />
+ * <a href="#prepare-query">Prepare query</a><br />
+ * <a href="#save-query">Save query</a><br />
+ * <a href="#remove-saved-query">Remove saved query</a><br />
+ * <a href="#get-saved-queries">Get saved queries</a><br />
+ * <a href="#get-running-queries">Get running queries</a><br />
+ * <a href="#stop-query">Stop query</a><br />
+ * <a href="#list-queryable-tables">List queryable tables</a><br />
+* CUBE<br />
+ * <a href="#create-cube">Create cube</a><br />
+ * <a href="#update-cube">Update cube</a><br />
+ * <a href="#list-cubes">List cubes</a><br />
+ * <a href="#get-cube">Get cube</a><br />
+ * <a href="#get-cube-descriptor">Get cube descriptor (dimension, measure info, etc)</a><br />
+ * <a href="#get-data-model">Get data model (fact and lookup table info)</a><br />
+ * <a href="#build-cube">Build cube</a><br />
+ * <a href="#enable-cube">Enable cube</a><br />
+ * <a href="#disable-cube">Disable cube</a><br />
+ * <a href="#purge-cube">Purge cube</a><br />
+ * <a href="#delete-segment">Delete segment</a><br />
+ * <a href="#auto-merge-segment">Auto-Merge segment</a><br />
+ * <a href="#get-sql-of-a-cube">Get sql of a cube</a><br />
+ * <a href="#get-sql-of-a-cube-segment">Get sql of a cube segment</a><br />
+ * <a href="#force-rebuild-lookup-table-snapshot">Force rebuild lookup table snapshot</a><br />
+ * <a href="#clone-cube">Clone cube</a><br />
+ * <a href="#delete-cube">Delete Cube</a><br />
+ * <a href="#get-hbase-info">Get hbase info</a><br />
+ * <a href="#get-current-cuboid">Get current cuboid</a><br />
+ * <a href="#migrate-cube">Migrate cube</a><br />
+* MODEL<br />
+ * <a href="#create-model">Create model</a><br />
+ * <a href="#update-model">Update model</a><br />
+ * <a href="#get-modeldescdata">Get modelDescData</a><br />
+ * <a href="#delete-model">Delete model</a><br />
+ * <a href="#clone-model">Clone model</a><br />
+* JOB<br />
+ * <a href="#resume-job">Resume job</a><br />
+ * <a href="#pause-job">Pause job</a><br />
+ * <a href="#drop-job">Drop job</a><br />
+ * <a href="#discard-job">Discard job</a><br />
+ * <a href="#get-job-status">Get job status</a><br />
+ * <a href="#get-job-step-output">Get job step output</a><br />
+ * <a href="#get-job-list">Get job list</a><br />
+ * <a href="#get-job-status-overview">Get job status overview</a><br />
+ * <a href="#resubmit-realtime-build-job">Resubmit realtime build job</a><br />
+ * <a href="#rollback-job">Rollback job</a><br />
+* Metadata<br />
+ * <a href="#get-hive-table">Get Hive Table</a><br />
+ * <a href="#get-hive-tables">Get Hive Tables</a><br />
+ * <a href="#load-hive-tables">Load Hive Tables</a><br />
+ * <a href="#unload-hive-tables">Unload Hive Tables</a><br />
+ * <a href="#show-databases-in-hive">Show databases in hive</a><br />
+ * <a href="#show-tables-in-a-hive-database">Show tables in a hive database</a><br />
+* Cache<br />
+ * <a href="#wipe-cache">Wipe cache</a><br />
+ * <a href="#announce-wipe-cache">Announce wipe cache</a><br />
+ * <a href="#hot-load-kylin-config">Hot load kylin config</a><br />
+* Streaming<br />
+ * <a href="#initiate-cube-start-position">Initiate cube start position</a><br />
+ * <a href="#build-stream-cube">Build stream cube</a><br />
+ * <a href="#check-segment-holes">Check segment holes</a><br />
+ * <a href="#fill-segment-holes">Fill segment holes</a><br />
+ * <a href="#get-streaming-configs">Get streaming configs</a><br />
+ * <a href="#get-kafka-configs">Get Kafka configs</a><br />
+ * <a href="#create-streaming-schema">Create streaming schema</a><br />
+ * <a href="#update-streaming-schema">Update streaming tables</a><br />
+* ACL<br />
+ * <a href="#get-users-can-query-the-table">Get users can query the table</a><br />
+ * <a href="#get-users-cannot-query-the-table">Get users cannot query the table</a><br />
+ * <a href="#put-user-to-table-blacklist">Put user to table blacklist</a><br />
+ * <a href="#delete-user-from-table-blacklist">Delete user from table blacklist</a></p>
<h2 id="authentication">Authentication</h2>
<p><code class="highlighter-rouge">POST /kylin/api/user/authentication</code></p>
@@ -7809,23 +7812,33 @@ python -c "import base64; print base64.s
<h4 id="response-sample">Response Sample</h4>
-<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
- <span class="s2">"userDetails"</span>:<span class="o">{</span>
- <span class="s2">"password"</span>:null,
- <span class="s2">"username"</span>:<span class="s2">"sample"</span>,
- <span class="s2">"authorities"</span>:[
- <span class="o">{</span>
- <span class="s2">"authority"</span>:<span class="s2">"ROLE_ANALYST"</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"authority"</span>:<span class="s2">"ROLE_MODELER"</span>
- <span class="o">}</span>
- <span class="o">]</span>,
- <span class="s2">"accountNonExpired"</span>:true,
- <span class="s2">"accountNonLocked"</span>:true,
- <span class="s2">"credentialsNonExpired"</span>:true,
- <span class="s2">"enabled"</span>:true
- <span class="o">}</span>
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
+ <span class="s2">"userDetails"</span>: <span class="o">{</span>
+ <span class="s2">"username"</span>: <span class="s2">"sample"</span>,
+ <span class="s2">"password"</span>: <span class="s2">"null"</span>,
+ <span class="s2">"authorities"</span>: <span class="o">[</span>
+ <span class="o">{</span>
+ <span class="s2">"authority"</span>: <span class="s2">"ROLE_ADMIN"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"authority"</span>: <span class="s2">"ROLE_ANALYST"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"authority"</span>: <span class="s2">"ROLE_MODELER"</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"authority"</span>: <span class="s2">"ALL_USERS"</span>
+ <span class="o">}</span>
+ <span class="o">]</span>,
+ <span class="s2">"disabled"</span>: <span class="nb">false</span>,
+ <span class="s2">"defaultPassword"</span>: <span class="nb">false</span>,
+ <span class="s2">"locked"</span>: <span class="nb">false</span>,
+ <span class="s2">"lockedTime"</span>: 0,
+ <span class="s2">"wrongTime"</span>: 0,
+ <span class="s2">"uuid"</span>: <span class="s2">"3704ba8c-deb1-ac47-729d-c1039c1bd6ec"</span>,
+ <span class="s2">"last_modified"</span>: 1585219480112,
+ <span class="s2">"version"</span>: <span class="s2">"3.0.0.20500"</span>
+ <span class="o">}</span>
<span class="o">}</span>
</code></pre>
</div>
@@ -7975,15 +7988,95 @@ python -c "import base64; print base64.s
</code></pre>
</div>
+<h2 id="prepare-query">Prepare query</h2>
+<p><code class="highlighter-rouge">POST /kylin/api/query/prestate</code></p>
+
+<h4 id="request-body-1">Request Body</h4>
+<ul>
+ <li>sql - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> The text of sql statement.</li>
+ <li>offset - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">int</code> Query offset. If offset is set in sql, curIndex will be ignored.</li>
+ <li>limit - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">int</code> Query limit. If limit is set in sql, perPage will be ignored.</li>
+ <li>acceptPartial - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">bool</code> Whether accept a partial result or not, default be âfalseâ. Set to âfalseâ for production use.</li>
+ <li>project - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">string</code> Project to perform query. Default value is âDEFAULTâ.</li>
+</ul>
+
+<h4 id="request-sample-1">Request Sample</h4>
+
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
+ <span class="s2">"sql"</span>:<span class="s2">"select * from TEST_KYLIN_FACT"</span>,
+ <span class="s2">"offset"</span>:0,
+ <span class="s2">"limit"</span>:50000,
+ <span class="s2">"acceptPartial"</span>:false,
+ <span class="s2">"project"</span>:<span class="s2">"DEFAULT"</span>
+<span class="o">}</span>
+</code></pre>
+</div>
+
+<h2 id="save-query">Save query</h2>
+<p><code class="highlighter-rouge">POST /kylin/api/saved_queries</code></p>
+
+<h4 id="request-body-2">Request Body</h4>
+<ul>
+ <li>sql - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> The text of sql statement.</li>
+ <li>name - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Sql name.</li>
+ <li>project - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Project to perform query.</li>
+ <li>description - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">string</code> Sql description.</li>
+</ul>
+
+<h4 id="request-sample-2">Request Sample</h4>
+
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
+ <span class="s2">"sql"</span>: <span class="s2">"select count(*) from kylin_sales"</span>,
+ <span class="s2">"name"</span>: <span class="s2">"test"</span>,
+ <span class="s2">"project"</span>: <span class="s2">"learn_kylin"</span>
+<span class="o">}</span>
+</code></pre>
+</div>
+
+<h2 id="remove-saved-query">Remove saved query</h2>
+<p><code class="highlighter-rouge">DELETE /kylin/api/saved_queries/{id}</code></p>
+
+<h4 id="request-parameters">Request Parameters</h4>
+<ul>
+ <li>id - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> The id of saved query you want to remove</li>
+</ul>
+
+<h2 id="get-saved-queries">Get saved queries</h2>
+<p><code class="highlighter-rouge">GET /kylin/api/saved_queries</code></p>
+
+<h4 id="response-sample-2">Response Sample</h4>
+<div class="highlighter-rouge"><pre class="highlight"><code>[
+ {
+ "name": "test",
+ "project": "learn_kylin",
+ "sql": "select count(*) from kylin_sales",
+ "description": null,
+ "id": "-1674470999"
+ }
+]
+</code></pre>
+</div>
+
+<h2 id="get-running-queries">Get running queries</h2>
+<p><code class="highlighter-rouge">GET /kylin/api/query/runningQueries</code></p>
+
+<h2 id="stop-query">Stop Query</h2>
+<p><code class="highlighter-rouge">PUT /kylin/api/query/{queryId}/stop</code></p>
+
+<h4 id="path-variable">Path Variable</h4>
+<ul>
+ <li>queryId - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">String</code> The queryId of you want to stop. You can obtain it by <code class="highlighter-rouge">Get running queries</code>.</li>
+</ul>
+
<h2 id="list-queryable-tables">List queryable tables</h2>
<p><code class="highlighter-rouge">GET /kylin/api/tables_and_columns</code></p>
-<h4 id="request-parameters">Request Parameters</h4>
+<h4 id="path-variable-1">Path Variable</h4>
<ul>
<li>project - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> The project to load tables</li>
</ul>
-<h4 id="response-sample-2">Response Sample</h4>
+<h4 id="response-sample-3">Response Sample</h4>
<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">[</span>
<span class="o">{</span>
<span class="s2">"columns"</span>:[
@@ -8058,14 +8151,14 @@ python -c "import base64; print base64.s
<h2 id="create-cube">Create cube</h2>
<p><code class="highlighter-rouge">POST /kylin/api/cubes</code></p>
-<h4 id="request-body-1">Request Body</h4>
+<h4 id="request-body-3">Request Body</h4>
<ul>
<li>cubeDescData - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> cubeDescData to create</li>
<li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> cubeName to create</li>
<li>projectName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> projectName to which cube belongs</li>
</ul>
-<h4 id="request-sample-1">Request Sample</h4>
+<h4 id="request-sample-3">Request Sample</h4>
<div class="highlighter-rouge"><pre class="highlight"><code><span class="p">{</span><span class="w">
</span><span class="nt">"cubeDescData"</span><span class="p">:</span><span class="s2">"{\"uuid\": \"0ef9b7a8-3929-4dff-b59d-2100aadc8dbf\",\"last_modified\": 0,\"version\": \"3.0.0.20500\",\"name\": \"kylin_test_cube\",\"is_draft\": false,\"model_name\": \"kylin_sales_model\",\"description\": \"\",\"null_string\": null,\"dimensions\": [{\"name\": \"TRANS_ID\",\"table\": \"KYLIN_SALES\",\"column\": \"TRANS_ID\",\"derived\": null},{\"name\": \"YEAR_BEG_DT\",\"table\": \"KYLIN_CAL_DT\",\"column\": null,\"derived\": [\"YEAR_BEG_DT\"]},{\"name\": \"MONTH_BEG_DT\",\"table\": \"KYLIN_CAL_DT\",\"column\": null,\"derived\": [\"MONTH_BEG_DT\"]},{\"name\": \"WEEK_BEG_DT\",\"table\": \"KYLIN_CAL_DT\",\"column\": null,\"derived\": [\"WEEK_BEG_DT\"]},{\"name\": \"USER_DEFINED_FIELD1\",\"table\": \"KYLIN_CATEGORY_GROUPINGS\",\"column\": null,\"derived\": [\"USER_DEFINED_FIELD1\"]},{\"name\": \"USER_DEFINED_FIELD3\",\"table\": \"KYLIN_CATEGORY_GROUPINGS\",\"column\": null,\"derived\": [\"USER_DEFIN
ED_FIELD3\"]},{\"name\": \"META_CATEG_NAME\",\"table\": \"KYLIN_CATEGORY_GROUPINGS\",\"column\": \"META_CATEG_NAME\",\"derived\": null},{\"name\": \"CATEG_LVL2_NAME\",\"table\": \"KYLIN_CATEGORY_GROUPINGS\",\"column\": \"CATEG_LVL2_NAME\",\"derived\": null},{\"name\": \"CATEG_LVL3_NAME\",\"table\": \"KYLIN_CATEGORY_GROUPINGS\",\"column\": \"CATEG_LVL3_NAME\",\"derived\": null},{\"name\": \"LSTG_FORMAT_NAME\",\"table\": \"KYLIN_SALES\",\"column\": \"LSTG_FORMAT_NAME\",\"derived\": null},{\"name\": \"SELLER_ID\",\"table\": \"KYLIN_SALES\",\"column\": \"SELLER_ID\",\"derived\": null},{\"name\": \"BUYER_ID\",\"table\": \"KYLIN_SALES\",\"column\": \"BUYER_ID\",\"derived\": null},{\"name\": \"ACCOUNT_BUYER_LEVEL\",\"table\": \"BUYER_ACCOUNT\",\"column\": \"ACCOUNT_BUYER_LEVEL\",\"derived\": null},{\"name\": \"ACCOUNT_SELLER_LEVEL\",\"table\": \"SELLER_ACCOUNT\",\"column\": \"ACCOUNT_SELLER_LEVEL\",\"derived\": null},{\"name\": \"BUYER_COUNTRY\",\"table\": \"BUYER_ACCOUNT\",\"column\": \"A
CCOUNT_COUNTRY\",\"derived\": null},{\"name\": \"SELLER_COUNTRY\",\"table\": \"SELLER_ACCOUNT\",\"column\": \"ACCOUNT_COUNTRY\",\"derived\": null},{\"name\": \"BUYER_COUNTRY_NAME\",\"table\": \"BUYER_COUNTRY\",\"column\": \"NAME\",\"derived\": null},{\"name\": \"SELLER_COUNTRY_NAME\",\"table\": \"SELLER_COUNTRY\",\"column\": \"NAME\",\"derived\": null},{\"name\": \"OPS_USER_ID\",\"table\": \"KYLIN_SALES\",\"column\": \"OPS_USER_ID\",\"derived\": null},{\"name\": \"OPS_REGION\",\"table\": \"KYLIN_SALES\",\"column\": \"OPS_REGION\",\"derived\": null}],\"measures\": [{\"name\": \"GMV_SUM\",\"function\": {\"expression\": \"SUM\",\"parameter\": {\"type\": \"column\",\"value\": \"KYLIN_SALES.PRICE\"},\"returntype\": \"decimal(19,4)\"}},{\"name\": \"BUYER_LEVEL_SUM\",\"function\": {\"expression\": \"SUM\",\"parameter\": {\"type\": \"column\",\"value\": \"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL\"},\"returntype\": \"bigint\"}},{\"name\": \"SELLER_LEVEL_SUM\",\"function\": {\"expression\": \"SUM\",
\"parameter\": {\"type\": \"column\",\"value\": \"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL\"},\"returntype\": \"bigint\"}},{\"name\": \"TRANS_CNT\",\"function\": {\"expression\": \"COUNT\",\"parameter\": {\"type\": \"constant\",\"value\": \"1\"},\"returntype\": \"bigint\"}},{\"name\": \"SELLER_CNT_HLL\",\"function\": {\"expression\": \"COUNT_DISTINCT\",\"parameter\": {\"type\": \"column\",\"value\": \"KYLIN_SALES.SELLER_ID\"},\"returntype\": \"hllc(10)\"}},{\"name\": \"TOP_SELLER\",\"function\": {\"expression\": \"TOP_N\",\"parameter\": {\"type\": \"column\",\"value\": \"KYLIN_SALES.PRICE\",\"next_parameter\": {\"type\": \"column\",\"value\": \"KYLIN_SALES.SELLER_ID\"}},\"returntype\": \"topn(100)\",\"configuration\": {\"topn.encoding.KYLIN_SALES.SELLER_ID\": \"dict\",\"topn.encoding_version.KYLIN_SALES.SELLER_ID\": \"1\"}}}],\"rowkey\": {\"rowkey_columns\": [{\"column\": \"KYLIN_SALES.BUYER_ID\",\"encoding\": \"integer:4\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYL
IN_SALES.SELLER_ID\",\"encoding\": \"integer:4\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_SALES.TRANS_ID\",\"encoding\": \"integer:4\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_SALES.PART_DT\",\"encoding\": \"date\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_SALES.LEAF_CATEG_ID\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL\",\"encoding\": \"di
ct\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"BUYER_ACCOUNT.ACCOUNT_COUNTRY\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"SELLER_ACCOUNT.ACCOUNT_COUNTRY\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"BUYER_COUNTRY.NAME\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"SELLER_COUNTRY.NAME\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_SALES.LSTG_FORMAT_NAME\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_SALES.LSTG_SITE_ID\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_SALES.OPS_USER_ID\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false},{\"column\": \"KYLIN_SALES.OPS_REGION\",\"encoding\": \"dict\",\"encoding_version\": 1,\"isShardBy\": false}]},\"hbase_mapping\": {\"column_family\": [{\"name\": \"F1
\",\"columns\": [{\"qualifier\": \"M\",\"measure_refs\": [\"GMV_SUM\",\"BUYER_LEVEL_SUM\",\"SELLER_LEVEL_SUM\",\"TRANS_CNT\"]}]},{\"name\": \"F2\",\"columns\": [{\"qualifier\": \"M\",\"measure_refs\": [\"SELLER_CNT_HLL\",\"TOP_SELLER\"]}]}]},\"aggregation_groups\": [{\"includes\": [\"KYLIN_SALES.PART_DT\",\"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME\",\"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME\",\"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME\",\"KYLIN_SALES.LEAF_CATEG_ID\",\"KYLIN_SALES.LSTG_FORMAT_NAME\",\"KYLIN_SALES.LSTG_SITE_ID\",\"KYLIN_SALES.OPS_USER_ID\",\"KYLIN_SALES.OPS_REGION\",\"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL\",\"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL\",\"BUYER_ACCOUNT.ACCOUNT_COUNTRY\",\"SELLER_ACCOUNT.ACCOUNT_COUNTRY\",\"BUYER_COUNTRY.NAME\",\"SELLER_COUNTRY.NAME\"],\"select_rule\": {\"hierarchy_dims\": [[\"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME\",\"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME\",\"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME\",\"KYLIN_SALES.LEAF_CATEG_ID\"]],\"mand
atory_dims\": [\"KYLIN_SALES.PART_DT\"],\"joint_dims\": [[\"BUYER_ACCOUNT.ACCOUNT_COUNTRY\",\"BUYER_COUNTRY.NAME\"],[\"SELLER_ACCOUNT.ACCOUNT_COUNTRY\",\"SELLER_COUNTRY.NAME\"],[\"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL\",\"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL\"],[\"KYLIN_SALES.LSTG_FORMAT_NAME\",\"KYLIN_SALES.LSTG_SITE_ID\"],[\"KYLIN_SALES.OPS_USER_ID\",\"KYLIN_SALES.OPS_REGION\"]]}}],\"signature\": null,\"notify_list\": [],\"status_need_notify\": [],\"partition_date_start\": 1325376000000,\"partition_date_end\": 3153600000000,\"auto_merge_time_ranges\": [],\"volatile_range\": 0,\"retention_range\": 0,\"engine_type\": 2,\"storage_type\": 2,\"override_kylin_properties\": {\"kylin.cube.aggrgroup.is-mandatory-only-valid\": \"true\",\"kylin.engine.spark.rdd-partition-cut-mb\": \"500\"},\"cuboid_black_list\": [],\"parent_forward\": 3,\"mandatory_dimension_set_list\": [],\"snapshot_table_desc_list\": []}"</span><span class="p">,</span><span class="w">
</span><span class="nt">"cubeName"</span><span class="p">:</span><span class="s2">"kylin_test_cube"</span><span class="p">,</span><span class="w">
@@ -8074,7 +8167,7 @@ python -c "import base64; print base64.s
</span></code></pre>
</div>
-<h4 id="response-sample-3">Response Sample</h4>
+<h4 id="response-sample-4">Response Sample</h4>
<div class="highlighter-rouge"><pre class="highlight"><code><span class="p">{</span><span class="w">
</span><span class="nt">"uuid"</span><span class="p">:</span><span class="w"> </span><span class="s2">"7b3faf69-eca8-cc5f-25f9-49b0f0b5d404"</span><span class="p">,</span><span class="w">
</span><span class="nt">"cubeName"</span><span class="p">:</span><span class="w"> </span><span class="s2">"kylin_test_cube"</span><span class="p">,</span><span class="w">
@@ -8089,6 +8182,18 @@ python -c "import base64; print base64.s
</span></code></pre>
</div>
+<h2 id="update-cube">Update Cube</h2>
+<p><code class="highlighter-rouge">PUT /kylin/api/cubes</code></p>
+
+<h4 id="request-body-4">Request Body</h4>
+<p>(Same as âCreate Cubeâ)</p>
+
+<h4 id="request-sample-4">Request Sample</h4>
+<p>(Same as âCreate Cubeâ)</p>
+
+<h4 id="response-sample-5">Response Sample</h4>
+<p>(Same as âCreate Cubeâ)</p>
+
<h2 id="list-cubes">List cubes</h2>
<p><code class="highlighter-rouge">GET /kylin/api/cubes</code></p>
@@ -8100,7 +8205,7 @@ python -c "import base64; print base64.s
<li>projectName - <code class="highlighter-rouge">optional</code> <code class="highlighter-rouge">string</code> Project name.</li>
</ul>
-<h4 id="response-sample-4">Response Sample</h4>
+<h4 id="response-sample-6">Response Sample</h4>
<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">[</span>
<span class="o">{</span>
<span class="s2">"uuid"</span>:<span class="s2">"1eaca32a-a33e-4b69-83dd-0bb8b1f8c53b"</span>,
@@ -8125,7 +8230,7 @@ python -c "import base64; print base64.s
<h2 id="get-cube">Get cube</h2>
<p><code class="highlighter-rouge">GET /kylin/api/cubes/{cubeName}</code></p>
-<h4 id="path-variable">Path Variable</h4>
+<h4 id="path-variable-2">Path Variable</h4>
<ul>
<li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name to find.</li>
</ul>
@@ -8134,12 +8239,12 @@ python -c "import base64; print base64.s
<p><code class="highlighter-rouge">GET /kylin/api/cube_desc/{cubeName}</code><br />
Get descriptor for specified cube instance.</p>
-<h4 id="path-variable-1">Path Variable</h4>
+<h4 id="path-variable-3">Path Variable</h4>
<ul>
<li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name.</li>
</ul>
-<h4 id="response-sample-5">Response Sample</h4>
+<h4 id="response-sample-7">Response Sample</h4>
<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">[</span>
<span class="o">{</span>
<span class="s2">"uuid"</span>: <span class="s2">"0ef9b7a8-3929-4dff-b59d-2100aadc8dbf"</span>,
@@ -8582,12 +8687,12 @@ Get descriptor for specified cube instan
<h2 id="get-data-model">Get data model</h2>
<p><code class="highlighter-rouge">GET /kylin/api/model/{modelName}</code></p>
-<h4 id="path-variable-2">Path Variable</h4>
+<h4 id="path-variable-4">Path Variable</h4>
<ul>
<li>modelName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Data model name, by default it should be the same with cube name.</li>
</ul>
-<h4 id="response-sample-6">Response Sample</h4>
+<h4 id="response-sample-8">Response Sample</h4>
<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
<span class="s2">"uuid"</span>: <span class="s2">"ff527b94-f860-44c3-8452-93b17774c647"</span>,
<span class="s2">"name"</span>: <span class="s2">"test_kylin_with_slr_model_desc"</span>,
@@ -8637,12 +8742,12 @@ Get descriptor for specified cube instan
<h2 id="build-cube">Build cube</h2>
<p><code class="highlighter-rouge">PUT /kylin/api/cubes/{cubeName}/build</code></p>
-<h4 id="path-variable-3">Path Variable</h4>
+<h4 id="path-variable-5">Path Variable</h4>
<ul>
<li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name.</li>
</ul>
-<h4 id="request-body-2">Request Body</h4>
+<h4 id="request-body-5">Request Body</h4>
<ul>
<li>startTime - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">long</code> Start timestamp of data to build, e.g. 1388563200000 for 2014-1-1</li>
<li>endTime - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">long</code> End timestamp of data to build</li>
@@ -8654,7 +8759,7 @@ Get descriptor for specified cube instan
</code></pre>
</div>
-<h4 id="response-sample-7">Response Sample</h4>
+<h4 id="response-sample-9">Response Sample</h4>
<div class="highlighter-rouge"><pre class="highlight"><code><span class="p">{</span><span class="w">
</span><span class="nt">"uuid"</span><span class="p">:</span><span class="s2">"c143e0e4-ac5f-434d-acf3-46b0d15e3dc6"</span><span class="p">,</span><span class="w">
</span><span class="nt">"last_modified"</span><span class="p">:</span><span class="mi">1407908916705</span><span class="p">,</span><span class="w">
@@ -8719,12 +8824,12 @@ Get descriptor for specified cube instan
<h2 id="enable-cube">Enable Cube</h2>
<p><code class="highlighter-rouge">PUT /kylin/api/cubes/{cubeName}/enable</code></p>
-<h4 id="path-variable-4">Path variable</h4>
+<h4 id="path-variable-6">Path variable</h4>
<ul>
<li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name.</li>
</ul>
-<h4 id="response-sample-8">Response Sample</h4>
+<h4 id="response-sample-10">Response Sample</h4>
<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
<span class="s2">"uuid"</span>:<span class="s2">"1eaca32a-a33e-4b69-83dd-0bb8b1f8c53b"</span>,
<span class="s2">"last_modified"</span>:1407909046305,
@@ -8775,23 +8880,23 @@ Get descriptor for specified cube instan
<h2 id="disable-cube">Disable Cube</h2>
<p><code class="highlighter-rouge">PUT /kylin/api/cubes/{cubeName}/disable</code></p>
-<h4 id="path-variable-5">Path variable</h4>
+<h4 id="path-variable-7">Path variable</h4>
<ul>
<li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name.</li>
</ul>
-<h4 id="response-sample-9">Response Sample</h4>
+<h4 id="response-sample-11">Response Sample</h4>
<p>(Same as âEnable Cubeâ)</p>
<h2 id="purge-cube">Purge Cube</h2>
<p><code class="highlighter-rouge">PUT /kylin/api/cubes/{cubeName}/purge</code></p>
-<h4 id="path-variable-6">Path variable</h4>
+<h4 id="path-variable-8">Path variable</h4>
<ul>
<li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name.</li>
</ul>
-<h4 id="response-sample-10">Response Sample</h4>
+<h4 id="response-sample-12">Response Sample</h4>
<p>(Same as âEnable Cubeâ)</p>
<h2 id="delete-segment">Delete Segment</h2>
@@ -8800,45 +8905,125 @@ Get descriptor for specified cube instan
<h2 id="auto-merge-segment">Auto-merge Segment</h2>
<p><code class="highlighter-rouge">PUT /kylin/api/cubes/{cubeName}/automerge</code></p>
+<h2 id="get-sql-of-a-cube">Get sql of a cube</h2>
+<p><code class="highlighter-rouge">GET /kylin/api/cubes/{cubeName}/sql</code></p>
+
+<h4 id="path-variable-9">Path variable</h4>
+<ul>
+ <li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name.</li>
+</ul>
+
+<h4 id="response-sample-13">Response Sample</h4>
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
+ <span class="s2">"sql"</span>: <span class="s2">"SELECT</span><span class="se">\n</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>TRANS_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_TRANS_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>PART_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_PART_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>YEAR_BEG_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT_YEAR_BEG_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</
span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>MONTH_BEG_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT_MONTH_BEG_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>WEEK_BEG_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT_WEEK_BEG_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LEAF_CATEG_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_LEAF_CATEG_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span
>LSTG_SITE_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_LSTG_SITE_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>USER_DEFINED_FIELD1<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_USER_DEFINED_FIELD1<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>USER_DEFINED_FIELD3<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_USER_DEFINED_FIELD3<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>
META_CATEG_NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_META_CATEG_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>CATEG_LVL2_NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_CATEG_LVL2_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>CATEG_LVL3_NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_CATEG_LVL3_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LSTG_FORMAT
_NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_LSTG_FORMAT_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>SELLER_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_SELLER_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>BUYER_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_BUYER_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_BUYER_LEVEL<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_ACCOUN
T_ACCOUNT_BUYER_LEVEL<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_SELLER_LEVEL<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_ACCOUNT_ACCOUNT_SELLER_LEVEL<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_ACCOUNT_ACCOUNT_COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_ACCOUNT_ACCOUNT_COUNTRY<span class="sb">`</span><spa
n class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_COUNTRY_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_COUNTRY_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>OPS_USER_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_OPS_USER_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span clas
s="s2">.</span><span class="sb">`</span>OPS_REGION<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_OPS_REGION<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>CAL_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT_CAL_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LEAF_CATEG_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_LEAF_CATEG_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>SITE_ID<span class="sb">`</
span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_SITE_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_ACCOUNT_ACCOUNT_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_ACCOUNT_ACCOUNT_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_COUNTRY_COUNTRY<span cl
ass="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_COUNTRY_COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>PRICE<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_PRICE<span class="sb">`</span><span class="se">\n</span><span class="s2"> FROM </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb
">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>PART_DT<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>CAL_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class
="s2">.</span><span class="sb">`</span>LEAF_CATEG_ID<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LEAF_CATEG_ID<span class="sb">`</span><span class="s2"> AND </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LSTG_SITE_ID<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>SITE_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_ACCOUNT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</s
pan>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>BUYER_ID<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_ACCOUNT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>SELLER_ID<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_ID<span class="sb">`</span><span class="se">\n</span><
span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_COUNTRY<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>BUYER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </spa
n><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_COUNTRY<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>SELLER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">WHERE 1=1"</span>
+<span class="o">}</span>
+</code></pre>
+</div>
+
+<h2 id="get-sql-of-a-cube-segment">Get sql of a cube segment</h2>
+<p><code class="highlighter-rouge">GET /kylin/api/cubes/{cubeName}/segs/{segmentName}/sql</code></p>
+
+<h4 id="path-variable-10">Path variable</h4>
+<ul>
+ <li>cubeName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Cube name.</li>
+ <li>segmentName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> Segment name.</li>
+</ul>
+
+<h4 id="response-sample-14">Response Sample</h4>
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
+ <span class="s2">"sql"</span>: <span class="s2">"SELECT</span><span class="se">\n</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>TRANS_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_TRANS_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>PART_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_PART_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>YEAR_BEG_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT_YEAR_BEG_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</
span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>MONTH_BEG_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT_MONTH_BEG_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>WEEK_BEG_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT_WEEK_BEG_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LEAF_CATEG_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_LEAF_CATEG_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span
>LSTG_SITE_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_LSTG_SITE_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>USER_DEFINED_FIELD1<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_USER_DEFINED_FIELD1<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>USER_DEFINED_FIELD3<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_USER_DEFINED_FIELD3<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>
META_CATEG_NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_META_CATEG_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>CATEG_LVL2_NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_CATEG_LVL2_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>CATEG_LVL3_NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_CATEG_LVL3_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LSTG_FORMAT
_NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_LSTG_FORMAT_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>SELLER_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_SELLER_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>BUYER_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_BUYER_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_BUYER_LEVEL<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_ACCOUN
T_ACCOUNT_BUYER_LEVEL<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_SELLER_LEVEL<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_ACCOUNT_ACCOUNT_SELLER_LEVEL<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_ACCOUNT_ACCOUNT_COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_ACCOUNT_ACCOUNT_COUNTRY<span class="sb">`</span><spa
n class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_COUNTRY_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>NAME<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_COUNTRY_NAME<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>OPS_USER_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_OPS_USER_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span clas
s="s2">.</span><span class="sb">`</span>OPS_REGION<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_OPS_REGION<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>CAL_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT_CAL_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LEAF_CATEG_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_LEAF_CATEG_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>SITE_ID<span class="sb">`</
span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS_SITE_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_ACCOUNT_ACCOUNT_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_ID<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_ACCOUNT_ACCOUNT_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>BUYER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_COUNTRY_COUNTRY<span cl
ass="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>SELLER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_COUNTRY_COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">,</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>PRICE<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES_PRICE<span class="sb">`</span><span class="se">\n</span><span class="s2"> FROM </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb
">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>PART_DT<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>KYLIN_CAL_DT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>CAL_DT<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class
="s2">.</span><span class="sb">`</span>LEAF_CATEG_ID<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LEAF_CATEG_ID<span class="sb">`</span><span class="s2"> AND </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>LSTG_SITE_ID<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>KYLIN_CATEGORY_GROUPINGS<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>SITE_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_ACCOUNT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</s
pan>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>BUYER_ID<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_ID<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_ACCOUNT<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>SELLER_ID<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_ID<span class="sb">`</span><span class="se">\n</span><
span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>BUYER_COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </span><span class="sb">`</span>BUYER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_COUNTRY<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>BUYER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">INNER JOIN </span><span class="sb">`</span>DEFAULT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>KYLIN_COUNTRY<span class="sb">`</span><span class="s2"> as </span><span class="sb">`</span>SELLER_COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">ON </spa
n><span class="sb">`</span>SELLER_ACCOUNT<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>ACCOUNT_COUNTRY<span class="sb">`</span><span class="s2"> = </span><span class="sb">`</span>SELLER_COUNTRY<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>COUNTRY<span class="sb">`</span><span class="se">\n</span><span class="s2">WHERE 1=1 AND (</span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>PART_DT<span class="sb">`</span><span class="s2"> >= '2012-01-01' AND </span><span class="sb">`</span>KYLIN_SALES<span class="sb">`</span><span class="s2">.</span><span class="sb">`</span>PART_DT<span class="sb">`</span><span class="s2"> < '2012-01-03')</span><span class="se">\n</span><span class="s2">"</span>
+<span class="o">}</span>
+</code></pre>
+</div>
+
+<h2 id="force-rebuild-lookup-table-snapshot">Force rebuild lookup table snapshot</h2>
+<p><code class="highlighter-rouge">PUT /kylin/api/cubes/{cubeName}/refresh_lookup</code></p>
+
+<h2 id="clone-cube">Clone cube</h2>
+<p><code class="highlighter-rouge">PUT /kylin/api/cubes/{cubeName}/clone</code></p>
+
+<h2 id="delete-cube">Delete cube</h2>
+<p><code class="highlighter-rouge">DELETE /kylin/api/cubes/{cubeName}</code></p>
+
+<h2 id="get-hbase-info">Get hbase info</h2>
+<p><code class="highlighter-rouge">GET /kylin/api/cubes/{cubeName}/hbase</code></p>
+
+<h4 id="response-sample-15">Response Sample</h4>
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">[</span>
+ <span class="o">{</span>
+ <span class="s2">"segmentName"</span>: <span class="s2">"20120101000000_20120103000000"</span>,
+ <span class="s2">"segmentUUID"</span>: null,
+ <span class="s2">"segmentStatus"</span>: <span class="s2">"READY"</span>,
+ <span class="s2">"tableName"</span>: <span class="s2">"KYLIN_E1VT22737D"</span>,
+ <span class="s2">"tableSize"</span>: 0,
+ <span class="s2">"regionCount"</span>: 1,
+ <span class="s2">"dateRangeStart"</span>: 1325376000000,
+ <span class="s2">"dateRangeEnd"</span>: 1325548800000,
+ <span class="s2">"sourceOffsetStart"</span>: 0,
+ <span class="s2">"sourceOffsetEnd"</span>: 0,
+ <span class="s2">"sourceCount"</span>: 29
+ <span class="o">}</span>
+<span class="o">]</span>
+</code></pre>
+</div>
+
+<h2 id="get-current-cuboid">Get current cuboid</h2>
+<p><code class="highlighter-rouge">GET /kylin/api/cubes/{cubeName}/cuboids/current</code></p>
+
+<h2 id="migrate-cube">Migrate Cube</h2>
+<p><code class="highlighter-rouge">POST /kylin/api/cubes/{cube}/{project}/migrate</code></p>
+
<hr />
<h2 id="create-model">Create Model</h2>
<p><code class="highlighter-rouge">POST /kylin/api/models</code></p>
-<h4 id="request-body-3">Request Body</h4>
+<h4 id="request-body-6">Request Body</h4>
<ul>
<li>modelDescData - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> modelDescData to create</li>
<li>modelName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> modelName to create</li>
<li>projectName - <code class="highlighter-rouge">required</code> <code class="highlighter-rouge">string</code> projectName to which model belongs</li>
</ul>
-<h4 id="request-sample-2">Request Sample</h4>
-<div class="highlighter-rouge"><pre class="highlight"><code><span class="p">{</span><span class="w">
-</span><span class="nt">"modelDescData"</span><span class="p">:</span><span class="w"> </span><span class="s2">"{\"uuid\": \"0928468a-9fab-4185-9a14-6f2e7c74823f\",\"last_modified\": 0,\"version\": \"3.0.0.20500\",\"name\": \"kylin_test_model\",\"owner\": null,\"is_draft\": false,\"description\": \"\",\"fact_table\": \"DEFAULT.KYLIN_SALES\",\"lookups\": [{\"table\": \"DEFAULT.KYLIN_CAL_DT\",\"kind\": \"LOOKUP\",\"alias\": \"KYLIN_CAL_DT\",\"join\": {\"type\": \"inner\",\"primary_key\": [\"KYLIN_CAL_DT.CAL_DT\"],\"foreign_key\": [\"KYLIN_SALES.PART_DT\"]}},{\"table\": \"DEFAULT.KYLIN_CATEGORY_GROUPINGS\",\"kind\": \"LOOKUP\",\"alias\": \"KYLIN_CATEGORY_GROUPINGS\",\"join\": {\"type\": \"inner\",\"primary_key\": [\"KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID\",\"KYLIN_CATEGORY_GROUPINGS.SITE_ID\"],\"foreign_key\": [\"KYLIN_SALES.LEAF_CATEG_ID\",\"KYLIN_SALES.LSTG_SITE_ID\"]}},{\"table\": \"DEFAULT.KYLIN_ACCOUNT\",\"kind\": \"LOOKUP\",\"alias\": \"BUYER_ACCOUNT\",\"join\": {\"type\": \"inne
r\",\"primary_key\": [\"BUYER_ACCOUNT.ACCOUNT_ID\"],\"foreign_key\": [\"KYLIN_SALES.BUYER_ID\"]}},{\"table\": \"DEFAULT.KYLIN_ACCOUNT\",\"kind\": \"LOOKUP\",\"alias\": \"SELLER_ACCOUNT\",\"join\": {\"type\": \"inner\",\"primary_key\": [\"SELLER_ACCOUNT.ACCOUNT_ID\"],\"foreign_key\": [\"KYLIN_SALES.SELLER_ID\"]}},{\"table\": \"DEFAULT.KYLIN_COUNTRY\",\"kind\": \"LOOKUP\",\"alias\": \"BUYER_COUNTRY\",\"join\": {\"type\": \"inner\",\"primary_key\": [\"BUYER_COUNTRY.COUNTRY\"],\"foreign_key\": [\"BUYER_ACCOUNT.ACCOUNT_COUNTRY\"]}},{\"table\": \"DEFAULT.KYLIN_COUNTRY\",\"kind\": \"LOOKUP\",\"alias\": \"SELLER_COUNTRY\",\"join\": {\"type\": \"inner\",\"primary_key\": [\"SELLER_COUNTRY.COUNTRY\"],\"foreign_key\": [\"SELLER_ACCOUNT.ACCOUNT_COUNTRY\"]}}],\"dimensions\": [{\"table\": \"KYLIN_SALES\",\"columns\": [\"TRANS_ID\",\"SELLER_ID\",\"BUYER_ID\",\"PART_DT\",\"LEAF_CATEG_ID\",\"LSTG_FORMAT_NAME\",\"LSTG_SITE_ID\",\"OPS_USER_ID\",\"OPS_REGION\"]},{\"table\": \"KYLIN_CAL_DT\",\"columns\":
[\"CAL_DT\",\"WEEK_BEG_DT\",\"MONTH_BEG_DT\",\"YEAR_BEG_DT\"]},{\"table\": \"KYLIN_CATEGORY_GROUPINGS\",\"columns\": [\"USER_DEFINED_FIELD1\",\"USER_DEFINED_FIELD3\",\"META_CATEG_NAME\",\"CATEG_LVL2_NAME\",\"CATEG_LVL3_NAME\",\"LEAF_CATEG_ID\",\"SITE_ID\"]},{\"table\": \"BUYER_ACCOUNT\",\"columns\": [\"ACCOUNT_ID\",\"ACCOUNT_BUYER_LEVEL\",\"ACCOUNT_SELLER_LEVEL\",\"ACCOUNT_COUNTRY\",\"ACCOUNT_CONTACT\"]},{\"table\": \"SELLER_ACCOUNT\",\"columns\": [\"ACCOUNT_ID\",\"ACCOUNT_BUYER_LEVEL\",\"ACCOUNT_SELLER_LEVEL\",\"ACCOUNT_COUNTRY\",\"ACCOUNT_CONTACT\"]},{\"table\": \"BUYER_COUNTRY\",\"columns\": [\"COUNTRY\",\"NAME\"]},{\"table\": \"SELLER_COUNTRY\",\"columns\": [\"COUNTRY\",\"NAME\"]}],\"metrics\": [\"KYLIN_SALES.PRICE\",\"KYLIN_SALES.ITEM_COUNT\"],\"filter_condition\": \"\",\"partition_desc\": {\"partition_date_column\": \"KYLIN_SALES.PART_DT\",\"partition_time_column\": null,\"partition_date_start\": 1325376000000,\"partition_date_format\": \"yyyy-MM-dd\",\"partition_time_format\
": \"HH:mm:ss\",\"partition_type\": \"APPEND\",\"partition_condition_builder\": \"org.apache.kylin.metadata.model.PartitionDesc$DefaultPartitionConditionBuilder\"},\"capacity\": \"MEDIUM\"}"</span><span class="p">,</span><span class="w">
-</span><span class="nt">"modelName"</span><span class="p">:</span><span class="w"> </span><span class="s2">"kylin_test_model"</span><span class="p">,</span><span class="w">
-</span><span class="nt">"project"</span><span class="p">:</span><span class="w"> </span><span class="s2">"learn_kylin"</span><span class="w">
-</span><span class="p">}</span><span class="w">
-</span></code></pre>
+<h4 id="request-sample-5">Request Sample</h4>
+<div class="highlighter-rouge"><pre class="highlight"><code><span class="o">{</span>
+<span class="s2">"modelDescData"</span>: <span class="s2">"{</span><span class="se">\"</span><span class="s2">uuid</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">0928468a-9fab-4185-9a14-6f2e7c74823f</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">last_modified</span><span class="se">\"</span><span class="s2">: 0,</span><span class="se">\"</span><span class="s2">version</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">3.0.0.20500</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">name</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">kylin_test_model</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">owner</span><span class="se">\"</span><span class="s2">: null,</span><span class="s
e">\"</span><span class="s2">is_draft</span><span class="se">\"</span><span class="s2">: false,</span><span class="se">\"</span><span class="s2">description</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">fact_table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">DEFAULT.KYLIN_SALES</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">lookups</span><span class="se">\"</span><span class="s2">: [{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">DEFAULT.KYLIN_CAL_DT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">kind</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">LOOKUP</s
pan><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">alias</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">KYLIN_CAL_DT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">join</span><span class="se">\"</span><span class="s2">: {</span><span class="se">\"</span><span class="s2">type</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">inner</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">primary_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">KYLIN_CAL_DT.CAL_DT</span><span class="se">\"</span><span class="s2">],</span><span class="se">\"</span><span class="s2">foreign_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">KYLIN_SALES
.PART_DT</span><span class="se">\"</span><span class="s2">]}},{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">DEFAULT.KYLIN_CATEGORY_GROUPINGS</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">kind</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">LOOKUP</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">alias</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">KYLIN_CATEGORY_GROUPINGS</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">join</span><span class="se">\"</span><span class="s2">: {</span><span class="se">\"</span><span class="s2">type</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><sp
an class="s2">inner</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">primary_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">KYLIN_CATEGORY_GROUPINGS.LEAF_CATEG_ID</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">KYLIN_CATEGORY_GROUPINGS.SITE_ID</span><span class="se">\"</span><span class="s2">],</span><span class="se">\"</span><span class="s2">foreign_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">KYLIN_SALES.LEAF_CATEG_ID</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">KYLIN_SALES.LSTG_SITE_ID</span><span class="se">\"</span><span class="s2">]}},{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">DEFAULT.KYLIN_
ACCOUNT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">kind</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">LOOKUP</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">alias</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">BUYER_ACCOUNT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">join</span><span class="se">\"</span><span class="s2">: {</span><span class="se">\"</span><span class="s2">type</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">inner</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">primary_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">BUYER_ACCOUNT.ACCOUNT_
ID</span><span class="se">\"</span><span class="s2">],</span><span class="se">\"</span><span class="s2">foreign_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">KYLIN_SALES.BUYER_ID</span><span class="se">\"</span><span class="s2">]}},{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">DEFAULT.KYLIN_ACCOUNT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">kind</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">LOOKUP</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">alias</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">SELLER_ACCOUNT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span c
lass="s2">join</span><span class="se">\"</span><span class="s2">: {</span><span class="se">\"</span><span class="s2">type</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">inner</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">primary_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">SELLER_ACCOUNT.ACCOUNT_ID</span><span class="se">\"</span><span class="s2">],</span><span class="se">\"</span><span class="s2">foreign_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">KYLIN_SALES.SELLER_ID</span><span class="se">\"</span><span class="s2">]}},{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">DEFAULT.KYLIN_COUNTRY</span><span class="se">\"</span><span class="s2">,</span><
span class="se">\"</span><span class="s2">kind</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">LOOKUP</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">alias</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">BUYER_COUNTRY</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">join</span><span class="se">\"</span><span class="s2">: {</span><span class="se">\"</span><span class="s2">type</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">inner</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">primary_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">BUYER_COUNTRY.COUNTRY</span><span class="se">\"</span><span class="s2">],</span><span cl
ass="se">\"</span><span class="s2">foreign_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">BUYER_ACCOUNT.ACCOUNT_COUNTRY</span><span class="se">\"</span><span class="s2">]}},{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">DEFAULT.KYLIN_COUNTRY</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">kind</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">LOOKUP</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">alias</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">SELLER_COUNTRY</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">join</span><span class="se">\"</span><span class="
s2">: {</span><span class="se">\"</span><span class="s2">type</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">inner</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">primary_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">SELLER_COUNTRY.COUNTRY</span><span class="se">\"</span><span class="s2">],</span><span class="se">\"</span><span class="s2">foreign_key</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">SELLER_ACCOUNT.ACCOUNT_COUNTRY</span><span class="se">\"</span><span class="s2">]}}],</span><span class="se">\"</span><span class="s2">dimensions</span><span class="se">\"</span><span class="s2">: [{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">KYLIN_SALES</span><s
pan class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">columns</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">TRANS_ID</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">SELLER_ID</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">BUYER_ID</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">PART_DT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">LEAF_CATEG_ID</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">LSTG_FORMAT_NAME</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">LSTG_SITE_ID</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">OPS_USER_ID</sp
an><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">OPS_REGION</span><span class="se">\"</span><span class="s2">]},{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">KYLIN_CAL_DT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">columns</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">CAL_DT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">WEEK_BEG_DT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">MONTH_BEG_DT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">YEAR_BEG_DT</span><span class="se">\"</span><span class="s2">]},{</span><span class="se">\"</span><span class="s2">table</sp
an><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">KYLIN_CATEGORY_GROUPINGS</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">columns</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">USER_DEFINED_FIELD1</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">USER_DEFINED_FIELD3</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">META_CATEG_NAME</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">CATEG_LVL2_NAME</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">CATEG_LVL3_NAME</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">LEAF_CATEG_ID</span><span class="se">\"</span><span class="s2">,</span><span
class="se">\"</span><span class="s2">SITE_ID</span><span class="se">\"</span><span class="s2">]},{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">BUYER_ACCOUNT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">columns</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">ACCOUNT_ID</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">ACCOUNT_BUYER_LEVEL</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">ACCOUNT_SELLER_LEVEL</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">ACCOUNT_COUNTRY</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">ACCOUNT_CONTACT</span><span class="se">\"</span><
span class="s2">]},{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">SELLER_ACCOUNT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">columns</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">ACCOUNT_ID</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">ACCOUNT_BUYER_LEVEL</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">ACCOUNT_SELLER_LEVEL</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">ACCOUNT_COUNTRY</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">ACCOUNT_CONTACT</span><span class="se">\"</span><span class="s2">]},{</span><span class="se">\"</span><span class="s2">table</s
pan><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">BUYER_COUNTRY</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">columns</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">COUNTRY</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">NAME</span><span class="se">\"</span><span class="s2">]},{</span><span class="se">\"</span><span class="s2">table</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">SELLER_COUNTRY</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">columns</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">COUNTRY</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">NAME</span><span c
lass="se">\"</span><span class="s2">]}],</span><span class="se">\"</span><span class="s2">metrics</span><span class="se">\"</span><span class="s2">: [</span><span class="se">\"</span><span class="s2">KYLIN_SALES.PRICE</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">KYLIN_SALES.ITEM_COUNT</span><span class="se">\"</span><span class="s2">],</span><span class="se">\"</span><span class="s2">filter_condition</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">partition_desc</span><span class="se">\"</span><span class="s2">: {</span><span class="se">\"</span><span class="s2">partition_date_column</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">KYLIN_SALES.PART_DT</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">partition_time_column</s
pan><span class="se">\"</span><span class="s2">: null,</span><span class="se">\"</span><span class="s2">partition_date_start</span><span class="se">\"</span><span class="s2">: 1325376000000,</span><span class="se">\"</span><span class="s2">partition_date_format</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">yyyy-MM-dd</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">partition_time_format</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">HH:mm:ss</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">partition_type</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">APPEND</span><span class="se">\"</span><span class="s2">,</span><span class="se">\"</span><span class="s2">partition_condition_builder</span><span class="se">\"</span><span cl
ass="s2">: </span><span class="se">\"</span><span class="s2">org.apache.kylin.metadata.model.PartitionDesc</span><span class="nv">$DefaultPartitionConditionBuilder</span><span class="se">\"</span><span class="s2">},</span><span class="se">\"</span><span class="s2">capacity</span><span class="se">\"</span><span class="s2">: </span><span class="se">\"</span><span class="s2">MEDIUM</span><span class="se">\"</span><span class="s2">}"</span>,
+<span class="s2">"modelName"</span>: <span class="s2">"kylin_test_model"</span>,
+<span class="s2">"project"</span>: <span class="s2">"learn_kylin"</span>
+<span class="o">}</span>
+</code></pre>
</div>
-<h4 id="response-sample-11">Response Sample</h4>
-<div class="highlighter-rouge"><pre class="highlight"><code><span class="p">{</span><span class="w">
-</span><span class="nt">"uuid"</span><span class="p">:</span><span class="w"> </span><span class="s2">"2613d739-14c1-38ac-2e37-f36e46fd9976"</span><span class="p">,</span><span class="w">
-</span><span class="nt">"modelName"</span><span class="p">:</span><span class="w"> </span><span class="s2">"kylin_test_model"</span><span class="p">,</span><span class="w">
[... 524 lines stripped ...]
Modified: kylin/site/feed.xml
URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1878099&r1=1878098&r2=1878099&view=diff
==============================================================================
--- kylin/site/feed.xml (original)
+++ kylin/site/feed.xml Mon May 25 14:13:30 2020
@@ -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, 19 May 2020 18:45:22 -0700</pubDate>
- <lastBuildDate>Tue, 19 May 2020 18:45:22 -0700</lastBuildDate>
+ <pubDate>Mon, 25 May 2020 06:59:14 -0700</pubDate>
+ <lastBuildDate>Mon, 25 May 2020 06:59:14 -0700</lastBuildDate>
<generator>Jekyll v2.5.3</generator>
<item>