{
  "uuid": "bbbba905-1fc6-4f67-985c-38fa5aeafd92",
  "name": "test_kylin_cube_with_slr_left_join_desc",
  "description": null,
  "dimensions": [
    {
      "name": "CAL_DT",
      "table": "EDW.TEST_CAL_DT",
      "column": "{FK}",
      "derived": [
        "WEEK_BEG_DT"
      ]
    },
    {
      "name": "CATEGORY",
      "table": "DEFAULT.TEST_CATEGORY_GROUPINGS",
      "column": "META_CATEG_NAME",
      "derived": null
    },
    {
      "name": "CATEGORY",
      "table": "DEFAULT.TEST_CATEGORY_GROUPINGS",
      "column": "CATEG_LVL2_NAME",
      "derived": null
    },
    {
      "name": "CATEGORY",
      "table": "DEFAULT.TEST_CATEGORY_GROUPINGS",
      "column": "CATEG_LVL3_NAME",
      "derived": null
    },
    {
      "name": "CATEGORY_DERIVED",
      "table": "DEFAULT.TEST_CATEGORY_GROUPINGS",
      "column": "{FK}",
      "derived": [
        "USER_DEFINED_FIELD1",
        "USER_DEFINED_FIELD3",
        "UPD_DATE",
        "UPD_USER"
      ]
    },
    {
      "name": "LSTG_FORMAT_NAME",
      "table": "DEFAULT.TEST_KYLIN_FACT",
      "column": "LSTG_FORMAT_NAME",
      "derived": null
    },
    {
      "name": "SITE_ID",
      "table": "EDW.TEST_SITES",
      "column": "{FK}",
      "derived": [
        "SITE_NAME",
        "CRE_USER"
      ]
    },
    {
      "name": "SELLER_TYPE_CD",
      "table": "EDW.TEST_SELLER_TYPE_DIM",
      "column": "{FK}",
      "derived": [
        "SELLER_TYPE_DESC"
      ]
    },
    {
      "name": "SELLER_ID",
      "table": "DEFAULT.TEST_KYLIN_FACT",
      "column": "SELLER_ID",
      "derived": null
    }
  ],
  "measures": [
    {
      "name": "GMV_SUM",
      "function": {
        "expression": "SUM",
        "parameter": {
          "type": "column",
          "value": "PRICE",
          "next_parameter": null
        },
        "returntype": "decimal(19,4)"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "GMV_MIN",
      "function": {
        "expression": "MIN",
        "parameter": {
          "type": "column",
          "value": "PRICE",
          "next_parameter": null
        },
        "returntype": "decimal(19,4)"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "GMV_MAX",
      "function": {
        "expression": "MAX",
        "parameter": {
          "type": "column",
          "value": "PRICE",
          "next_parameter": null
        },
        "returntype": "decimal(19,4)"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "TRANS_CNT",
      "function": {
        "expression": "COUNT",
        "parameter": {
          "type": "constant",
          "value": "1",
          "next_parameter": null
        },
        "returntype": "bigint"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "ITEM_COUNT_SUM",
      "function": {
        "expression": "SUM",
        "parameter": {
          "type": "column",
          "value": "ITEM_COUNT",
          "next_parameter": null
        },
        "returntype": "bigint"
      },
      "dependent_measure_ref": null
    },
    {
      "name": "SELLER_CNT_HLL",
      "function": {
        "expression": "COUNT_DISTINCT",
        "parameter": {
          "type": "column",
          "value": "SELLER_ID",
          "next_parameter": null
        },
        "returntype": "hllc(12)"
      },
      "dependent_measure_ref": null
    }, {
      "name" : "TOP_SELLER",
      "function" : {
        "expression" : "TOP_N",
        "parameter" : {
          "type" : "column",
          "value" : "PRICE",
          "next_parameter" : {
            "type" : "column",
            "value" : "SELLER_ID",
            "next_parameter" : null
          }
        },
        "returntype" : "topn(100)",
        "configuration": {"topn.encoding.SELLER_ID" : "int:4"}
      },
      "dependent_measure_ref" : null
    }
  ],
  "rowkey": {
    "rowkey_columns": [
      {
        "column": "seller_id",
        "encoding": "int:4"
      },
      {
        "column": "cal_dt",
        "encoding": "dict"
      },
      {
        "column": "leaf_categ_id",
        "encoding": "dict"
      },
      {
        "column": "meta_categ_name",
        "encoding": "dict"
      },
      {
        "column": "categ_lvl2_name",
        "encoding": "dict"
      },
      {
        "column": "categ_lvl3_name",
        "encoding": "dict"
      },
      {
        "column": "lstg_format_name",
        "encoding": "fixed_length:12"
      },
      {
        "column": "lstg_site_id",
        "encoding": "dict"
      },
      {
        "column": "slr_segment_cd",
        "encoding": "dict"
      }
    ]
  },
  "signature": null,
  "last_modified": 1448959801301,
  "model_name": "test_kylin_left_join_model_desc",
  "null_string": null,
  "hbase_mapping": {
    "column_family": [
      {
        "name": "f1",
        "columns": [
          {
            "qualifier": "m",
            "measure_refs": [
              "gmv_sum",
              "gmv_min",
              "gmv_max",
              "trans_cnt",
              "item_count_sum"
            ]
          }
        ]
      },
      {
        "name": "F2",
        "columns": [
          {
            "qualifier": "M",
            "measure_refs": [
              "seller_cnt_hll"
            ]
          }
        ]
      },
      {
        "name" : "F3",
        "columns" : [ {
          "qualifier" : "M",
          "measure_refs" : [ "TOP_SELLER" ]
        } ]
      }
    ]
  },
  "aggregation_groups": [
    {
      "includes": [
        "cal_dt",
        "categ_lvl2_name",
        "categ_lvl3_name",
        "leaf_categ_id",
        "lstg_format_name",
        "lstg_site_id",
        "meta_categ_name",
        "seller_id",
        "slr_segment_cd"
      ],
      "select_rule": {
        "hierarchy_dims": [
          [
            "META_CATEG_NAME",
            "CATEG_LVL2_NAME",
            "CATEG_LVL3_NAME"
          ]
        ],
        "mandatory_dims": [],
        "joint_dims": [
          [
            "lstg_format_name",
            "lstg_site_id",
            "slr_segment_cd"
          ]
        ]
      }
    }
  ],
  "notify_list": null,
  "status_need_notify": [],
  "auto_merge_time_ranges": null,
  "retention_range": 0,
  "engine_type": 6,
  "storage_type": 4,
  "override_kylin_properties": {
    "kylin.cube.algorithm": "INMEM"
  },
  "partition_date_start": 0
}