unstick r1873012

Revision 1873012

Date:
2020/01/21 14:15:08
Author:
lidong
Revision Log:
Update cubedesc
Files:

Legend:

 
Added
 
Removed
 
Modified
  • kylin/site/cn/docs/howto/howto_use_restapi.html

     
    594 594 <h4 id="response-sample-5">Response Sample</h4>
    595 595 <div class="highlighter-rouge"><pre class="highlight"><code><span class="o">[</span>
    596 596 <span class="o">{</span>
    597 <span class="s2">"uuid"</span>: <span class="s2">"a24ca905-1fc6-4f67-985c-38fa5aeafd92"</span>,
    598 <span class="s2">"name"</span>: <span class="s2">"test_kylin_cube_with_slr_desc"</span>,
    599 <span class="s2">"description"</span>: null,
    597 <span class="s2">"uuid"</span>: <span class="s2">"0ef9b7a8-3929-4dff-b59d-2100aadc8dbf"</span>,
    598 <span class="s2">"last_modified"</span>: 1574402902000,
    599 <span class="s2">"version"</span>: <span class="s2">"3.0.0.20500"</span>,
    600 <span class="s2">"name"</span>: <span class="s2">"kylin_sales_cube"</span>,
    601 <span class="s2">"is_draft"</span>: <span class="nb">false</span>,
    602 <span class="s2">"model_name"</span>: <span class="s2">"kylin_sales_model"</span>,
    603 <span class="s2">"description"</span>: <span class="s2">""</span>,
    604 <span class="s2">"null_string"</span>: null,
    600 605 <span class="s2">"dimensions"</span>: <span class="o">[</span>
    601 606 <span class="o">{</span>
    602 <span class="s2">"id"</span>: 0,
    603 <span class="s2">"name"</span>: <span class="s2">"CAL_DT"</span>,
    604 <span class="s2">"table"</span>: <span class="s2">"EDW.TEST_CAL_DT"</span>,
    605 <span class="s2">"column"</span>: null,
    607 <span class="s2">"name"</span>: <span class="s2">"TRANS_ID"</span>,
    608 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    609 <span class="s2">"column"</span>: <span class="s2">"TRANS_ID"</span>,
    610 <span class="s2">"derived"</span>: null
    611 <span class="o">}</span>,
    612 <span class="o">{</span>
    613 <span class="s2">"name"</span>: <span class="s2">"YEAR_BEG_DT"</span>,
    614 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CAL_DT"</span>,
    615 <span class="s2">"column"</span>: null,
    606 616 <span class="s2">"derived"</span>: <span class="o">[</span>
    607 <span class="s2">"WEEK_BEG_DT"</span>
    608 <span class="o">]</span>,
    609 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    610 <span class="o">}</span>,
    617 <span class="s2">"YEAR_BEG_DT"</span>
    618 <span class="o">]</span>
    619 <span class="o">}</span>,
    611 620 <span class="o">{</span>
    612 <span class="s2">"id"</span>: 1,
    613 <span class="s2">"name"</span>: <span class="s2">"CATEGORY"</span>,
    614 <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_CATEGORY_GROUPINGS"</span>,
    615 <span class="s2">"column"</span>: null,
    621 <span class="s2">"name"</span>: <span class="s2">"MONTH_BEG_DT"</span>,
    622 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CAL_DT"</span>,
    623 <span class="s2">"column"</span>: null,
    616 624 <span class="s2">"derived"</span>: <span class="o">[</span>
    617 <span class="s2">"USER_DEFINED_FIELD1"</span>,
    618 <span class="s2">"USER_DEFINED_FIELD3"</span>,
    619 <span class="s2">"UPD_DATE"</span>,
    620 <span class="s2">"UPD_USER"</span>
    621 <span class="o">]</span>,
    622 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    623 <span class="o">}</span>,
    625 <span class="s2">"MONTH_BEG_DT"</span>
    626 <span class="o">]</span>
    627 <span class="o">}</span>,
    624 628 <span class="o">{</span>
    625 <span class="s2">"id"</span>: 2,
    626 <span class="s2">"name"</span>: <span class="s2">"CATEGORY_HIERARCHY"</span>,
    627 <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_CATEGORY_GROUPINGS"</span>,
    628 <span class="s2">"column"</span>: <span class="o">[</span>
    629 <span class="s2">"META_CATEG_NAME"</span>,
    630 <span class="s2">"CATEG_LVL2_NAME"</span>,
    631 <span class="s2">"CATEG_LVL3_NAME"</span>
    632 <span class="o">]</span>,
    633 <span class="s2">"derived"</span>: null,
    634 <span class="s2">"hierarchy"</span>: <span class="nb">true</span>
    635 <span class="o">}</span>,
    629 <span class="s2">"name"</span>: <span class="s2">"WEEK_BEG_DT"</span>,
    630 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CAL_DT"</span>,
    631 <span class="s2">"column"</span>: null,
    632 <span class="s2">"derived"</span>: <span class="o">[</span>
    633 <span class="s2">"WEEK_BEG_DT"</span>
    634 <span class="o">]</span>
    635 <span class="o">}</span>,
    636 636 <span class="o">{</span>
    637 <span class="s2">"id"</span>: 3,
    638 <span class="s2">"name"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
    639 <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_KYLIN_FACT"</span>,
    640 <span class="s2">"column"</span>: <span class="o">[</span>
    641 <span class="s2">"LSTG_FORMAT_NAME"</span>
    642 <span class="o">]</span>,
    643 <span class="s2">"derived"</span>: null,
    644 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    645 <span class="o">}</span>,
    646 <span class="o">{</span>
    647 <span class="s2">"id"</span>: 4,
    648 <span class="s2">"name"</span>: <span class="s2">"SITE_ID"</span>,
    649 <span class="s2">"table"</span>: <span class="s2">"EDW.TEST_SITES"</span>,
    650 <span class="s2">"column"</span>: null,
    637 <span class="s2">"name"</span>: <span class="s2">"USER_DEFINED_FIELD1"</span>,
    638 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    639 <span class="s2">"column"</span>: null,
    651 640 <span class="s2">"derived"</span>: <span class="o">[</span>
    652 <span class="s2">"SITE_NAME"</span>,
    653 <span class="s2">"CRE_USER"</span>
    654 <span class="o">]</span>,
    655 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    656 <span class="o">}</span>,
    641 <span class="s2">"USER_DEFINED_FIELD1"</span>
    642 <span class="o">]</span>
    643 <span class="o">}</span>,
    657 644 <span class="o">{</span>
    658 <span class="s2">"id"</span>: 5,
    659 <span class="s2">"name"</span>: <span class="s2">"SELLER_TYPE_CD"</span>,
    660 <span class="s2">"table"</span>: <span class="s2">"EDW.TEST_SELLER_TYPE_DIM"</span>,
    661 <span class="s2">"column"</span>: null,
    645 <span class="s2">"name"</span>: <span class="s2">"USER_DEFINED_FIELD3"</span>,
    646 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    647 <span class="s2">"column"</span>: null,
    662 648 <span class="s2">"derived"</span>: <span class="o">[</span>
    663 <span class="s2">"SELLER_TYPE_DESC"</span>
    664 <span class="o">]</span>,
    665 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    666 <span class="o">}</span>,
    649 <span class="s2">"USER_DEFINED_FIELD3"</span>
    650 <span class="o">]</span>
    651 <span class="o">}</span>,
    667 652 <span class="o">{</span>
    668 <span class="s2">"id"</span>: 6,
    669 <span class="s2">"name"</span>: <span class="s2">"SELLER_ID"</span>,
    670 <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_KYLIN_FACT"</span>,
    671 <span class="s2">"column"</span>: <span class="o">[</span>
    672 <span class="s2">"SELLER_ID"</span>
    673 <span class="o">]</span>,
    674 <span class="s2">"derived"</span>: null,
    675 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    653 <span class="s2">"name"</span>: <span class="s2">"META_CATEG_NAME"</span>,
    654 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    655 <span class="s2">"column"</span>: <span class="s2">"META_CATEG_NAME"</span>,
    656 <span class="s2">"derived"</span>: null
    657 <span class="o">}</span>,
    658 <span class="o">{</span>
    659 <span class="s2">"name"</span>: <span class="s2">"CATEG_LVL2_NAME"</span>,
    660 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    661 <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL2_NAME"</span>,
    662 <span class="s2">"derived"</span>: null
    663 <span class="o">}</span>,
    664 <span class="o">{</span>
    665 <span class="s2">"name"</span>: <span class="s2">"CATEG_LVL3_NAME"</span>,
    666 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    667 <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL3_NAME"</span>,
    668 <span class="s2">"derived"</span>: null
    669 <span class="o">}</span>,
    670 <span class="o">{</span>
    671 <span class="s2">"name"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
    672 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    673 <span class="s2">"column"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
    674 <span class="s2">"derived"</span>: null
    675 <span class="o">}</span>,
    676 <span class="o">{</span>
    677 <span class="s2">"name"</span>: <span class="s2">"SELLER_ID"</span>,
    678 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    679 <span class="s2">"column"</span>: <span class="s2">"SELLER_ID"</span>,
    680 <span class="s2">"derived"</span>: null
    681 <span class="o">}</span>,
    682 <span class="o">{</span>
    683 <span class="s2">"name"</span>: <span class="s2">"BUYER_ID"</span>,
    684 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    685 <span class="s2">"column"</span>: <span class="s2">"BUYER_ID"</span>,
    686 <span class="s2">"derived"</span>: null
    687 <span class="o">}</span>,
    688 <span class="o">{</span>
    689 <span class="s2">"name"</span>: <span class="s2">"ACCOUNT_BUYER_LEVEL"</span>,
    690 <span class="s2">"table"</span>: <span class="s2">"BUYER_ACCOUNT"</span>,
    691 <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_BUYER_LEVEL"</span>,
    692 <span class="s2">"derived"</span>: null
    693 <span class="o">}</span>,
    694 <span class="o">{</span>
    695 <span class="s2">"name"</span>: <span class="s2">"ACCOUNT_SELLER_LEVEL"</span>,
    696 <span class="s2">"table"</span>: <span class="s2">"SELLER_ACCOUNT"</span>,
    697 <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_SELLER_LEVEL"</span>,
    698 <span class="s2">"derived"</span>: null
    699 <span class="o">}</span>,
    700 <span class="o">{</span>
    701 <span class="s2">"name"</span>: <span class="s2">"BUYER_COUNTRY"</span>,
    702 <span class="s2">"table"</span>: <span class="s2">"BUYER_ACCOUNT"</span>,
    703 <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_COUNTRY"</span>,
    704 <span class="s2">"derived"</span>: null
    705 <span class="o">}</span>,
    706 <span class="o">{</span>
    707 <span class="s2">"name"</span>: <span class="s2">"SELLER_COUNTRY"</span>,
    708 <span class="s2">"table"</span>: <span class="s2">"SELLER_ACCOUNT"</span>,
    709 <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_COUNTRY"</span>,
    710 <span class="s2">"derived"</span>: null
    711 <span class="o">}</span>,
    712 <span class="o">{</span>
    713 <span class="s2">"name"</span>: <span class="s2">"BUYER_COUNTRY_NAME"</span>,
    714 <span class="s2">"table"</span>: <span class="s2">"BUYER_COUNTRY"</span>,
    715 <span class="s2">"column"</span>: <span class="s2">"NAME"</span>,
    716 <span class="s2">"derived"</span>: null
    717 <span class="o">}</span>,
    718 <span class="o">{</span>
    719 <span class="s2">"name"</span>: <span class="s2">"SELLER_COUNTRY_NAME"</span>,
    720 <span class="s2">"table"</span>: <span class="s2">"SELLER_COUNTRY"</span>,
    721 <span class="s2">"column"</span>: <span class="s2">"NAME"</span>,
    722 <span class="s2">"derived"</span>: null
    723 <span class="o">}</span>,
    724 <span class="o">{</span>
    725 <span class="s2">"name"</span>: <span class="s2">"OPS_USER_ID"</span>,
    726 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    727 <span class="s2">"column"</span>: <span class="s2">"OPS_USER_ID"</span>,
    728 <span class="s2">"derived"</span>: null
    729 <span class="o">}</span>,
    730 <span class="o">{</span>
    731 <span class="s2">"name"</span>: <span class="s2">"OPS_REGION"</span>,
    732 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    733 <span class="s2">"column"</span>: <span class="s2">"OPS_REGION"</span>,
    734 <span class="s2">"derived"</span>: null
    676 735 <span class="o">}</span>
    677 <span class="o">]</span>,
    736 <span class="o">]</span>,
    678 737 <span class="s2">"measures"</span>: <span class="o">[</span>
    679 738 <span class="o">{</span>
    680 <span class="s2">"id"</span>: 1,
    681 <span class="s2">"name"</span>: <span class="s2">"GMV_SUM"</span>,
    739 <span class="s2">"name"</span>: <span class="s2">"GMV_SUM"</span>,
    682 740 <span class="s2">"function"</span>: <span class="o">{</span>
    683 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    741 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    684 742 <span class="s2">"parameter"</span>: <span class="o">{</span>
    685 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    686 <span class="s2">"value"</span>: <span class="s2">"PRICE"</span>,
    687 <span class="s2">"next_parameter"</span>: null
    688 <span class="o">}</span>,
    743 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    744 <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.PRICE"</span>
    745 <span class="o">}</span>,
    689 746 <span class="s2">"returntype"</span>: <span class="s2">"decimal(19,4)"</span>
    690 <span class="o">}</span>,
    691 <span class="s2">"dependent_measure_ref"</span>: null
    692 <span class="o">}</span>,
    747 <span class="o">}</span>
    748 <span class="o">}</span>,
    693 749 <span class="o">{</span>
    694 <span class="s2">"id"</span>: 2,
    695 <span class="s2">"name"</span>: <span class="s2">"GMV_MIN"</span>,
    750 <span class="s2">"name"</span>: <span class="s2">"BUYER_LEVEL_SUM"</span>,
    696 751 <span class="s2">"function"</span>: <span class="o">{</span>
    697 <span class="s2">"expression"</span>: <span class="s2">"MIN"</span>,
    752 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    698 753 <span class="s2">"parameter"</span>: <span class="o">{</span>
    699 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    700 <span class="s2">"value"</span>: <span class="s2">"PRICE"</span>,
    701 <span class="s2">"next_parameter"</span>: null
    702 <span class="o">}</span>,
    703 <span class="s2">"returntype"</span>: <span class="s2">"decimal(19,4)"</span>
    704 <span class="o">}</span>,
    705 <span class="s2">"dependent_measure_ref"</span>: null
    706 <span class="o">}</span>,
    754 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    755 <span class="s2">"value"</span>: <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>
    756 <span class="o">}</span>,
    757 <span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
    758 <span class="o">}</span>
    759 <span class="o">}</span>,
    707 760 <span class="o">{</span>
    708 <span class="s2">"id"</span>: 3,
    709 <span class="s2">"name"</span>: <span class="s2">"GMV_MAX"</span>,
    761 <span class="s2">"name"</span>: <span class="s2">"SELLER_LEVEL_SUM"</span>,
    710 762 <span class="s2">"function"</span>: <span class="o">{</span>
    711 <span class="s2">"expression"</span>: <span class="s2">"MAX"</span>,
    763 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    712 764 <span class="s2">"parameter"</span>: <span class="o">{</span>
    713 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    714 <span class="s2">"value"</span>: <span class="s2">"PRICE"</span>,
    715 <span class="s2">"next_parameter"</span>: null
    716 <span class="o">}</span>,
    717 <span class="s2">"returntype"</span>: <span class="s2">"decimal(19,4)"</span>
    718 <span class="o">}</span>,
    719 <span class="s2">"dependent_measure_ref"</span>: null
    720 <span class="o">}</span>,
    765 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    766 <span class="s2">"value"</span>: <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>
    767 <span class="o">}</span>,
    768 <span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
    769 <span class="o">}</span>
    770 <span class="o">}</span>,
    721 771 <span class="o">{</span>
    722 <span class="s2">"id"</span>: 4,
    723 <span class="s2">"name"</span>: <span class="s2">"TRANS_CNT"</span>,
    772 <span class="s2">"name"</span>: <span class="s2">"TRANS_CNT"</span>,
    724 773 <span class="s2">"function"</span>: <span class="o">{</span>
    725 <span class="s2">"expression"</span>: <span class="s2">"COUNT"</span>,
    774 <span class="s2">"expression"</span>: <span class="s2">"COUNT"</span>,
    726 775 <span class="s2">"parameter"</span>: <span class="o">{</span>
    727 <span class="s2">"type"</span>: <span class="s2">"constant"</span>,
    728 <span class="s2">"value"</span>: <span class="s2">"1"</span>,
    729 <span class="s2">"next_parameter"</span>: null
    730 <span class="o">}</span>,
    776 <span class="s2">"type"</span>: <span class="s2">"constant"</span>,
    777 <span class="s2">"value"</span>: <span class="s2">"1"</span>
    778 <span class="o">}</span>,
    731 779 <span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
    732 <span class="o">}</span>,
    733 <span class="s2">"dependent_measure_ref"</span>: null
    734 <span class="o">}</span>,
    780 <span class="o">}</span>
    781 <span class="o">}</span>,
    735 782 <span class="o">{</span>
    736 <span class="s2">"id"</span>: 5,
    737 <span class="s2">"name"</span>: <span class="s2">"ITEM_COUNT_SUM"</span>,
    783 <span class="s2">"name"</span>: <span class="s2">"SELLER_CNT_HLL"</span>,
    738 784 <span class="s2">"function"</span>: <span class="o">{</span>
    739 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    785 <span class="s2">"expression"</span>: <span class="s2">"COUNT_DISTINCT"</span>,
    740 786 <span class="s2">"parameter"</span>: <span class="o">{</span>
    741 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    742 <span class="s2">"value"</span>: <span class="s2">"ITEM_COUNT"</span>,
    743 <span class="s2">"next_parameter"</span>: null
    744 <span class="o">}</span>,
    745 <span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
    746 <span class="o">}</span>,
    747 <span class="s2">"dependent_measure_ref"</span>: null
    787 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    788 <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.SELLER_ID"</span>
    789 <span class="o">}</span>,
    790 <span class="s2">"returntype"</span>: <span class="s2">"hllc(10)"</span>
    791 <span class="o">}</span>
    792 <span class="o">}</span>,
    793 <span class="o">{</span>
    794 <span class="s2">"name"</span>: <span class="s2">"TOP_SELLER"</span>,
    795 <span class="s2">"function"</span>: <span class="o">{</span>
    796 <span class="s2">"expression"</span>: <span class="s2">"TOP_N"</span>,
    797 <span class="s2">"parameter"</span>: <span class="o">{</span>
    798 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    799 <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.PRICE"</span>,
    800 <span class="s2">"next_parameter"</span>: <span class="o">{</span>
    801 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    802 <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.SELLER_ID"</span>
    803 <span class="o">}</span>
    804 <span class="o">}</span>,
    805 <span class="s2">"returntype"</span>: <span class="s2">"topn(100)"</span>,
    806 <span class="s2">"configuration"</span>: <span class="o">{</span>
    807 <span class="s2">"topn.encoding.KYLIN_SALES.SELLER_ID"</span>: <span class="s2">"dict"</span>,
    808 <span class="s2">"topn.encoding_version.KYLIN_SALES.SELLER_ID"</span>: <span class="s2">"1"</span>
    809 <span class="o">}</span>
    810 <span class="o">}</span>
    748 811 <span class="o">}</span>
    749 <span class="o">]</span>,
    812 <span class="o">]</span>,
    750 813 <span class="s2">"rowkey"</span>: <span class="o">{</span>
    751 814 <span class="s2">"rowkey_columns"</span>: <span class="o">[</span>
    752 815 <span class="o">{</span>
    753 <span class="s2">"column"</span>: <span class="s2">"SELLER_ID"</span>,
    754 <span class="s2">"length"</span>: 18,
    755 <span class="s2">"dictionary"</span>: null,
    756 <span class="s2">"mandatory"</span>: <span class="nb">true</span>
    757 <span class="o">}</span>,
    816 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.BUYER_ID"</span>,
    817 <span class="s2">"encoding"</span>: <span class="s2">"integer:4"</span>,
    818 <span class="s2">"encoding_version"</span>: 1,
    819 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    820 <span class="o">}</span>,
    758 821 <span class="o">{</span>
    759 <span class="s2">"column"</span>: <span class="s2">"CAL_DT"</span>,
    760 <span class="s2">"length"</span>: 0,
    761 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    762 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    763 <span class="o">}</span>,
    822 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.SELLER_ID"</span>,
    823 <span class="s2">"encoding"</span>: <span class="s2">"integer:4"</span>,
    824 <span class="s2">"encoding_version"</span>: 1,
    825 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    826 <span class="o">}</span>,
    764 827 <span class="o">{</span>
    765 <span class="s2">"column"</span>: <span class="s2">"LEAF_CATEG_ID"</span>,
    766 <span class="s2">"length"</span>: 0,
    767 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    768 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    769 <span class="o">}</span>,
    828 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.TRANS_ID"</span>,
    829 <span class="s2">"encoding"</span>: <span class="s2">"integer:4"</span>,
    830 <span class="s2">"encoding_version"</span>: 1,
    831 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    832 <span class="o">}</span>,
    770 833 <span class="o">{</span>
    771 <span class="s2">"column"</span>: <span class="s2">"META_CATEG_NAME"</span>,
    772 <span class="s2">"length"</span>: 0,
    773 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    774 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    775 <span class="o">}</span>,
    834 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.PART_DT"</span>,
    835 <span class="s2">"encoding"</span>: <span class="s2">"date"</span>,
    836 <span class="s2">"encoding_version"</span>: 1,
    837 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    838 <span class="o">}</span>,
    776 839 <span class="o">{</span>
    777 <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL2_NAME"</span>,
    778 <span class="s2">"length"</span>: 0,
    779 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    780 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    781 <span class="o">}</span>,
    840 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.LEAF_CATEG_ID"</span>,
    841 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    842 <span class="s2">"encoding_version"</span>: 1,
    843 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    844 <span class="o">}</span>,
    782 845 <span class="o">{</span>
    783 <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL3_NAME"</span>,
    784 <span class="s2">"length"</span>: 0,
    785 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    786 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    787 <span class="o">}</span>,
    846 <span class="s2">"column"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME"</span>,
    847 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    848 <span class="s2">"encoding_version"</span>: 1,
    849 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    850 <span class="o">}</span>,
    788 851 <span class="o">{</span>
    789 <span class="s2">"column"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
    790 <span class="s2">"length"</span>: 12,
    791 <span class="s2">"dictionary"</span>: null,
    792 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    793 <span class="o">}</span>,
    852 <span class="s2">"column"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME"</span>,
    853 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    854 <span class="s2">"encoding_version"</span>: 1,
    855 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    856 <span class="o">}</span>,
    794 857 <span class="o">{</span>
    795 <span class="s2">"column"</span>: <span class="s2">"LSTG_SITE_ID"</span>,
    796 <span class="s2">"length"</span>: 0,
    797 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    798 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    799 <span class="o">}</span>,
    858 <span class="s2">"column"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME"</span>,
    859 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    860 <span class="s2">"encoding_version"</span>: 1,
    861 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    862 <span class="o">}</span>,
    800 863 <span class="o">{</span>
    801 <span class="s2">"column"</span>: <span class="s2">"SLR_SEGMENT_CD"</span>,
    802 <span class="s2">"length"</span>: 0,
    803 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    804 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    864 <span class="s2">"column"</span>: <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>,
    865 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    866 <span class="s2">"encoding_version"</span>: 1,
    867 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    868 <span class="o">}</span>,
    869 <span class="o">{</span>
    870 <span class="s2">"column"</span>: <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>,
    871 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    872 <span class="s2">"encoding_version"</span>: 1,
    873 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    874 <span class="o">}</span>,
    875 <span class="o">{</span>
    876 <span class="s2">"column"</span>: <span class="s2">"BUYER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    877 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    878 <span class="s2">"encoding_version"</span>: 1,
    879 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    880 <span class="o">}</span>,
    881 <span class="o">{</span>
    882 <span class="s2">"column"</span>: <span class="s2">"SELLER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    883 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    884 <span class="s2">"encoding_version"</span>: 1,
    885 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    886 <span class="o">}</span>,
    887 <span class="o">{</span>
    888 <span class="s2">"column"</span>: <span class="s2">"BUYER_COUNTRY.NAME"</span>,
    889 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    890 <span class="s2">"encoding_version"</span>: 1,
    891 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    892 <span class="o">}</span>,
    893 <span class="o">{</span>
    894 <span class="s2">"column"</span>: <span class="s2">"SELLER_COUNTRY.NAME"</span>,
    895 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    896 <span class="s2">"encoding_version"</span>: 1,
    897 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    898 <span class="o">}</span>,
    899 <span class="o">{</span>
    900 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.LSTG_FORMAT_NAME"</span>,
    901 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    902 <span class="s2">"encoding_version"</span>: 1,
    903 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    904 <span class="o">}</span>,
    905 <span class="o">{</span>
    906 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.LSTG_SITE_ID"</span>,
    907 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    908 <span class="s2">"encoding_version"</span>: 1,
    909 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    910 <span class="o">}</span>,
    911 <span class="o">{</span>
    912 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.OPS_USER_ID"</span>,
    913 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    914 <span class="s2">"encoding_version"</span>: 1,
    915 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    916 <span class="o">}</span>,
    917 <span class="o">{</span>
    918 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.OPS_REGION"</span>,
    919 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    920 <span class="s2">"encoding_version"</span>: 1,
    921 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    805 922 <span class="o">}</span>
    806 <span class="o">]</span>,
    807 <span class="s2">"aggregation_groups"</span>: <span class="o">[</span>
    808 <span class="o">[</span>
    809 <span class="s2">"LEAF_CATEG_ID"</span>,
    810 <span class="s2">"META_CATEG_NAME"</span>,
    811 <span class="s2">"CATEG_LVL2_NAME"</span>,
    812 <span class="s2">"CATEG_LVL3_NAME"</span>,
    813 <span class="s2">"CAL_DT"</span>
    814 <span class="o">]</span>
    815 923 <span class="o">]</span>
    816 <span class="o">}</span>,
    817 <span class="s2">"signature"</span>: <span class="s2">"lsLAl2jL62ZApmOLZqWU3g=="</span>,
    818 <span class="s2">"last_modified"</span>: 1445850327000,
    819 <span class="s2">"model_name"</span>: <span class="s2">"test_kylin_with_slr_model_desc"</span>,
    820 <span class="s2">"null_string"</span>: null,
    924 <span class="o">}</span>,
    821 925 <span class="s2">"hbase_mapping"</span>: <span class="o">{</span>
    822 926 <span class="s2">"column_family"</span>: <span class="o">[</span>
    823 927 <span class="o">{</span>
    824 <span class="s2">"name"</span>: <span class="s2">"F1"</span>,
    928 <span class="s2">"name"</span>: <span class="s2">"F1"</span>,
    825 929 <span class="s2">"columns"</span>: <span class="o">[</span>
    826 930 <span class="o">{</span>
    827 <span class="s2">"qualifier"</span>: <span class="s2">"M"</span>,
    931 <span class="s2">"qualifier"</span>: <span class="s2">"M"</span>,
    828 932 <span class="s2">"measure_refs"</span>: <span class="o">[</span>
    829 <span class="s2">"GMV_SUM"</span>,
    830 <span class="s2">"GMV_MIN"</span>,
    831 <span class="s2">"GMV_MAX"</span>,
    832 <span class="s2">"TRANS_CNT"</span>,
    833 <span class="s2">"ITEM_COUNT_SUM"</span>
    933 <span class="s2">"GMV_SUM"</span>,
    934 <span class="s2">"BUYER_LEVEL_SUM"</span>,
    935 <span class="s2">"SELLER_LEVEL_SUM"</span>,
    936 <span class="s2">"TRANS_CNT"</span>
    834 937 <span class="o">]</span>
    835 938 <span class="o">}</span>
    836 939 <span class="o">]</span>
    940 <span class="o">}</span>,
    941 <span class="o">{</span>
    942 <span class="s2">"name"</span>: <span class="s2">"F2"</span>,
    943 <span class="s2">"columns"</span>: <span class="o">[</span>
    944 <span class="o">{</span>
    945 <span class="s2">"qualifier"</span>: <span class="s2">"M"</span>,
    946 <span class="s2">"measure_refs"</span>: <span class="o">[</span>
    947 <span class="s2">"SELLER_CNT_HLL"</span>,
    948 <span class="s2">"TOP_SELLER"</span>
    949 <span class="o">]</span>
    950 <span class="o">}</span>
    951 <span class="o">]</span>
    837 952 <span class="o">}</span>
    838 953 <span class="o">]</span>
    839 <span class="o">}</span>,
    840 <span class="s2">"notify_list"</span>: null,
    841 <span class="s2">"auto_merge_time_ranges"</span>: null,
    842 <span class="s2">"retention_range"</span>: 0
    954 <span class="o">}</span>,
    955 <span class="s2">"aggregation_groups"</span>: <span class="o">[</span>
    956 <span class="o">{</span>
    957 <span class="s2">"includes"</span>: <span class="o">[</span>
    958 <span class="s2">"KYLIN_SALES.PART_DT"</span>,
    959 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME"</span>,
    960 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME"</span>,
    961 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME"</span>,
    962 <span class="s2">"KYLIN_SALES.LEAF_CATEG_ID"</span>,
    963 <span class="s2">"KYLIN_SALES.LSTG_FORMAT_NAME"</span>,
    964 <span class="s2">"KYLIN_SALES.LSTG_SITE_ID"</span>,
    965 <span class="s2">"KYLIN_SALES.OPS_USER_ID"</span>,
    966 <span class="s2">"KYLIN_SALES.OPS_REGION"</span>,
    967 <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>,
    968 <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>,
    969 <span class="s2">"BUYER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    970 <span class="s2">"SELLER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    971 <span class="s2">"BUYER_COUNTRY.NAME"</span>,
    972 <span class="s2">"SELLER_COUNTRY.NAME"</span>
    973 <span class="o">]</span>,
    974 <span class="s2">"select_rule"</span>: <span class="o">{</span>
    975 <span class="s2">"hierarchy_dims"</span>: <span class="o">[</span>
    976 <span class="o">[</span>
    977 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME"</span>,
    978 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME"</span>,
    979 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME"</span>,
    980 <span class="s2">"KYLIN_SALES.LEAF_CATEG_ID"</span>
    981 <span class="o">]</span>
    982 <span class="o">]</span>,
    983 <span class="s2">"mandatory_dims"</span>: <span class="o">[</span>
    984 <span class="s2">"KYLIN_SALES.PART_DT"</span>
    985 <span class="o">]</span>,
    986 <span class="s2">"joint_dims"</span>: <span class="o">[</span>
    987 <span class="o">[</span>
    988 <span class="s2">"BUYER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    989 <span class="s2">"BUYER_COUNTRY.NAME"</span>
    990 <span class="o">]</span>,
    991 <span class="o">[</span>
    992 <span class="s2">"SELLER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    993 <span class="s2">"SELLER_COUNTRY.NAME"</span>
    994 <span class="o">]</span>,
    995 <span class="o">[</span>
    996 <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>,
    997 <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>
    998 <span class="o">]</span>,
    999 <span class="o">[</span>
    1000 <span class="s2">"KYLIN_SALES.LSTG_FORMAT_NAME"</span>,
    1001 <span class="s2">"KYLIN_SALES.LSTG_SITE_ID"</span>
    1002 <span class="o">]</span>,
    1003 <span class="o">[</span>
    1004 <span class="s2">"KYLIN_SALES.OPS_USER_ID"</span>,
    1005 <span class="s2">"KYLIN_SALES.OPS_REGION"</span>
    1006 <span class="o">]</span>
    1007 <span class="o">]</span>
    1008 <span class="o">}</span>
    1009 <span class="o">}</span>
    1010 <span class="o">]</span>,
    1011 <span class="s2">"signature"</span>: null,
    1012 <span class="s2">"notify_list"</span>: <span class="o">[]</span>,
    1013 <span class="s2">"status_need_notify"</span>: <span class="o">[]</span>,
    1014 <span class="s2">"partition_date_start"</span>: 1325376000000,
    1015 <span class="s2">"partition_date_end"</span>: 3153600000000,
    1016 <span class="s2">"auto_merge_time_ranges"</span>: <span class="o">[]</span>,
    1017 <span class="s2">"volatile_range"</span>: 0,
    1018 <span class="s2">"retention_range"</span>: 0,
    1019 <span class="s2">"engine_type"</span>: 2,
    1020 <span class="s2">"storage_type"</span>: 2,
    1021 <span class="s2">"override_kylin_properties"</span>: <span class="o">{</span>
    1022 <span class="s2">"kylin.cube.aggrgroup.is-mandatory-only-valid"</span>: <span class="s2">"true"</span>,
    1023 <span class="s2">"kylin.engine.spark.rdd-partition-cut-mb"</span>: <span class="s2">"500"</span>
    1024 <span class="o">}</span>,
    1025 <span class="s2">"cuboid_black_list"</span>: <span class="o">[]</span>,
    1026 <span class="s2">"parent_forward"</span>: 3,
    1027 <span class="s2">"mandatory_dimension_set_list"</span>: <span class="o">[]</span>,
    1028 <span class="s2">"snapshot_table_desc_list"</span>: <span class="o">[]</span>
    843 1029 <span class="o">}</span>
    844 1030 <span class="o">]</span>
    845 1031 </code></pre>
  • kylin/site/docs/howto/howto_use_restapi.html

     
    7461 7461 <h4 id="response-sample-5">Response Sample</h4>
    7462 7462 <div class="highlighter-rouge"><pre class="highlight"><code><span class="o">[</span>
    7463 7463 <span class="o">{</span>
    7464 <span class="s2">"uuid"</span>: <span class="s2">"a24ca905-1fc6-4f67-985c-38fa5aeafd92"</span>,
    7465 <span class="s2">"name"</span>: <span class="s2">"test_kylin_cube_with_slr_desc"</span>,
    7466 <span class="s2">"description"</span>: null,
    7464 <span class="s2">"uuid"</span>: <span class="s2">"0ef9b7a8-3929-4dff-b59d-2100aadc8dbf"</span>,
    7465 <span class="s2">"last_modified"</span>: 1574402902000,
    7466 <span class="s2">"version"</span>: <span class="s2">"3.0.0.20500"</span>,
    7467 <span class="s2">"name"</span>: <span class="s2">"kylin_sales_cube"</span>,
    7468 <span class="s2">"is_draft"</span>: <span class="nb">false</span>,
    7469 <span class="s2">"model_name"</span>: <span class="s2">"kylin_sales_model"</span>,
    7470 <span class="s2">"description"</span>: <span class="s2">""</span>,
    7471 <span class="s2">"null_string"</span>: null,
    7467 7472 <span class="s2">"dimensions"</span>: <span class="o">[</span>
    7468 7473 <span class="o">{</span>
    7469 <span class="s2">"id"</span>: 0,
    7470 <span class="s2">"name"</span>: <span class="s2">"CAL_DT"</span>,
    7471 <span class="s2">"table"</span>: <span class="s2">"EDW.TEST_CAL_DT"</span>,
    7472 <span class="s2">"column"</span>: null,
    7474 <span class="s2">"name"</span>: <span class="s2">"TRANS_ID"</span>,
    7475 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    7476 <span class="s2">"column"</span>: <span class="s2">"TRANS_ID"</span>,
    7477 <span class="s2">"derived"</span>: null
    7478 <span class="o">}</span>,
    7479 <span class="o">{</span>
    7480 <span class="s2">"name"</span>: <span class="s2">"YEAR_BEG_DT"</span>,
    7481 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CAL_DT"</span>,
    7482 <span class="s2">"column"</span>: null,
    7473 7483 <span class="s2">"derived"</span>: <span class="o">[</span>
    7474 <span class="s2">"WEEK_BEG_DT"</span>
    7475 <span class="o">]</span>,
    7476 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    7477 <span class="o">}</span>,
    7484 <span class="s2">"YEAR_BEG_DT"</span>
    7485 <span class="o">]</span>
    7486 <span class="o">}</span>,
    7478 7487 <span class="o">{</span>
    7479 <span class="s2">"id"</span>: 1,
    7480 <span class="s2">"name"</span>: <span class="s2">"CATEGORY"</span>,
    7481 <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_CATEGORY_GROUPINGS"</span>,
    7482 <span class="s2">"column"</span>: null,
    7488 <span class="s2">"name"</span>: <span class="s2">"MONTH_BEG_DT"</span>,
    7489 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CAL_DT"</span>,
    7490 <span class="s2">"column"</span>: null,
    7483 7491 <span class="s2">"derived"</span>: <span class="o">[</span>
    7484 <span class="s2">"USER_DEFINED_FIELD1"</span>,
    7485 <span class="s2">"USER_DEFINED_FIELD3"</span>,
    7486 <span class="s2">"UPD_DATE"</span>,
    7487 <span class="s2">"UPD_USER"</span>
    7488 <span class="o">]</span>,
    7489 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    7490 <span class="o">}</span>,
    7492 <span class="s2">"MONTH_BEG_DT"</span>
    7493 <span class="o">]</span>
    7494 <span class="o">}</span>,
    7491 7495 <span class="o">{</span>
    7492 <span class="s2">"id"</span>: 2,
    7493 <span class="s2">"name"</span>: <span class="s2">"CATEGORY_HIERARCHY"</span>,
    7494 <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_CATEGORY_GROUPINGS"</span>,
    7495 <span class="s2">"column"</span>: <span class="o">[</span>
    7496 <span class="s2">"META_CATEG_NAME"</span>,
    7497 <span class="s2">"CATEG_LVL2_NAME"</span>,
    7498 <span class="s2">"CATEG_LVL3_NAME"</span>
    7499 <span class="o">]</span>,
    7500 <span class="s2">"derived"</span>: null,
    7501 <span class="s2">"hierarchy"</span>: <span class="nb">true</span>
    7502 <span class="o">}</span>,
    7496 <span class="s2">"name"</span>: <span class="s2">"WEEK_BEG_DT"</span>,
    7497 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CAL_DT"</span>,
    7498 <span class="s2">"column"</span>: null,
    7499 <span class="s2">"derived"</span>: <span class="o">[</span>
    7500 <span class="s2">"WEEK_BEG_DT"</span>
    7501 <span class="o">]</span>
    7502 <span class="o">}</span>,
    7503 7503 <span class="o">{</span>
    7504 <span class="s2">"id"</span>: 3,
    7505 <span class="s2">"name"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
    7506 <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_KYLIN_FACT"</span>,
    7507 <span class="s2">"column"</span>: <span class="o">[</span>
    7508 <span class="s2">"LSTG_FORMAT_NAME"</span>
    7509 <span class="o">]</span>,
    7510 <span class="s2">"derived"</span>: null,
    7511 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    7512 <span class="o">}</span>,
    7513 <span class="o">{</span>
    7514 <span class="s2">"id"</span>: 4,
    7515 <span class="s2">"name"</span>: <span class="s2">"SITE_ID"</span>,
    7516 <span class="s2">"table"</span>: <span class="s2">"EDW.TEST_SITES"</span>,
    7517 <span class="s2">"column"</span>: null,
    7504 <span class="s2">"name"</span>: <span class="s2">"USER_DEFINED_FIELD1"</span>,
    7505 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    7506 <span class="s2">"column"</span>: null,
    7518 7507 <span class="s2">"derived"</span>: <span class="o">[</span>
    7519 <span class="s2">"SITE_NAME"</span>,
    7520 <span class="s2">"CRE_USER"</span>
    7521 <span class="o">]</span>,
    7522 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    7523 <span class="o">}</span>,
    7508 <span class="s2">"USER_DEFINED_FIELD1"</span>
    7509 <span class="o">]</span>
    7510 <span class="o">}</span>,
    7524 7511 <span class="o">{</span>
    7525 <span class="s2">"id"</span>: 5,
    7526 <span class="s2">"name"</span>: <span class="s2">"SELLER_TYPE_CD"</span>,
    7527 <span class="s2">"table"</span>: <span class="s2">"EDW.TEST_SELLER_TYPE_DIM"</span>,
    7528 <span class="s2">"column"</span>: null,
    7512 <span class="s2">"name"</span>: <span class="s2">"USER_DEFINED_FIELD3"</span>,
    7513 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    7514 <span class="s2">"column"</span>: null,
    7529 7515 <span class="s2">"derived"</span>: <span class="o">[</span>
    7530 <span class="s2">"SELLER_TYPE_DESC"</span>
    7531 <span class="o">]</span>,
    7532 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    7533 <span class="o">}</span>,
    7516 <span class="s2">"USER_DEFINED_FIELD3"</span>
    7517 <span class="o">]</span>
    7518 <span class="o">}</span>,
    7534 7519 <span class="o">{</span>
    7535 <span class="s2">"id"</span>: 6,
    7536 <span class="s2">"name"</span>: <span class="s2">"SELLER_ID"</span>,
    7537 <span class="s2">"table"</span>: <span class="s2">"DEFAULT.TEST_KYLIN_FACT"</span>,
    7538 <span class="s2">"column"</span>: <span class="o">[</span>
    7539 <span class="s2">"SELLER_ID"</span>
    7540 <span class="o">]</span>,
    7541 <span class="s2">"derived"</span>: null,
    7542 <span class="s2">"hierarchy"</span>: <span class="nb">false</span>
    7520 <span class="s2">"name"</span>: <span class="s2">"META_CATEG_NAME"</span>,
    7521 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    7522 <span class="s2">"column"</span>: <span class="s2">"META_CATEG_NAME"</span>,
    7523 <span class="s2">"derived"</span>: null
    7524 <span class="o">}</span>,
    7525 <span class="o">{</span>
    7526 <span class="s2">"name"</span>: <span class="s2">"CATEG_LVL2_NAME"</span>,
    7527 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    7528 <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL2_NAME"</span>,
    7529 <span class="s2">"derived"</span>: null
    7530 <span class="o">}</span>,
    7531 <span class="o">{</span>
    7532 <span class="s2">"name"</span>: <span class="s2">"CATEG_LVL3_NAME"</span>,
    7533 <span class="s2">"table"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS"</span>,
    7534 <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL3_NAME"</span>,
    7535 <span class="s2">"derived"</span>: null
    7536 <span class="o">}</span>,
    7537 <span class="o">{</span>
    7538 <span class="s2">"name"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
    7539 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    7540 <span class="s2">"column"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
    7541 <span class="s2">"derived"</span>: null
    7542 <span class="o">}</span>,
    7543 <span class="o">{</span>
    7544 <span class="s2">"name"</span>: <span class="s2">"SELLER_ID"</span>,
    7545 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    7546 <span class="s2">"column"</span>: <span class="s2">"SELLER_ID"</span>,
    7547 <span class="s2">"derived"</span>: null
    7548 <span class="o">}</span>,
    7549 <span class="o">{</span>
    7550 <span class="s2">"name"</span>: <span class="s2">"BUYER_ID"</span>,
    7551 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    7552 <span class="s2">"column"</span>: <span class="s2">"BUYER_ID"</span>,
    7553 <span class="s2">"derived"</span>: null
    7554 <span class="o">}</span>,
    7555 <span class="o">{</span>
    7556 <span class="s2">"name"</span>: <span class="s2">"ACCOUNT_BUYER_LEVEL"</span>,
    7557 <span class="s2">"table"</span>: <span class="s2">"BUYER_ACCOUNT"</span>,
    7558 <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_BUYER_LEVEL"</span>,
    7559 <span class="s2">"derived"</span>: null
    7560 <span class="o">}</span>,
    7561 <span class="o">{</span>
    7562 <span class="s2">"name"</span>: <span class="s2">"ACCOUNT_SELLER_LEVEL"</span>,
    7563 <span class="s2">"table"</span>: <span class="s2">"SELLER_ACCOUNT"</span>,
    7564 <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_SELLER_LEVEL"</span>,
    7565 <span class="s2">"derived"</span>: null
    7566 <span class="o">}</span>,
    7567 <span class="o">{</span>
    7568 <span class="s2">"name"</span>: <span class="s2">"BUYER_COUNTRY"</span>,
    7569 <span class="s2">"table"</span>: <span class="s2">"BUYER_ACCOUNT"</span>,
    7570 <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_COUNTRY"</span>,
    7571 <span class="s2">"derived"</span>: null
    7572 <span class="o">}</span>,
    7573 <span class="o">{</span>
    7574 <span class="s2">"name"</span>: <span class="s2">"SELLER_COUNTRY"</span>,
    7575 <span class="s2">"table"</span>: <span class="s2">"SELLER_ACCOUNT"</span>,
    7576 <span class="s2">"column"</span>: <span class="s2">"ACCOUNT_COUNTRY"</span>,
    7577 <span class="s2">"derived"</span>: null
    7578 <span class="o">}</span>,
    7579 <span class="o">{</span>
    7580 <span class="s2">"name"</span>: <span class="s2">"BUYER_COUNTRY_NAME"</span>,
    7581 <span class="s2">"table"</span>: <span class="s2">"BUYER_COUNTRY"</span>,
    7582 <span class="s2">"column"</span>: <span class="s2">"NAME"</span>,
    7583 <span class="s2">"derived"</span>: null
    7584 <span class="o">}</span>,
    7585 <span class="o">{</span>
    7586 <span class="s2">"name"</span>: <span class="s2">"SELLER_COUNTRY_NAME"</span>,
    7587 <span class="s2">"table"</span>: <span class="s2">"SELLER_COUNTRY"</span>,
    7588 <span class="s2">"column"</span>: <span class="s2">"NAME"</span>,
    7589 <span class="s2">"derived"</span>: null
    7590 <span class="o">}</span>,
    7591 <span class="o">{</span>
    7592 <span class="s2">"name"</span>: <span class="s2">"OPS_USER_ID"</span>,
    7593 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    7594 <span class="s2">"column"</span>: <span class="s2">"OPS_USER_ID"</span>,
    7595 <span class="s2">"derived"</span>: null
    7596 <span class="o">}</span>,
    7597 <span class="o">{</span>
    7598 <span class="s2">"name"</span>: <span class="s2">"OPS_REGION"</span>,
    7599 <span class="s2">"table"</span>: <span class="s2">"KYLIN_SALES"</span>,
    7600 <span class="s2">"column"</span>: <span class="s2">"OPS_REGION"</span>,
    7601 <span class="s2">"derived"</span>: null
    7543 7602 <span class="o">}</span>
    7544 <span class="o">]</span>,
    7603 <span class="o">]</span>,
    7545 7604 <span class="s2">"measures"</span>: <span class="o">[</span>
    7546 7605 <span class="o">{</span>
    7547 <span class="s2">"id"</span>: 1,
    7548 <span class="s2">"name"</span>: <span class="s2">"GMV_SUM"</span>,
    7606 <span class="s2">"name"</span>: <span class="s2">"GMV_SUM"</span>,
    7549 7607 <span class="s2">"function"</span>: <span class="o">{</span>
    7550 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    7608 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    7551 7609 <span class="s2">"parameter"</span>: <span class="o">{</span>
    7552 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7553 <span class="s2">"value"</span>: <span class="s2">"PRICE"</span>,
    7554 <span class="s2">"next_parameter"</span>: null
    7555 <span class="o">}</span>,
    7610 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7611 <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.PRICE"</span>
    7612 <span class="o">}</span>,
    7556 7613 <span class="s2">"returntype"</span>: <span class="s2">"decimal(19,4)"</span>
    7557 <span class="o">}</span>,
    7558 <span class="s2">"dependent_measure_ref"</span>: null
    7559 <span class="o">}</span>,
    7614 <span class="o">}</span>
    7615 <span class="o">}</span>,
    7560 7616 <span class="o">{</span>
    7561 <span class="s2">"id"</span>: 2,
    7562 <span class="s2">"name"</span>: <span class="s2">"GMV_MIN"</span>,
    7617 <span class="s2">"name"</span>: <span class="s2">"BUYER_LEVEL_SUM"</span>,
    7563 7618 <span class="s2">"function"</span>: <span class="o">{</span>
    7564 <span class="s2">"expression"</span>: <span class="s2">"MIN"</span>,
    7619 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    7565 7620 <span class="s2">"parameter"</span>: <span class="o">{</span>
    7566 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7567 <span class="s2">"value"</span>: <span class="s2">"PRICE"</span>,
    7568 <span class="s2">"next_parameter"</span>: null
    7569 <span class="o">}</span>,
    7570 <span class="s2">"returntype"</span>: <span class="s2">"decimal(19,4)"</span>
    7571 <span class="o">}</span>,
    7572 <span class="s2">"dependent_measure_ref"</span>: null
    7573 <span class="o">}</span>,
    7621 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7622 <span class="s2">"value"</span>: <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>
    7623 <span class="o">}</span>,
    7624 <span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
    7625 <span class="o">}</span>
    7626 <span class="o">}</span>,
    7574 7627 <span class="o">{</span>
    7575 <span class="s2">"id"</span>: 3,
    7576 <span class="s2">"name"</span>: <span class="s2">"GMV_MAX"</span>,
    7628 <span class="s2">"name"</span>: <span class="s2">"SELLER_LEVEL_SUM"</span>,
    7577 7629 <span class="s2">"function"</span>: <span class="o">{</span>
    7578 <span class="s2">"expression"</span>: <span class="s2">"MAX"</span>,
    7630 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    7579 7631 <span class="s2">"parameter"</span>: <span class="o">{</span>
    7580 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7581 <span class="s2">"value"</span>: <span class="s2">"PRICE"</span>,
    7582 <span class="s2">"next_parameter"</span>: null
    7583 <span class="o">}</span>,
    7584 <span class="s2">"returntype"</span>: <span class="s2">"decimal(19,4)"</span>
    7585 <span class="o">}</span>,
    7586 <span class="s2">"dependent_measure_ref"</span>: null
    7587 <span class="o">}</span>,
    7632 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7633 <span class="s2">"value"</span>: <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>
    7634 <span class="o">}</span>,
    7635 <span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
    7636 <span class="o">}</span>
    7637 <span class="o">}</span>,
    7588 7638 <span class="o">{</span>
    7589 <span class="s2">"id"</span>: 4,
    7590 <span class="s2">"name"</span>: <span class="s2">"TRANS_CNT"</span>,
    7639 <span class="s2">"name"</span>: <span class="s2">"TRANS_CNT"</span>,
    7591 7640 <span class="s2">"function"</span>: <span class="o">{</span>
    7592 <span class="s2">"expression"</span>: <span class="s2">"COUNT"</span>,
    7641 <span class="s2">"expression"</span>: <span class="s2">"COUNT"</span>,
    7593 7642 <span class="s2">"parameter"</span>: <span class="o">{</span>
    7594 <span class="s2">"type"</span>: <span class="s2">"constant"</span>,
    7595 <span class="s2">"value"</span>: <span class="s2">"1"</span>,
    7596 <span class="s2">"next_parameter"</span>: null
    7597 <span class="o">}</span>,
    7643 <span class="s2">"type"</span>: <span class="s2">"constant"</span>,
    7644 <span class="s2">"value"</span>: <span class="s2">"1"</span>
    7645 <span class="o">}</span>,
    7598 7646 <span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
    7599 <span class="o">}</span>,
    7600 <span class="s2">"dependent_measure_ref"</span>: null
    7601 <span class="o">}</span>,
    7647 <span class="o">}</span>
    7648 <span class="o">}</span>,
    7602 7649 <span class="o">{</span>
    7603 <span class="s2">"id"</span>: 5,
    7604 <span class="s2">"name"</span>: <span class="s2">"ITEM_COUNT_SUM"</span>,
    7650 <span class="s2">"name"</span>: <span class="s2">"SELLER_CNT_HLL"</span>,
    7605 7651 <span class="s2">"function"</span>: <span class="o">{</span>
    7606 <span class="s2">"expression"</span>: <span class="s2">"SUM"</span>,
    7652 <span class="s2">"expression"</span>: <span class="s2">"COUNT_DISTINCT"</span>,
    7607 7653 <span class="s2">"parameter"</span>: <span class="o">{</span>
    7608 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7609 <span class="s2">"value"</span>: <span class="s2">"ITEM_COUNT"</span>,
    7610 <span class="s2">"next_parameter"</span>: null
    7611 <span class="o">}</span>,
    7612 <span class="s2">"returntype"</span>: <span class="s2">"bigint"</span>
    7613 <span class="o">}</span>,
    7614 <span class="s2">"dependent_measure_ref"</span>: null
    7654 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7655 <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.SELLER_ID"</span>
    7656 <span class="o">}</span>,
    7657 <span class="s2">"returntype"</span>: <span class="s2">"hllc(10)"</span>
    7658 <span class="o">}</span>
    7659 <span class="o">}</span>,
    7660 <span class="o">{</span>
    7661 <span class="s2">"name"</span>: <span class="s2">"TOP_SELLER"</span>,
    7662 <span class="s2">"function"</span>: <span class="o">{</span>
    7663 <span class="s2">"expression"</span>: <span class="s2">"TOP_N"</span>,
    7664 <span class="s2">"parameter"</span>: <span class="o">{</span>
    7665 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7666 <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.PRICE"</span>,
    7667 <span class="s2">"next_parameter"</span>: <span class="o">{</span>
    7668 <span class="s2">"type"</span>: <span class="s2">"column"</span>,
    7669 <span class="s2">"value"</span>: <span class="s2">"KYLIN_SALES.SELLER_ID"</span>
    7670 <span class="o">}</span>
    7671 <span class="o">}</span>,
    7672 <span class="s2">"returntype"</span>: <span class="s2">"topn(100)"</span>,
    7673 <span class="s2">"configuration"</span>: <span class="o">{</span>
    7674 <span class="s2">"topn.encoding.KYLIN_SALES.SELLER_ID"</span>: <span class="s2">"dict"</span>,
    7675 <span class="s2">"topn.encoding_version.KYLIN_SALES.SELLER_ID"</span>: <span class="s2">"1"</span>
    7676 <span class="o">}</span>
    7677 <span class="o">}</span>
    7615 7678 <span class="o">}</span>
    7616 <span class="o">]</span>,
    7679 <span class="o">]</span>,
    7617 7680 <span class="s2">"rowkey"</span>: <span class="o">{</span>
    7618 7681 <span class="s2">"rowkey_columns"</span>: <span class="o">[</span>
    7619 7682 <span class="o">{</span>
    7620 <span class="s2">"column"</span>: <span class="s2">"SELLER_ID"</span>,
    7621 <span class="s2">"length"</span>: 18,
    7622 <span class="s2">"dictionary"</span>: null,
    7623 <span class="s2">"mandatory"</span>: <span class="nb">true</span>
    7624 <span class="o">}</span>,
    7683 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.BUYER_ID"</span>,
    7684 <span class="s2">"encoding"</span>: <span class="s2">"integer:4"</span>,
    7685 <span class="s2">"encoding_version"</span>: 1,
    7686 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7687 <span class="o">}</span>,
    7625 7688 <span class="o">{</span>
    7626 <span class="s2">"column"</span>: <span class="s2">"CAL_DT"</span>,
    7627 <span class="s2">"length"</span>: 0,
    7628 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    7629 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    7630 <span class="o">}</span>,
    7689 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.SELLER_ID"</span>,
    7690 <span class="s2">"encoding"</span>: <span class="s2">"integer:4"</span>,
    7691 <span class="s2">"encoding_version"</span>: 1,
    7692 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7693 <span class="o">}</span>,
    7631 7694 <span class="o">{</span>
    7632 <span class="s2">"column"</span>: <span class="s2">"LEAF_CATEG_ID"</span>,
    7633 <span class="s2">"length"</span>: 0,
    7634 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    7635 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    7636 <span class="o">}</span>,
    7695 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.TRANS_ID"</span>,
    7696 <span class="s2">"encoding"</span>: <span class="s2">"integer:4"</span>,
    7697 <span class="s2">"encoding_version"</span>: 1,
    7698 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7699 <span class="o">}</span>,
    7637 7700 <span class="o">{</span>
    7638 <span class="s2">"column"</span>: <span class="s2">"META_CATEG_NAME"</span>,
    7639 <span class="s2">"length"</span>: 0,
    7640 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    7641 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    7642 <span class="o">}</span>,
    7701 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.PART_DT"</span>,
    7702 <span class="s2">"encoding"</span>: <span class="s2">"date"</span>,
    7703 <span class="s2">"encoding_version"</span>: 1,
    7704 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7705 <span class="o">}</span>,
    7643 7706 <span class="o">{</span>
    7644 <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL2_NAME"</span>,
    7645 <span class="s2">"length"</span>: 0,
    7646 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    7647 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    7648 <span class="o">}</span>,
    7707 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.LEAF_CATEG_ID"</span>,
    7708 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7709 <span class="s2">"encoding_version"</span>: 1,
    7710 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7711 <span class="o">}</span>,
    7649 7712 <span class="o">{</span>
    7650 <span class="s2">"column"</span>: <span class="s2">"CATEG_LVL3_NAME"</span>,
    7651 <span class="s2">"length"</span>: 0,
    7652 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    7653 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    7654 <span class="o">}</span>,
    7713 <span class="s2">"column"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME"</span>,
    7714 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7715 <span class="s2">"encoding_version"</span>: 1,
    7716 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7717 <span class="o">}</span>,
    7655 7718 <span class="o">{</span>
    7656 <span class="s2">"column"</span>: <span class="s2">"LSTG_FORMAT_NAME"</span>,
    7657 <span class="s2">"length"</span>: 12,
    7658 <span class="s2">"dictionary"</span>: null,
    7659 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    7660 <span class="o">}</span>,
    7719 <span class="s2">"column"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME"</span>,
    7720 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7721 <span class="s2">"encoding_version"</span>: 1,
    7722 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7723 <span class="o">}</span>,
    7661 7724 <span class="o">{</span>
    7662 <span class="s2">"column"</span>: <span class="s2">"LSTG_SITE_ID"</span>,
    7663 <span class="s2">"length"</span>: 0,
    7664 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    7665 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    7666 <span class="o">}</span>,
    7725 <span class="s2">"column"</span>: <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME"</span>,
    7726 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7727 <span class="s2">"encoding_version"</span>: 1,
    7728 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7729 <span class="o">}</span>,
    7667 7730 <span class="o">{</span>
    7668 <span class="s2">"column"</span>: <span class="s2">"SLR_SEGMENT_CD"</span>,
    7669 <span class="s2">"length"</span>: 0,
    7670 <span class="s2">"dictionary"</span>: <span class="s2">"true"</span>,
    7671 <span class="s2">"mandatory"</span>: <span class="nb">false</span>
    7731 <span class="s2">"column"</span>: <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>,
    7732 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7733 <span class="s2">"encoding_version"</span>: 1,
    7734 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7735 <span class="o">}</span>,
    7736 <span class="o">{</span>
    7737 <span class="s2">"column"</span>: <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>,
    7738 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7739 <span class="s2">"encoding_version"</span>: 1,
    7740 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7741 <span class="o">}</span>,
    7742 <span class="o">{</span>
    7743 <span class="s2">"column"</span>: <span class="s2">"BUYER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    7744 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7745 <span class="s2">"encoding_version"</span>: 1,
    7746 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7747 <span class="o">}</span>,
    7748 <span class="o">{</span>
    7749 <span class="s2">"column"</span>: <span class="s2">"SELLER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    7750 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7751 <span class="s2">"encoding_version"</span>: 1,
    7752 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7753 <span class="o">}</span>,
    7754 <span class="o">{</span>
    7755 <span class="s2">"column"</span>: <span class="s2">"BUYER_COUNTRY.NAME"</span>,
    7756 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7757 <span class="s2">"encoding_version"</span>: 1,
    7758 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7759 <span class="o">}</span>,
    7760 <span class="o">{</span>
    7761 <span class="s2">"column"</span>: <span class="s2">"SELLER_COUNTRY.NAME"</span>,
    7762 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7763 <span class="s2">"encoding_version"</span>: 1,
    7764 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7765 <span class="o">}</span>,
    7766 <span class="o">{</span>
    7767 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.LSTG_FORMAT_NAME"</span>,
    7768 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7769 <span class="s2">"encoding_version"</span>: 1,
    7770 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7771 <span class="o">}</span>,
    7772 <span class="o">{</span>
    7773 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.LSTG_SITE_ID"</span>,
    7774 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7775 <span class="s2">"encoding_version"</span>: 1,
    7776 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7777 <span class="o">}</span>,
    7778 <span class="o">{</span>
    7779 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.OPS_USER_ID"</span>,
    7780 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7781 <span class="s2">"encoding_version"</span>: 1,
    7782 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7783 <span class="o">}</span>,
    7784 <span class="o">{</span>
    7785 <span class="s2">"column"</span>: <span class="s2">"KYLIN_SALES.OPS_REGION"</span>,
    7786 <span class="s2">"encoding"</span>: <span class="s2">"dict"</span>,
    7787 <span class="s2">"encoding_version"</span>: 1,
    7788 <span class="s2">"isShardBy"</span>: <span class="nb">false</span>
    7672 7789 <span class="o">}</span>
    7673 <span class="o">]</span>,
    7674 <span class="s2">"aggregation_groups"</span>: <span class="o">[</span>
    7675 <span class="o">[</span>
    7676 <span class="s2">"LEAF_CATEG_ID"</span>,
    7677 <span class="s2">"META_CATEG_NAME"</span>,
    7678 <span class="s2">"CATEG_LVL2_NAME"</span>,
    7679 <span class="s2">"CATEG_LVL3_NAME"</span>,
    7680 <span class="s2">"CAL_DT"</span>
    7681 <span class="o">]</span>
    7682 7790 <span class="o">]</span>
    7683 <span class="o">}</span>,
    7684 <span class="s2">"signature"</span>: <span class="s2">"lsLAl2jL62ZApmOLZqWU3g=="</span>,
    7685 <span class="s2">"last_modified"</span>: 1445850327000,
    7686 <span class="s2">"model_name"</span>: <span class="s2">"test_kylin_with_slr_model_desc"</span>,
    7687 <span class="s2">"null_string"</span>: null,
    7791 <span class="o">}</span>,
    7688 7792 <span class="s2">"hbase_mapping"</span>: <span class="o">{</span>
    7689 7793 <span class="s2">"column_family"</span>: <span class="o">[</span>
    7690 7794 <span class="o">{</span>
    7691 <span class="s2">"name"</span>: <span class="s2">"F1"</span>,
    7795 <span class="s2">"name"</span>: <span class="s2">"F1"</span>,
    7692 7796 <span class="s2">"columns"</span>: <span class="o">[</span>
    7693 7797 <span class="o">{</span>
    7694 <span class="s2">"qualifier"</span>: <span class="s2">"M"</span>,
    7798 <span class="s2">"qualifier"</span>: <span class="s2">"M"</span>,
    7695 7799 <span class="s2">"measure_refs"</span>: <span class="o">[</span>
    7696 <span class="s2">"GMV_SUM"</span>,
    7697 <span class="s2">"GMV_MIN"</span>,
    7698 <span class="s2">"GMV_MAX"</span>,
    7699 <span class="s2">"TRANS_CNT"</span>,
    7700 <span class="s2">"ITEM_COUNT_SUM"</span>
    7800 <span class="s2">"GMV_SUM"</span>,
    7801 <span class="s2">"BUYER_LEVEL_SUM"</span>,
    7802 <span class="s2">"SELLER_LEVEL_SUM"</span>,
    7803 <span class="s2">"TRANS_CNT"</span>
    7701 7804 <span class="o">]</span>
    7702 7805 <span class="o">}</span>
    7703 7806 <span class="o">]</span>
    7807 <span class="o">}</span>,
    7808 <span class="o">{</span>
    7809 <span class="s2">"name"</span>: <span class="s2">"F2"</span>,
    7810 <span class="s2">"columns"</span>: <span class="o">[</span>
    7811 <span class="o">{</span>
    7812 <span class="s2">"qualifier"</span>: <span class="s2">"M"</span>,
    7813 <span class="s2">"measure_refs"</span>: <span class="o">[</span>
    7814 <span class="s2">"SELLER_CNT_HLL"</span>,
    7815 <span class="s2">"TOP_SELLER"</span>
    7816 <span class="o">]</span>
    7817 <span class="o">}</span>
    7818 <span class="o">]</span>
    7704 7819 <span class="o">}</span>
    7705 7820 <span class="o">]</span>
    7706 <span class="o">}</span>,
    7707 <span class="s2">"notify_list"</span>: null,
    7708 <span class="s2">"auto_merge_time_ranges"</span>: null,
    7709 <span class="s2">"retention_range"</span>: 0
    7821 <span class="o">}</span>,
    7822 <span class="s2">"aggregation_groups"</span>: <span class="o">[</span>
    7823 <span class="o">{</span>
    7824 <span class="s2">"includes"</span>: <span class="o">[</span>
    7825 <span class="s2">"KYLIN_SALES.PART_DT"</span>,
    7826 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME"</span>,
    7827 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME"</span>,
    7828 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME"</span>,
    7829 <span class="s2">"KYLIN_SALES.LEAF_CATEG_ID"</span>,
    7830 <span class="s2">"KYLIN_SALES.LSTG_FORMAT_NAME"</span>,
    7831 <span class="s2">"KYLIN_SALES.LSTG_SITE_ID"</span>,
    7832 <span class="s2">"KYLIN_SALES.OPS_USER_ID"</span>,
    7833 <span class="s2">"KYLIN_SALES.OPS_REGION"</span>,
    7834 <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>,
    7835 <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>,
    7836 <span class="s2">"BUYER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    7837 <span class="s2">"SELLER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    7838 <span class="s2">"BUYER_COUNTRY.NAME"</span>,
    7839 <span class="s2">"SELLER_COUNTRY.NAME"</span>
    7840 <span class="o">]</span>,
    7841 <span class="s2">"select_rule"</span>: <span class="o">{</span>
    7842 <span class="s2">"hierarchy_dims"</span>: <span class="o">[</span>
    7843 <span class="o">[</span>
    7844 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.META_CATEG_NAME"</span>,
    7845 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL2_NAME"</span>,
    7846 <span class="s2">"KYLIN_CATEGORY_GROUPINGS.CATEG_LVL3_NAME"</span>,
    7847 <span class="s2">"KYLIN_SALES.LEAF_CATEG_ID"</span>
    7848 <span class="o">]</span>
    7849 <span class="o">]</span>,
    7850 <span class="s2">"mandatory_dims"</span>: <span class="o">[</span>
    7851 <span class="s2">"KYLIN_SALES.PART_DT"</span>
    7852 <span class="o">]</span>,
    7853 <span class="s2">"joint_dims"</span>: <span class="o">[</span>
    7854 <span class="o">[</span>
    7855 <span class="s2">"BUYER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    7856 <span class="s2">"BUYER_COUNTRY.NAME"</span>
    7857 <span class="o">]</span>,
    7858 <span class="o">[</span>
    7859 <span class="s2">"SELLER_ACCOUNT.ACCOUNT_COUNTRY"</span>,
    7860 <span class="s2">"SELLER_COUNTRY.NAME"</span>
    7861 <span class="o">]</span>,
    7862 <span class="o">[</span>
    7863 <span class="s2">"BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL"</span>,
    7864 <span class="s2">"SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL"</span>
    7865 <span class="o">]</span>,
    7866 <span class="o">[</span>
    7867 <span class="s2">"KYLIN_SALES.LSTG_FORMAT_NAME"</span>,
    7868 <span class="s2">"KYLIN_SALES.LSTG_SITE_ID"</span>
    7869 <span class="o">]</span>,
    7870 <span class="o">[</span>
    7871 <span class="s2">"KYLIN_SALES.OPS_USER_ID"</span>,
    7872 <span class="s2">"KYLIN_SALES.OPS_REGION"</span>
    7873 <span class="o">]</span>
    7874 <span class="o">]</span>
    7875 <span class="o">}</span>
    7876 <span class="o">}</span>
    7877 <span class="o">]</span>,
    7878 <span class="s2">"signature"</span>: null,
    7879 <span class="s2">"notify_list"</span>: <span class="o">[]</span>,
    7880 <span class="s2">"status_need_notify"</span>: <span class="o">[]</span>,
    7881 <span class="s2">"partition_date_start"</span>: 1325376000000,
    7882 <span class="s2">"partition_date_end"</span>: 3153600000000,
    7883 <span class="s2">"auto_merge_time_ranges"</span>: <span class="o">[]</span>,
    7884 <span class="s2">"volatile_range"</span>: 0,
    7885 <span class="s2">"retention_range"</span>: 0,
    7886 <span class="s2">"engine_type"</span>: 2,
    7887 <span class="s2">"storage_type"</span>: 2,
    7888 <span class="s2">"override_kylin_properties"</span>: <span class="o">{</span>
    7889 <span class="s2">"kylin.cube.aggrgroup.is-mandatory-only-valid"</span>: <span class="s2">"true"</span>,
    7890 <span class="s2">"kylin.engine.spark.rdd-partition-cut-mb"</span>: <span class="s2">"500"</span>
    7891 <span class="o">}</span>,
    7892 <span class="s2">"cuboid_black_list"</span>: <span class="o">[]</span>,
    7893 <span class="s2">"parent_forward"</span>: 3,
    7894 <span class="s2">"mandatory_dimension_set_list"</span>: <span class="o">[]</span>,
    7895 <span class="s2">"snapshot_table_desc_list"</span>: <span class="o">[]</span>
    7710 7896 <span class="o">}</span>
    7711 7897 <span class="o">]</span>
    7712 7898 </code></pre>
  • kylin/site/feed.xml

     
    19 19 <description>Apache Kylin Home</description>
    20 20 <link>http://kylin.apache.org/</link>
    21 21 <atom:link href="http://kylin.apache.org/feed.xml" rel="self" type="application/rss+xml"/>
    22 <pubDate>Tue, 14 Jan 2020 05:59:14 -0800</pubDate>
    23 <lastBuildDate>Tue, 14 Jan 2020 05:59:14 -0800</lastBuildDate>
    22 <pubDate>Tue, 21 Jan 2020 05:59:15 -0800</pubDate>
    23 <lastBuildDate>Tue, 21 Jan 2020 05:59:15 -0800</lastBuildDate>
    24 24 <generator>Jekyll v2.5.3</generator>
    25 25
    26 26 <item>