svn commit: r1878099 [2/3] - in /kylin/site: cn/docs/howto/howto_use_restapi.html docs/howto/howto_use_restapi.html feed.xml

Mon, 25 May 2020 07:52:33 -0700 


Modified: kylin/site/cn/docs/howto/howto_use_restapi.html
URL: 
http://svn.apache.org/viewvc/kylin/site/cn/docs/howto/howto_use_restapi.html?rev=1878099&r1=1878098&r2=1878099&view=diff
==============================================================================
--- kylin/site/cn/docs/howto/howto_use_restapi.html (original)
+++ kylin/site/cn/docs/howto/howto_use_restapi.html Mon May 25 14:13:30 2020
@@ -178,78 +178,81 @@ var _hmt = _hmt || [];
                                                <div id="pjax">
                                                        <h1 
class="post-title">RESTful API</h1>
                                                        <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>
@@ -269,23 +272,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>
@@ -435,15 +448,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>:[  
@@ -518,14 +611,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">
@@ -534,7 +627,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">
@@ -549,6 +642,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>
 
@@ -560,7 +665,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>,
@@ -585,7 +690,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>
@@ -594,12 +699,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>,
@@ -1042,12 +1147,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>, 
@@ -1097,12 +1202,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>
@@ -1114,7 +1219,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">
@@ -1179,12 +1284,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,
@@ -1235,23 +1340,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>
@@ -1260,28 +1365,96 @@ 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"> &gt;= '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"> &lt; '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>
+<h4 id="response-sample-16">Response Sample</h4>
 <div class="highlighter-rouge"><pre class="highlight"><code><span 
class="o">{</span>
 <span class="s2">"uuid"</span>: <span 
class="s2">"2613d739-14c1-38ac-2e37-f36e46fd9976"</span>,
 <span class="s2">"modelName"</span>: <span 
class="s2">"kylin_test_model"</span>,
@@ -1295,6 +1468,18 @@ Get descriptor for specified cube instan
 </code></pre>
 </div>
 
+<h2 id="update-model">Update Model</h2>
+<p><code class="highlighter-rouge">PUT /kylin/api/models</code></p>
+
+<h4 id="request-body-7">Request Body</h4>
+<p>(Same as “Create Model”)</p>
+
+<h4 id="request-sample-6">Request Sample</h4>
+<p>(Same as “Create Model”)</p>
+
+<h4 id="response-sample-17">Response Sample</h4>
+<p>(Same as “Create Model”)</p>
+
 <h2 id="get-modeldescdata">Get ModelDescData</h2>
 <p><code class="highlighter-rouge">GET /kylin/api/models</code></p>
 
@@ -1306,7 +1491,7 @@ Get descriptor for specified cube instan
   <li>offset - <code class="highlighter-rouge">optional</code> <code 
class="highlighter-rouge">integer</code> Models per page</li>
 </ul>
 
-<h4 id="response-sample-12">Response Sample</h4>
+<h4 id="response-sample-18">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">"0928468a-9fab-4185-9a14-6f2e7c74823f"</span>,
@@ -1499,22 +1684,25 @@ Get descriptor for specified cube instan
 <h2 id="delete-model">Delete Model</h2>
 <p><code class="highlighter-rouge">DELETE 
/kylin/api/models/{modelName}</code></p>
 
-<h4 id="path-variable-7">Path variable</h4>
+<h4 id="path-variable-11">Path variable</h4>
 <ul>
   <li>modelName - <code class="highlighter-rouge">required</code> <code 
class="highlighter-rouge">string</code> Model name.</li>
 </ul>
 
+<h2 id="clone-model">Clone Model</h2>

[... 461 lines stripped ...]

Reply via email to