Modified: kylin/site/docs/howto/howto_use_restapi.html URL: http://svn.apache.org/viewvc/kylin/site/docs/howto/howto_use_restapi.html?rev=1873012&r1=1873011&r2=1873012&view=diff ============================================================================== --- kylin/site/docs/howto/howto_use_restapi.html (original) +++ kylin/site/docs/howto/howto_use_restapi.html Tue Jan 21 14:15:08 2020 @@ -7461,252 +7461,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>
Modified: kylin/site/feed.xml URL: http://svn.apache.org/viewvc/kylin/site/feed.xml?rev=1873012&r1=1873011&r2=1873012&view=diff ============================================================================== --- kylin/site/feed.xml (original) +++ kylin/site/feed.xml Tue Jan 21 14:15:08 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, 14 Jan 2020 05:59:14 -0800</pubDate> - <lastBuildDate>Tue, 14 Jan 2020 05:59:14 -0800</lastBuildDate> + <pubDate>Tue, 21 Jan 2020 05:59:15 -0800</pubDate> + <lastBuildDate>Tue, 21 Jan 2020 05:59:15 -0800</lastBuildDate> <generator>Jekyll v2.5.3</generator> <item>