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>