You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2020/01/21 14:15:08 UTC
svn commit: r1873012 [1/2] - in /kylin/site:
cn/docs/howto/howto_use_restapi.html docs/howto/howto_use_restapi.html
feed.xml
Author: lidong
Date: Tue Jan 21 14:15:08 2020
New Revision: 1873012
URL: http://svn.apache.org/viewvc?rev=1873012&view=rev
Log:
Update cubedesc
Modified:
kylin/site/cn/docs/howto/howto_use_restapi.html
kylin/site/docs/howto/howto_use_restapi.html
kylin/site/feed.xml
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=1873012&r1=1873011&r2=1873012&view=diff
==============================================================================
--- kylin/site/cn/docs/howto/howto_use_restapi.html (original)
+++ kylin/site/cn/docs/howto/howto_use_restapi.html Tue Jan 21 14:15:08 2020
@@ -594,252 +594,438 @@ Get descriptor for specified cube instan
<h4 id="response-sample-5">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">"a24ca905-1fc6-4f67-985c-38fa5aeafd92"</span>,
- <span class="s2">"name"</span>: <span class="s2">"test_kylin_cube_with_slr_desc"</span>,
- <span class="s2">"description"</span>: null,
+ <span class="s2">"uuid"</span>: <span class="s2">"0ef9b7a8-3929-4dff-b59d-2100aadc8dbf"</span>,
+ <span class="s2">"last_modified"</span>: 1574402902000,
+ <span class="s2">"version"</span>: <span class="s2">"3.0.0.20500"</span>,
+ <span class="s2">"name"</span>: <span class="s2">"kylin_sales_cube"</span>,
+ <span class="s2">"is_draft"</span>: <span class="nb">false</span>,
+ <span class="s2">"model_name"</span>: <span class="s2">"kylin_sales_model"</span>,
+ <span class="s2">"description"</span>: <span class="s2">""</span>,
+ <span class="s2">"null_string"</span>: null,
<span class="s2">"dimensions"</span>: <span class="o">[</span>
<span class="o">{</span>
- <span class="s2">"id"</span>: 0,
- <span class="s2">"name"</span>: <span class="s2">"CAL_DT"</span>,
- <span class="s2">"table"</span>: <span class="s2">"EDW.TEST_CAL_DT"</span>,
- <span class="s2">"column"</span>: null,
+ <span class="s2">"name"</span>: <span class="s2">"TRANS_ID"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"TRANS_ID"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"YEAR_BEG_DT"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_CAL_DT"</span>,
+ <span class="s2">"column"</span>: null,
<span class="s2">"derived"</span>: <span class="o">[</span>
- <span class="s2">"WEEK_BEG_DT"</span>
- <span class="o">]</span>,
- <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 1,
- <span class="s2">"name"</span>: <span class="s2">"CATEGORY"</span>,
- <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_CATEGORY_GROUPINGS"</span>,
- <span class="s2">"column"</span>: null,
+ <span class="s2">"YEAR_BEG_DT"</span>
+ <span class="o">]</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"MONTH_BEG_DT"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_CAL_DT"</span>,
+ <span class="s2">"column"</span>: null,
<span class="s2">"derived"</span>: <span class="o">[</span>
- <span class="s2">"USER_DEFINED_FIELD1"</span>,
- <span class="s2">"USER_DEFINED_FIELD3"</span>,
- <span class="s2">"UPD_DATE"</span>,
- <span class="s2">"UPD_USER"</span>
- <span class="o">]</span>,
- <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 2,
- <span class="s2">"name"</span>: <span class="s2">"CATEGORY_HIERARCHY"</span>,
- <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_CATEGORY_GROUPINGS"</span>,
- <span class="s2">"column"</span>: <span class="o">[</span>
- <span class="s2">"META_CATEG_NAME"</span>,
- <span class="s2">"CATEG_LVL2_NAME"</span>,
- <span class="s2">"CATEG_LVL3_NAME"</span>
- <span class="o">]</span>,
- <span class="s2">"derived"</span>: null,
- <span class="s2">"hierarchy"</span>: <span class="nb">true</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 3,
- <span class="s2">"name"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
- <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_KYLIN_FACT"</span>,
- <span class="s2">"column"</span>: <span class="o">[</span>
- <span class="s2">"LSTG_FORMAT_NAME"</span>
- <span class="o">]</span>,
- <span class="s2">"derived"</span>: null,
- <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 4,
- <span class="s2">"name"</span>: <span class="s2">"SITE_ID"</span>,
- <span class="s2">"table"</span>: <span class="s2">"EDW.TEST_SITES"</span>,
- <span class="s2">"column"</span>: null,
+ <span class="s2">"MONTH_BEG_DT"</span>
+ <span class="o">]</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"WEEK_BEG_DT"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_CAL_DT"</span>,
+ <span class="s2">"column"</span>: null,
<span class="s2">"derived"</span>: <span class="o">[</span>
- <span class="s2">"SITE_NAME"</span>,
- <span class="s2">"CRE_USER"</span>
- <span class="o">]</span>,
- <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 5,
- <span class="s2">"name"</span>: <span class="s2">"SELLER_TYPE_CD"</span>,
- <span class="s2">"table"</span>: <span class="s2">"EDW.TEST_SELLER_TYPE_DIM"</span>,
- <span class="s2">"column"</span>: null,
+ <span class="s2">"WEEK_BEG_DT"</span>
+ <span class="o">]</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"USER_DEFINED_FIELD1"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"column"</span>: null,
<span class="s2">"derived"</span>: <span class="o">[</span>
- <span class="s2">"SELLER_TYPE_DESC"</span>
- <span class="o">]</span>,
- <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 6,
- <span class="s2">"name"</span>: <span class="s2">"SELLER_ID"</span>,
- <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_KYLIN_FACT"</span>,
- <span class="s2">"column"</span>: <span class="o">[</span>
- <span class="s2">"SELLER_ID"</span>
- <span class="o">]</span>,
- <span class="s2">"derived"</span>: null,
- <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
+ <span class="s2">"USER_DEFINED_FIELD1"</span>
+ <span class="o">]</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"USER_DEFINED_FIELD3"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"column"</span>: null,
+ <span class="s2">"derived"</span>: <span class="o">[</span>
+ <span class="s2">"USER_DEFINED_FIELD3"</span>
+ <span class="o">]</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"META_CATEG_NAME"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"META_CATEG_NAME"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"CATEG_LVL2_NAME"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL2_NAME"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"CATEG_LVL3_NAME"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL3_NAME"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"SELLER_ID"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"SELLER_ID"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"BUYER_ID"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"BUYER_ID"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"ACCOUNT_BUYER_LEVEL"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"BUYER_ACCOUNT"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_BUYER_LEVEL"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"ACCOUNT_SELLER_LEVEL"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"SELLER_ACCOUNT"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_SELLER_LEVEL"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"BUYER_COUNTRY"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"BUYER_ACCOUNT"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_COUNTRY"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"SELLER_COUNTRY"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"SELLER_ACCOUNT"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_COUNTRY"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"BUYER_COUNTRY_NAME"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"BUYER_COUNTRY"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"NAME"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"SELLER_COUNTRY_NAME"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"SELLER_COUNTRY"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"NAME"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"OPS_USER_ID"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"OPS_USER_ID"</span>,
+ <span class="s2">"derived"</span>: null
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"OPS_REGION"</span>,
+ <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
+ <span class="s2">"column"</span>: <span class="s2">"OPS_REGION"</span>,
+ <span class="s2">"derived"</span>: null
<span class="o">}</span>
- <span class="o">]</span>,
+ <span class="o">]</span>,
<span class="s2">"measures"</span>: <span class="o">[</span>
<span class="o">{</span>
- <span class="s2">"id"</span>: 1,
- <span class="s2">"name"</span>: <span class="s2">"GMV_SUM"</span>,
+ <span class="s2">"name"</span>: <span class="s2">"GMV_SUM"</span>,
<span class="s2">"function"</span>: <span class="o">{</span>
- <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
+ <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
<span class="s2">"parameter"</span>: <span class="o">{</span>
- <span class="s2">"type"</span>: <span class="s2">"column"</span>,
- <span class="s2">"value"</span>: <span class="s2">"PRICE"</span>,
- <span class="s2">"next_parameter"</span>: null
- <span class="o">}</span>,
+ <span class="s2">"type"</span>: <span class="s2">"column"</span>,
+ <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.PRICE"</span>
+ <span class="o">}</span>,
<span class="s2">"returntype"</span>: <span class="s2">"decimal(19,4)"</span>
- <span class="o">}</span>,
- <span class="s2">"dependent_measure_ref"</span>: null
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 2,
- <span class="s2">"name"</span>: <span class="s2">"GMV_MIN"</span>,
- <span class="s2">"function"</span>: <span class="o">{</span>
- <span class="s2">"expression"</span>: <span class="s2">"MIN"</span>,
- <span class="s2">"parameter"</span>: <span class="o">{</span>
- <span class="s2">"type"</span>: <span class="s2">"column"</span>,
- <span class="s2">"value"</span>: <span class="s2">"PRICE"</span>,
- <span class="s2">"next_parameter"</span>: null
- <span class="o">}</span>,
- <span class="s2">"returntype"</span>: <span class="s2">"decimal(19,4)"</span>
- <span class="o">}</span>,
- <span class="s2">"dependent_measure_ref"</span>: null
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 3,
- <span class="s2">"name"</span>: <span class="s2">"GMV_MAX"</span>,
- <span class="s2">"function"</span>: <span class="o">{</span>
- <span class="s2">"expression"</span>: <span class="s2">"MAX"</span>,
- <span class="s2">"parameter"</span>: <span class="o">{</span>
- <span class="s2">"type"</span>: <span class="s2">"column"</span>,
- <span class="s2">"value"</span>: <span class="s2">"PRICE"</span>,
- <span class="s2">"next_parameter"</span>: null
- <span class="o">}</span>,
- <span class="s2">"returntype"</span>: <span class="s2">"decimal(19,4)"</span>
- <span class="o">}</span>,
- <span class="s2">"dependent_measure_ref"</span>: null
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 4,
- <span class="s2">"name"</span>: <span class="s2">"TRANS_CNT"</span>,
- <span class="s2">"function"</span>: <span class="o">{</span>
- <span class="s2">"expression"</span>: <span class="s2">"COUNT"</span>,
- <span class="s2">"parameter"</span>: <span class="o">{</span>
- <span class="s2">"type"</span>: <span class="s2">"constant"</span>,
- <span class="s2">"value"</span>: <span class="s2">"1"</span>,
- <span class="s2">"next_parameter"</span>: null
- <span class="o">}</span>,
+ <span class="o">}</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"BUYER_LEVEL_SUM"</span>,
+ <span class="s2">"function"</span>: <span class="o">{</span>
+ <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
+ <span class="s2">"parameter"</span>: <span class="o">{</span>
+ <span class="s2">"type"</span>: <span class="s2">"column"</span>,
+ <span class="s2">"value"</span>: <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>
+ <span class="o">}</span>,
<span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
- <span class="o">}</span>,
- <span class="s2">"dependent_measure_ref"</span>: null
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"id"</span>: 5,
- <span class="s2">"name"</span>: <span class="s2">"ITEM_COUNT_SUM"</span>,
- <span class="s2">"function"</span>: <span class="o">{</span>
- <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
- <span class="s2">"parameter"</span>: <span class="o">{</span>
- <span class="s2">"type"</span>: <span class="s2">"column"</span>,
- <span class="s2">"value"</span>: <span class="s2">"ITEM_COUNT"</span>,
- <span class="s2">"next_parameter"</span>: null
- <span class="o">}</span>,
+ <span class="o">}</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"SELLER_LEVEL_SUM"</span>,
+ <span class="s2">"function"</span>: <span class="o">{</span>
+ <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
+ <span class="s2">"parameter"</span>: <span class="o">{</span>
+ <span class="s2">"type"</span>: <span class="s2">"column"</span>,
+ <span class="s2">"value"</span>: <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>
+ <span class="o">}</span>,
<span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
- <span class="o">}</span>,
- <span class="s2">"dependent_measure_ref"</span>: null
+ <span class="o">}</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"TRANS_CNT"</span>,
+ <span class="s2">"function"</span>: <span class="o">{</span>
+ <span class="s2">"expression"</span>: <span class="s2">"COUNT"</span>,
+ <span class="s2">"parameter"</span>: <span class="o">{</span>
+ <span class="s2">"type"</span>: <span class="s2">"constant"</span>,
+ <span class="s2">"value"</span>: <span class="s2">"1"</span>
+ <span class="o">}</span>,
+ <span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
+ <span class="o">}</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"SELLER_CNT_HLL"</span>,
+ <span class="s2">"function"</span>: <span class="o">{</span>
+ <span class="s2">"expression"</span>: <span class="s2">"COUNT_DISTINCT"</span>,
+ <span class="s2">"parameter"</span>: <span class="o">{</span>
+ <span class="s2">"type"</span>: <span class="s2">"column"</span>,
+ <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.SELLER_ID"</span>
+ <span class="o">}</span>,
+ <span class="s2">"returntype"</span>: <span class="s2">"hllc(10)"</span>
+ <span class="o">}</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"TOP_SELLER"</span>,
+ <span class="s2">"function"</span>: <span class="o">{</span>
+ <span class="s2">"expression"</span>: <span class="s2">"TOP_N"</span>,
+ <span class="s2">"parameter"</span>: <span class="o">{</span>
+ <span class="s2">"type"</span>: <span class="s2">"column"</span>,
+ <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.PRICE"</span>,
+ <span class="s2">"next_parameter"</span>: <span class="o">{</span>
+ <span class="s2">"type"</span>: <span class="s2">"column"</span>,
+ <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.SELLER_ID"</span>
+ <span class="o">}</span>
+ <span class="o">}</span>,
+ <span class="s2">"returntype"</span>: <span class="s2">"topn(100)"</span>,
+ <span class="s2">"configuration"</span>: <span class="o">{</span>
+ <span class="s2">"topn.encoding.KYLIN_SALES.SELLER_ID"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"topn.encoding_version.KYLIN_SALES.SELLER_ID"</span>: <span class="s2">"1"</span>
+ <span class="o">}</span>
+ <span class="o">}</span>
<span class="o">}</span>
- <span class="o">]</span>,
+ <span class="o">]</span>,
<span class="s2">"rowkey"</span>: <span class="o">{</span>
<span class="s2">"rowkey_columns"</span>: <span class="o">[</span>
<span class="o">{</span>
- <span class="s2">"column"</span>: <span class="s2">"SELLER_ID"</span>,
- <span class="s2">"length"</span>: 18,
- <span class="s2">"dictionary"</span>: null,
- <span class="s2">"mandatory"</span>: <span class="nb">true</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"column"</span>: <span class="s2">"CAL_DT"</span>,
- <span class="s2">"length"</span>: 0,
- <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
- <span class="s2">"mandatory"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"column"</span>: <span class="s2">"LEAF_CATEG_ID"</span>,
- <span class="s2">"length"</span>: 0,
- <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
- <span class="s2">"mandatory"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"column"</span>: <span class="s2">"META_CATEG_NAME"</span>,
- <span class="s2">"length"</span>: 0,
- <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
- <span class="s2">"mandatory"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL2_NAME"</span>,
- <span class="s2">"length"</span>: 0,
- <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
- <span class="s2">"mandatory"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL3_NAME"</span>,
- <span class="s2">"length"</span>: 0,
- <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
- <span class="s2">"mandatory"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"column"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
- <span class="s2">"length"</span>: 12,
- <span class="s2">"dictionary"</span>: null,
- <span class="s2">"mandatory"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"column"</span>: <span class="s2">"LSTG_SITE_ID"</span>,
- <span class="s2">"length"</span>: 0,
- <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
- <span class="s2">"mandatory"</span>: <span class="nb">false</span>
- <span class="o">}</span>,
- <span class="o">{</span>
- <span class="s2">"column"</span>: <span class="s2">"SLR_SEGMENT_CD"</span>,
- <span class="s2">"length"</span>: 0,
- <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
- <span class="s2">"mandatory"</span>: <span class="nb">false</span>
- <span class="o">}</span>
- <span class="o">]</span>,
- <span class="s2">"aggregation_groups"</span>: <span class="o">[</span>
- <span class="o">[</span>
- <span class="s2">"LEAF_CATEG_ID"</span>,
- <span class="s2">"META_CATEG_NAME"</span>,
- <span class="s2">"CATEG_LVL2_NAME"</span>,
- <span class="s2">"CATEG_LVL3_NAME"</span>,
- <span class="s2">"CAL_DT"</span>
- <span class="o">]</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.BUYER_ID"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"integer:4"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.SELLER_ID"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"integer:4"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.TRANS_ID"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"integer:4"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.PART_DT"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"date"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.LEAF_CATEG_ID"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"BUYER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"SELLER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"BUYER_COUNTRY.NAME"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"SELLER_COUNTRY.NAME"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.LSTG_FORMAT_NAME"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.LSTG_SITE_ID"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.OPS_USER_ID"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.OPS_REGION"</span>,
+ <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
+ <span class="s2">"encoding_version"</span>: 1,
+ <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
+ <span class="o">}</span>
<span class="o">]</span>
- <span class="o">}</span>,
- <span class="s2">"signature"</span>: <span class="s2">"lsLAl2jL62ZApmOLZqWU3g=="</span>,
- <span class="s2">"last_modified"</span>: 1445850327000,
- <span class="s2">"model_name"</span>: <span class="s2">"test_kylin_with_slr_model_desc"</span>,
- <span class="s2">"null_string"</span>: null,
+ <span class="o">}</span>,
<span class="s2">"hbase_mapping"</span>: <span class="o">{</span>
<span class="s2">"column_family"</span>: <span class="o">[</span>
<span class="o">{</span>
- <span class="s2">"name"</span>: <span class="s2">"F1"</span>,
+ <span class="s2">"name"</span>: <span class="s2">"F1"</span>,
<span class="s2">"columns"</span>: <span class="o">[</span>
<span class="o">{</span>
- <span class="s2">"qualifier"</span>: <span class="s2">"M"</span>,
+ <span class="s2">"qualifier"</span>: <span class="s2">"M"</span>,
<span class="s2">"measure_refs"</span>: <span class="o">[</span>
- <span class="s2">"GMV_SUM"</span>,
- <span class="s2">"GMV_MIN"</span>,
- <span class="s2">"GMV_MAX"</span>,
- <span class="s2">"TRANS_CNT"</span>,
- <span class="s2">"ITEM_COUNT_SUM"</span>
+ <span class="s2">"GMV_SUM"</span>,
+ <span class="s2">"BUYER_LEVEL_SUM"</span>,
+ <span class="s2">"SELLER_LEVEL_SUM"</span>,
+ <span class="s2">"TRANS_CNT"</span>
+ <span class="o">]</span>
+ <span class="o">}</span>
+ <span class="o">]</span>
+ <span class="o">}</span>,
+ <span class="o">{</span>
+ <span class="s2">"name"</span>: <span class="s2">"F2"</span>,
+ <span class="s2">"columns"</span>: <span class="o">[</span>
+ <span class="o">{</span>
+ <span class="s2">"qualifier"</span>: <span class="s2">"M"</span>,
+ <span class="s2">"measure_refs"</span>: <span class="o">[</span>
+ <span class="s2">"SELLER_CNT_HLL"</span>,
+ <span class="s2">"TOP_SELLER"</span>
<span class="o">]</span>
<span class="o">}</span>
<span class="o">]</span>
<span class="o">}</span>
<span class="o">]</span>
- <span class="o">}</span>,
- <span class="s2">"notify_list"</span>: null,
- <span class="s2">"auto_merge_time_ranges"</span>: null,
- <span class="s2">"retention_range"</span>: 0
+ <span class="o">}</span>,
+ <span class="s2">"aggregation_groups"</span>: <span class="o">[</span>
+ <span class="o">{</span>
+ <span class="s2">"includes"</span>: <span class="o">[</span>
+ <span class="s2">"KYLIN_SALES.PART_DT"</span>,
+ <span class="s2">"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME"</span>,
+ <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME"</span>,
+ <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME"</span>,
+ <span class="s2">"KYLIN_SALES.LEAF_CATEG_ID"</span>,
+ <span class="s2">"KYLIN_SALES.LSTG_FORMAT_NAME"</span>,
+ <span class="s2">"KYLIN_SALES.LSTG_SITE_ID"</span>,
+ <span class="s2">"KYLIN_SALES.OPS_USER_ID"</span>,
+ <span class="s2">"KYLIN_SALES.OPS_REGION"</span>,
+ <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>,
+ <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>,
+ <span class="s2">"BUYER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
+ <span class="s2">"SELLER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
+ <span class="s2">"BUYER_COUNTRY.NAME"</span>,
+ <span class="s2">"SELLER_COUNTRY.NAME"</span>
+ <span class="o">]</span>,
+ <span class="s2">"select_rule"</span>: <span class="o">{</span>
+ <span class="s2">"hierarchy_dims"</span>: <span class="o">[</span>
+ <span class="o">[</span>
+ <span class="s2">"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME"</span>,
+ <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME"</span>,
+ <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME"</span>,
+ <span class="s2">"KYLIN_SALES.LEAF_CATEG_ID"</span>
+ <span class="o">]</span>
+ <span class="o">]</span>,
+ <span class="s2">"mandatory_dims"</span>: <span class="o">[</span>
+ <span class="s2">"KYLIN_SALES.PART_DT"</span>
+ <span class="o">]</span>,
+ <span class="s2">"joint_dims"</span>: <span class="o">[</span>
+ <span class="o">[</span>
+ <span class="s2">"BUYER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
+ <span class="s2">"BUYER_COUNTRY.NAME"</span>
+ <span class="o">]</span>,
+ <span class="o">[</span>
+ <span class="s2">"SELLER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
+ <span class="s2">"SELLER_COUNTRY.NAME"</span>
+ <span class="o">]</span>,
+ <span class="o">[</span>
+ <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>,
+ <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>
+ <span class="o">]</span>,
+ <span class="o">[</span>
+ <span class="s2">"KYLIN_SALES.LSTG_FORMAT_NAME"</span>,
+ <span class="s2">"KYLIN_SALES.LSTG_SITE_ID"</span>
+ <span class="o">]</span>,
+ <span class="o">[</span>
+ <span class="s2">"KYLIN_SALES.OPS_USER_ID"</span>,
+ <span class="s2">"KYLIN_SALES.OPS_REGION"</span>
+ <span class="o">]</span>
+ <span class="o">]</span>
+ <span class="o">}</span>
+ <span class="o">}</span>
+ <span class="o">]</span>,
+ <span class="s2">"signature"</span>: null,
+ <span class="s2">"notify_list"</span>: <span class="o">[]</span>,
+ <span class="s2">"status_need_notify"</span>: <span class="o">[]</span>,
+ <span class="s2">"partition_date_start"</span>: 1325376000000,
+ <span class="s2">"partition_date_end"</span>: 3153600000000,
+ <span class="s2">"auto_merge_time_ranges"</span>: <span class="o">[]</span>,
+ <span class="s2">"volatile_range"</span>: 0,
+ <span class="s2">"retention_range"</span>: 0,
+ <span class="s2">"engine_type"</span>: 2,
+ <span class="s2">"storage_type"</span>: 2,
+ <span class="s2">"override_kylin_properties"</span>: <span class="o">{</span>
+ <span class="s2">"kylin.cube.aggrgroup.is-mandatory-only-valid"</span>: <span class="s2">"true"</span>,
+ <span class="s2">"kylin.engine.spark.rdd-partition-cut-mb"</span>: <span class="s2">"500"</span>
+ <span class="o">}</span>,
+ <span class="s2">"cuboid_black_list"</span>: <span class="o">[]</span>,
+ <span class="s2">"parent_forward"</span>: 3,
+ <span class="s2">"mandatory_dimension_set_list"</span>: <span class="o">[]</span>,
+ <span class="s2">"snapshot_table_desc_list"</span>: <span class="o">[]</span>
<span class="o">}</span>
<span class="o">]</span>
</code></pre>