{
  "uuid" : "629ab7a8-3929-4dff-b59d-2100aadccd1a",
  "last_modified" : 1585573659773,
  "version" : "3.9.9.1",
  "name" : "ci_left_join_cube",
  "is_draft" : false,
  "model_name" : "ci_left_join_model",
  "description" : null,
  "null_string" : null,
  "dimensions" : [ {
    "name" : "CAL_DT",
    "table" : "TEST_CAL_DT",
    "column" : "{FK}",
    "derived" : [ "WEEK_BEG_DT" ]
  }, {
    "name" : "ORDER_ID",
    "table" : "TEST_KYLIN_FACT",
    "column" : "ORDER_ID",
    "derived" : null
  }, {
    "name" : "TEST_DATE_ENC",
    "table" : "TEST_ORDER",
    "column" : "TEST_DATE_ENC",
    "derived" : null
  }, {
    "name" : "TEST_TIME_ENC",
    "table" : "TEST_ORDER",
    "column" : "TEST_TIME_ENC",
    "derived" : null
  }, {
    "name" : "CATEGORY",
    "table" : "TEST_CATEGORY_GROUPINGS",
    "column" : "{FK}",
    "derived" : [ "USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER" ]
  }, {
    "name" : "CATEGORY_HIERARCHY",
    "table" : "TEST_CATEGORY_GROUPINGS",
    "column" : "META_CATEG_NAME",
    "derived" : null
  }, {
    "name" : "CATEGORY_HIERARCHY",
    "table" : "TEST_CATEGORY_GROUPINGS",
    "column" : "CATEG_LVL2_NAME",
    "derived" : null
  }, {
    "name" : "CATEGORY_HIERARCHY",
    "table" : "TEST_CATEGORY_GROUPINGS",
    "column" : "CATEG_LVL3_NAME",
    "derived" : null
  }, {
    "name" : "LSTG_FORMAT_NAME",
    "table" : "TEST_KYLIN_FACT",
    "column" : "LSTG_FORMAT_NAME",
    "derived" : null
  }, {
    "name" : "SITE_ID",
    "table" : "TEST_SITES",
    "column" : "{FK}",
    "derived" : [ "SITE_NAME", "CRE_USER" ]
  }, {
    "name" : "SELLER_TYPE_CD",
    "table" : "TEST_SELLER_TYPE_DIM",
    "column" : "{FK}",
    "derived" : [ "SELLER_TYPE_DESC" ]
  }, {
    "name" : "SELLER_ID",
    "table" : "TEST_KYLIN_FACT",
    "column" : "SELLER_ID",
    "derived" : null
  }, {
    "name" : "SELLER_BUYER_LEVEL",
    "table" : "SELLER_ACCOUNT",
    "column" : "ACCOUNT_BUYER_LEVEL",
    "derived" : null
  }, {
    "name" : "SELLER_SELLER_LEVEL",
    "table" : "SELLER_ACCOUNT",
    "column" : "ACCOUNT_SELLER_LEVEL",
    "derived" : null
  }, {
    "name" : "SELLER_COUNTRY",
    "table" : "SELLER_ACCOUNT",
    "column" : "ACCOUNT_COUNTRY",
    "derived" : null
  }, {
    "name" : "SELLER_COUNTRY_NAME",
    "table" : "SELLER_COUNTRY",
    "column" : "NAME",
    "derived" : null
  }, {
    "name" : "BUYER_ID",
    "table" : "TEST_ORDER",
    "column" : "BUYER_ID",
    "derived" : null
  }, {
    "name" : "BUYER_BUYER_LEVEL",
    "table" : "BUYER_ACCOUNT",
    "column" : "ACCOUNT_BUYER_LEVEL",
    "derived" : null
  }, {
    "name" : "BUYER_SELLER_LEVEL",
    "table" : "BUYER_ACCOUNT",
    "column" : "ACCOUNT_SELLER_LEVEL",
    "derived" : null
  }, {
    "name" : "BUYER_COUNTRY",
    "table" : "BUYER_ACCOUNT",
    "column" : "ACCOUNT_COUNTRY",
    "derived" : null
  }, {
    "name" : "BUYER_COUNTRY_NAME",
    "table" : "BUYER_COUNTRY",
    "column" : "NAME",
    "derived" : null
  } ],
  "measures" : [ {
    "name" : "TRANS_CNT",
    "function" : {
      "expression" : "COUNT",
      "parameter" : {
        "type" : "constant",
        "value" : "1"
      },
      "returntype" : "bigint"
    }
  }, {
    "name" : "ITEM_COUNT_SUM",
    "function" : {
      "expression" : "SUM",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.ITEM_COUNT"
      },
      "returntype" : "bigint"
    }
  }, {
    "name" : "GMV_SUM",
    "function" : {
      "expression" : "SUM",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.PRICE"
      },
      "returntype" : "decimal(19,4)"
    }
  }, {
    "name" : "GMV_CNT",
    "function" : {
      "expression" : "COUNT",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.PRICE"
      },
      "returntype" : "bigint"
    }
  }, {
    "name" : "GMV_MIN",
    "function" : {
      "expression" : "MIN",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.PRICE"
      },
      "returntype" : "decimal(19,4)"
    }
  }, {
    "name" : "GMV_MAX",
    "function" : {
      "expression" : "MAX",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.PRICE"
      },
      "returntype" : "decimal(19,4)"
    }
  }, {
    "name" : "SELLER_HLL",
    "function" : {
      "expression" : "COUNT_DISTINCT",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.SELLER_ID"
      },
      "returntype" : "hllc(10)"
    }
  }, {
    "name" : "SELLER_FORMAT_HLL",
    "function" : {
      "expression" : "COUNT_DISTINCT",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.LSTG_FORMAT_NAME",
        "next_parameter" : {
          "type" : "column",
          "value" : "TEST_KYLIN_FACT.SELLER_ID"
        }
      },
      "returntype" : "hllc(10)"
    }
  }, {
    "name" : "TOP_SELLER",
    "function" : {
      "expression" : "TOP_N",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.PRICE",
        "next_parameter" : {
          "type" : "column",
          "value" : "TEST_KYLIN_FACT.SELLER_ID"
        }
      },
      "returntype" : "topn(100,4)",
      "configuration" : {
        "topn.encoding.TEST_KYLIN_FACT.SELLER_ID" : "int:4"
      }
    }
  }, {
    "name" : "TEST_COUNT_DISTINCT_BITMAP",
    "function" : {
      "expression" : "COUNT_DISTINCT",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.TEST_COUNT_DISTINCT_BITMAP"
      },
      "returntype" : "bitmap"
    }
  }, {
    "name": "GVM_PERCENTILE",
    "function": {
      "expression": "PERCENTILE_APPROX",
      "parameter": {
        "type": "column",
        "value": "TEST_KYLIN_FACT.PRICE"
      },
      "returntype": "percentile(100)"
    }
  }, {
    "name" : "TEST_COUNT_COLUMN_CNT",
    "function" : {
      "expression" : "COUNT",
      "parameter" : {
        "type" : "column",
        "value" : "TEST_KYLIN_FACT.TEST_COUNT_COLUMN"
      },
      "returntype" : "bigint"
    }
  } ],
  "dictionaries" : [ {
    "column" : "TEST_KYLIN_FACT.TEST_COUNT_DISTINCT_BITMAP",
    "builder" : "org.apache.kylin.dict.GlobalDictionaryBuilder",
    "cube" : null,
    "model" : null
  } ],
  "rowkey" : {
    "rowkey_columns" : [ {
      "column" : "TEST_KYLIN_FACT.SELLER_ID",
      "encoding" : "int:4",
      "isShardBy" : false
    }, {
      "column" : "TEST_KYLIN_FACT.ORDER_ID",
      "encoding" : "int:4",
      "isShardBy" : false
    }, {
      "column" : "TEST_KYLIN_FACT.CAL_DT",
      "encoding" : "date",
      "isShardBy" : false
    }, {
      "column" : "TEST_KYLIN_FACT.LEAF_CATEG_ID",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "TEST_CATEGORY_GROUPINGS.META_CATEG_NAME",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "TEST_CATEGORY_GROUPINGS.CATEG_LVL2_NAME",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "TEST_CATEGORY_GROUPINGS.CATEG_LVL3_NAME",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "TEST_KYLIN_FACT.LSTG_FORMAT_NAME",
      "encoding" : "fixed_length:12",
      "isShardBy" : false
    }, {
      "column" : "TEST_KYLIN_FACT.LSTG_SITE_ID",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "TEST_KYLIN_FACT.SLR_SEGMENT_CD",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "TEST_ORDER.TEST_TIME_ENC",
      "encoding" : "time",
      "isShardBy" : false
    }, {
      "column" : "TEST_ORDER.TEST_DATE_ENC",
      "encoding" : "date",
      "isShardBy" : false
    }, {
      "column" : "TEST_ORDER.BUYER_ID",
      "encoding" : "int:4",
      "isShardBy" : false
    }, {
      "column" : "BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "BUYER_ACCOUNT.ACCOUNT_SELLER_LEVEL",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "BUYER_ACCOUNT.ACCOUNT_COUNTRY",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "BUYER_COUNTRY.NAME",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "SELLER_ACCOUNT.ACCOUNT_BUYER_LEVEL",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "SELLER_ACCOUNT.ACCOUNT_COUNTRY",
      "encoding" : "dict",
      "isShardBy" : false
    }, {
      "column" : "SELLER_COUNTRY.NAME",
      "encoding" : "dict",
      "isShardBy" : false
    } ]
  },
  "hbase_mapping" : {
    "column_family" : [ {
      "name" : "F1",
      "columns" : [ {
        "qualifier" : "M",
        "measure_refs" : [ "TRANS_CNT", "ITEM_COUNT_SUM", "GMV_SUM", "GMV_CNT", "GMV_MIN", "GMV_MAX", "TEST_COUNT_COLUMN_CNT", "GVM_PERCENTILE" ]
      } ]
    }, {
      "name" : "F2",
      "columns" : [ {
        "qualifier" : "M",
        "measure_refs" : [ "SELLER_HLL", "SELLER_FORMAT_HLL", "TOP_SELLER", "TEST_COUNT_DISTINCT_BITMAP" ]
      } ]
    } ]
  },
  "aggregation_groups" : [ {
    "includes" : [ "TEST_KYLIN_FACT.CAL_DT", "TEST_KYLIN_FACT.LEAF_CATEG_ID", "TEST_KYLIN_FACT.LSTG_FORMAT_NAME", "TEST_KYLIN_FACT.LSTG_SITE_ID", "TEST_KYLIN_FACT.SLR_SEGMENT_CD", "TEST_CATEGORY_GROUPINGS.META_CATEG_NAME", "TEST_CATEGORY_GROUPINGS.CATEG_LVL2_NAME", "TEST_CATEGORY_GROUPINGS.CATEG_LVL3_NAME" ],
    "select_rule" : {
      "hierarchy_dims" : [ [ "TEST_CATEGORY_GROUPINGS.META_CATEG_NAME", "TEST_CATEGORY_GROUPINGS.CATEG_LVL2_NAME", "TEST_CATEGORY_GROUPINGS.CATEG_LVL3_NAME", "TEST_KYLIN_FACT.LEAF_CATEG_ID" ] ],
      "mandatory_dims" : [ ],
      "joint_dims" : [ [ "TEST_KYLIN_FACT.LSTG_FORMAT_NAME", "TEST_KYLIN_FACT.LSTG_SITE_ID", "TEST_KYLIN_FACT.SLR_SEGMENT_CD" ] ],
      "dim_cap" : 5
    }
  }, {
    "includes" : [ "TEST_KYLIN_FACT.CAL_DT", "TEST_KYLIN_FACT.LEAF_CATEG_ID", "TEST_KYLIN_FACT.LSTG_FORMAT_NAME", "TEST_KYLIN_FACT.LSTG_SITE_ID", "TEST_KYLIN_FACT.SLR_SEGMENT_CD", "TEST_CATEGORY_GROUPINGS.META_CATEG_NAME", "TEST_CATEGORY_GROUPINGS.CATEG_LVL2_NAME", "TEST_CATEGORY_GROUPINGS.CATEG_LVL3_NAME", "TEST_KYLIN_FACT.SELLER_ID", "SELLER_ACCOUNT.ACCOUNT_BUYER_LEVEL", "SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL", "SELLER_ACCOUNT.ACCOUNT_COUNTRY", "SELLER_COUNTRY.NAME", "TEST_KYLIN_FACT.ORDER_ID", "TEST_ORDER.TEST_DATE_ENC", "TEST_ORDER.TEST_TIME_ENC", "TEST_ORDER.BUYER_ID", "BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL", "BUYER_ACCOUNT.ACCOUNT_SELLER_LEVEL", "BUYER_ACCOUNT.ACCOUNT_COUNTRY", "BUYER_COUNTRY.NAME" ],
    "select_rule" : {
      "hierarchy_dims" : [ ],
      "mandatory_dims" : [ "TEST_KYLIN_FACT.CAL_DT" ],
      "joint_dims" : [ [ "TEST_CATEGORY_GROUPINGS.META_CATEG_NAME", "TEST_CATEGORY_GROUPINGS.CATEG_LVL2_NAME", "TEST_CATEGORY_GROUPINGS.CATEG_LVL3_NAME", "TEST_KYLIN_FACT.LEAF_CATEG_ID" ], [ "TEST_KYLIN_FACT.LSTG_FORMAT_NAME", "TEST_KYLIN_FACT.LSTG_SITE_ID", "TEST_KYLIN_FACT.SLR_SEGMENT_CD" ], [ "TEST_KYLIN_FACT.SELLER_ID", "SELLER_ACCOUNT.ACCOUNT_BUYER_LEVEL", "SELLER_ACCOUNT.ACCOUNT_SELLER_LEVEL", "SELLER_ACCOUNT.ACCOUNT_COUNTRY", "SELLER_COUNTRY.NAME" ], [ "TEST_KYLIN_FACT.ORDER_ID", "TEST_ORDER.TEST_DATE_ENC", "TEST_ORDER.TEST_TIME_ENC", "TEST_ORDER.BUYER_ID", "BUYER_ACCOUNT.ACCOUNT_BUYER_LEVEL", "BUYER_ACCOUNT.ACCOUNT_SELLER_LEVEL", "BUYER_ACCOUNT.ACCOUNT_COUNTRY", "BUYER_COUNTRY.NAME" ] ],
      "dim_cap" : 3
    }
  } ],
  "signature" : "KvuDyHpzHGkV20PWwYxJhQ==",
  "notify_list" : null,
  "status_need_notify" : [ ],
  "partition_date_start" : 1325376000000,
  "partition_date_end" : 3153600000000,
  "auto_merge_time_ranges" : [ ],
  "volatile_range" : 0,
  "retention_range" : 0,
  "engine_type" : 6,
  "storage_type" : 4,
  "override_kylin_properties" : {
  },
  "cuboid_black_list" : [ ],
  "parent_forward" : 3,
  "mandatory_dimension_set_list" : [ ],
  "snapshot_table_desc_list" : [ ]
}