You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@kylin.apache.org by li...@apache.org on 2015/01/31 13:01:45 UTC
[18/50] incubator-kylin git commit: Update sample cube descriptions
with new metadata schema
Update sample cube descriptions with new metadata schema
Project: http://git-wip-us.apache.org/repos/asf/incubator-kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-kylin/commit/fda51eae
Tree: http://git-wip-us.apache.org/repos/asf/incubator-kylin/tree/fda51eae
Diff: http://git-wip-us.apache.org/repos/asf/incubator-kylin/diff/fda51eae
Branch: refs/heads/inverted-index
Commit: fda51eae24b55d49ec987b729392fe92a2fa4942
Parents: 2e2a84e
Author: Shao Feng, Shi <sh...@hotmail.com>
Authored: Wed Jan 28 17:03:08 2015 +0800
Committer: Shao Feng, Shi <sh...@hotmail.com>
Committed: Wed Jan 28 17:03:08 2015 +0800
----------------------------------------------------------------------
.../test_kylin_cube_with_slr_desc.json | 300 +++++++------
...test_kylin_cube_with_slr_left_join_desc.json | 300 +++++++------
.../test_kylin_cube_without_slr_desc.json | 421 +++++++++----------
...t_kylin_cube_without_slr_left_join_desc.json | 419 +++++++++---------
...est_kylin_with_slr_left_join_model_desc.json | 95 +++--
.../test_kylin_with_slr_model_desc.json | 96 ++---
..._kylin_without_slr_left_join_model_desc.json | 96 ++---
.../test_kylin_without_slr_model_desc.json | 96 ++---
8 files changed, 898 insertions(+), 925 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fda51eae/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_desc.json b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_desc.json
index 6c4e5a0..9f36193 100644
--- a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_desc.json
+++ b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_desc.json
@@ -1,133 +1,167 @@
-{
- "uuid": "a24ca905-1fc6-4f67-985c-38fa5aeafd92",
- "name": "test_kylin_cube_with_slr_desc",
- "model_name": "test_kylin_with_slr_model_desc",
- "filter_condition": null,
- "cube_partition_desc": {
- "partition_date_column": "default.test_kylin_fact.cal_dt",
- "partition_date_start": 0,
- "cube_partition_type": "APPEND"
- },
- "dimensions": [
- {
- "name": "cal_dt",
- "table": "edw.test_cal_dt",
- "derived": ["week_beg_dt"]
- },
- {
- "name": "category",
- "table": "default.test_category_groupings",
- "column": ["meta_categ_name", "categ_lvl2_name", "categ_lvl3_name"],
- "hierarchy": true
- },
- {
- "name": "category_derived",
- "table": "default.test_category_groupings",
- "derived": ["USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER"]
- },
- {
- "name": "lstg_format_name",
- "table": "default.test_kylin_fact",
- "column": ["lstg_format_name"]
- },
- {
- "name": "site_id",
- "table": "edw.test_sites",
- "derived": ["site_name", "cre_user"]
- },
- {
- "name": "seller_type_cd",
- "table": "edw.test_seller_type_dim",
- "derived": ["seller_type_desc"]
- },
- {
- "name": "seller_id",
- "table": "default.test_kylin_fact",
- "column": ["seller_id"]
- }
- ],
- "measures": [
- {
- "id": "1",
- "name": "gmv_sum",
- "function": {
- "expression": "sum",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "2",
- "name": "gmv_min",
- "function": {
- "expression": "min",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "3",
- "name": "gmv_max",
- "function": {
- "expression": "max",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "4",
- "name": "trans_cnt",
- "function": {
- "expression": "count",
- "returntype": "bigint",
- "parameter": {
- "type": "constant",
- "value": "1"
- }
- }
- }
- ],
- "rowkey":{
- "rowkey_columns": [
- { "column": "seller_id", "dictionary": "true", "mandatory": "true" },
- { "column": "cal_dt", "dictionary": "true" },
- { "column": "leaf_categ_id", "dictionary": "true" },
- { "column": "meta_categ_name", "dictionary": "true" },
- { "column": "categ_lvl2_name", "dictionary": "true" },
- { "column": "categ_lvl3_name", "dictionary": "true" },
- { "column": "lstg_format_name", "dictionary": "true" },
- { "column": "lstg_site_id", "dictionary": "true" },
- { "column": "slr_segment_cd", "dictionary": "true" }
- ],
- "aggregation_groups": [
- ["leaf_categ_id","meta_categ_name","categ_lvl2_name","categ_lvl3_name","cal_dt"]
- ]
- },
- "hbase_mapping": {
- "column_family": [
- {
- "name": "f1",
- "columns": [
- {
- "qualifier": "m",
- "measure_refs": [
- "gmv_sum",
- "gmv_min",
- "gmv_max",
- "trans_cnt"
- ]
- }
- ]
- }
- ]
- }
-}
+{
+ "uuid" : "a24ca905-1fc6-4f67-985c-38fa5aeafd92",
+ "name" : "test_kylin_cube_with_slr_desc",
+ "description" : null,
+ "dimensions" : [ {
+ "id" : 0,
+ "name" : "CAL_DT",
+ "table" : "EDW.TEST_CAL_DT",
+ "column" : null,
+ "derived" : [ "WEEK_BEG_DT" ],
+ "hierarchy" : false
+ }, {
+ "id" : 1,
+ "name" : "CATEGORY",
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "column" : null,
+ "derived" : [ "USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER" ],
+ "hierarchy" : false
+ }, {
+ "id" : 2,
+ "name" : "CATEGORY_HIERARCHY",
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "column" : [ "META_CATEG_NAME", "CATEG_LVL2_NAME", "CATEG_LVL3_NAME" ],
+ "derived" : null,
+ "hierarchy" : true
+ }, {
+ "id" : 3,
+ "name" : "LSTG_FORMAT_NAME",
+ "table" : "DEFAULT.TEST_KYLIN_FACT",
+ "column" : [ "LSTG_FORMAT_NAME" ],
+ "derived" : null,
+ "hierarchy" : false
+ }, {
+ "id" : 4,
+ "name" : "SITE_ID",
+ "table" : "EDW.TEST_SITES",
+ "column" : null,
+ "derived" : [ "SITE_NAME", "CRE_USER" ],
+ "hierarchy" : false
+ }, {
+ "id" : 5,
+ "name" : "SELLER_TYPE_CD",
+ "table" : "EDW.TEST_SELLER_TYPE_DIM",
+ "column" : null,
+ "derived" : [ "SELLER_TYPE_DESC" ],
+ "hierarchy" : false
+ }, {
+ "id" : 6,
+ "name" : "SELLER_ID",
+ "table" : "DEFAULT.TEST_KYLIN_FACT",
+ "column" : [ "SELLER_ID" ],
+ "derived" : null,
+ "hierarchy" : false
+ } ],
+ "measures" : [ {
+ "id" : 1,
+ "name" : "GMV_SUM",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 2,
+ "name" : "GMV_MIN",
+ "function" : {
+ "expression" : "MIN",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 3,
+ "name" : "GMV_MAX",
+ "function" : {
+ "expression" : "MAX",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 4,
+ "name" : "TRANS_CNT",
+ "function" : {
+ "expression" : "COUNT",
+ "parameter" : {
+ "type" : "constant",
+ "value" : "1"
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ } ],
+ "rowkey" : {
+ "rowkey_columns" : [ {
+ "column" : "seller_id",
+ "length" : 18,
+ "dictionary" : null,
+ "mandatory" : true
+ }, {
+ "column" : "cal_dt",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "leaf_categ_id",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "meta_categ_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "categ_lvl2_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "categ_lvl3_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "lstg_format_name",
+ "length" : 12,
+ "dictionary" : null,
+ "mandatory" : false
+ }, {
+ "column" : "lstg_site_id",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "slr_segment_cd",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ } ],
+ "aggregation_groups" : [ [ "leaf_categ_id", "meta_categ_name", "categ_lvl2_name", "categ_lvl3_name", "cal_dt" ] ]
+ },
+ "signature" : "lsLAl2jL62ZApmOLZqWU3g==",
+ "last_modified" : 1422435345330,
+ "model_name" : "test_kylin_with_slr_model_desc",
+ "null_string" : null,
+ "hbase_mapping" : {
+ "column_family" : [ {
+ "name" : "f1",
+ "columns" : [ {
+ "qualifier" : "m",
+ "measure_refs" : [ "gmv_sum", "gmv_min", "gmv_max", "trans_cnt" ]
+ } ]
+ } ]
+ },
+ "notify_list" : null
+}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fda51eae/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_left_join_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_left_join_desc.json b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_left_join_desc.json
index 5335580..b572a17 100644
--- a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_left_join_desc.json
+++ b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_with_slr_left_join_desc.json
@@ -1,133 +1,167 @@
-{
- "uuid": "bbbba905-1fc6-4f67-985c-38fa5aeafd92",
- "name": "test_kylin_cube_with_slr_left_join_desc",
- "model_name": "test_kylin_with_slr_left_join_model_desc",
- "cube_partition_desc": {
- "partition_date_column": "default.test_kylin_fact.cal_dt",
- "partition_date_start": 0,
- "cube_partition_type": "APPEND"
- },
- "filter_condition": null,
- "dimensions": [
- {
- "name": "cal_dt",
- "table": "edw.test_cal_dt",
- "derived": ["week_beg_dt"]
- },
- {
- "name": "category",
- "table": "default.test_category_groupings",
- "column": ["meta_categ_name", "categ_lvl2_name", "categ_lvl3_name"],
- "hierarchy": true
- },
- {
- "name": "category_derived",
- "table": "default.test_category_groupings",
- "derived": ["USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER"]
- },
- {
- "name": "lstg_format_name",
- "table": "default.test_kylin_fact",
- "column": ["lstg_format_name"]
- },
- {
- "name": "site_id",
- "table": "edw.test_sites",
- "derived": ["site_name", "cre_user"]
- },
- {
- "name": "seller_type_cd",
- "table": "edw.test_seller_type_dim",
- "derived": ["seller_type_desc"]
- },
- {
- "name": "seller_id",
- "table": "default.test_kylin_fact",
- "column": ["seller_id"]
- }
- ],
- "measures": [
- {
- "id": "1",
- "name": "gmv_sum",
- "function": {
- "expression": "sum",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "2",
- "name": "gmv_min",
- "function": {
- "expression": "min",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "3",
- "name": "gmv_max",
- "function": {
- "expression": "max",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "4",
- "name": "trans_cnt",
- "function": {
- "expression": "count",
- "returntype": "bigint",
- "parameter": {
- "type": "constant",
- "value": "1"
- }
- }
- }
- ],
- "rowkey":{
- "rowkey_columns": [
- { "column": "seller_id", "dictionary": "true", "mandatory": "true" },
- { "column": "cal_dt", "dictionary": "true" },
- { "column": "leaf_categ_id", "dictionary": "true" },
- { "column": "meta_categ_name", "dictionary": "true" },
- { "column": "categ_lvl2_name", "dictionary": "true" },
- { "column": "categ_lvl3_name", "dictionary": "true" },
- { "column": "lstg_format_name", "dictionary": "true" },
- { "column": "lstg_site_id", "dictionary": "true" },
- { "column": "slr_segment_cd", "dictionary": "true" }
- ],
- "aggregation_groups": [
- ["leaf_categ_id","meta_categ_name","categ_lvl2_name","categ_lvl3_name","cal_dt"]
- ]
- },
- "hbase_mapping": {
- "column_family": [
- {
- "name": "f1",
- "columns": [
- {
- "qualifier": "m",
- "measure_refs": [
- "gmv_sum",
- "gmv_min",
- "gmv_max",
- "trans_cnt"
- ]
- }
- ]
- }
- ]
- }
-}
+{
+ "uuid" : "bbbba905-1fc6-4f67-985c-38fa5aeafd92",
+ "name" : "test_kylin_cube_with_slr_left_join_desc",
+ "description" : null,
+ "dimensions" : [ {
+ "id" : 0,
+ "name" : "CAL_DT",
+ "table" : "EDW.TEST_CAL_DT",
+ "column" : null,
+ "derived" : [ "WEEK_BEG_DT" ],
+ "hierarchy" : false
+ }, {
+ "id" : 1,
+ "name" : "CATEGORY",
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "column" : [ "META_CATEG_NAME", "CATEG_LVL2_NAME", "CATEG_LVL3_NAME" ],
+ "derived" : null,
+ "hierarchy" : true
+ }, {
+ "id" : 2,
+ "name" : "CATEGORY_DERIVED",
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "column" : null,
+ "derived" : [ "USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER" ],
+ "hierarchy" : false
+ }, {
+ "id" : 3,
+ "name" : "LSTG_FORMAT_NAME",
+ "table" : "DEFAULT.TEST_KYLIN_FACT",
+ "column" : [ "LSTG_FORMAT_NAME" ],
+ "derived" : null,
+ "hierarchy" : false
+ }, {
+ "id" : 4,
+ "name" : "SITE_ID",
+ "table" : "EDW.TEST_SITES",
+ "column" : null,
+ "derived" : [ "SITE_NAME", "CRE_USER" ],
+ "hierarchy" : false
+ }, {
+ "id" : 5,
+ "name" : "SELLER_TYPE_CD",
+ "table" : "EDW.TEST_SELLER_TYPE_DIM",
+ "column" : null,
+ "derived" : [ "SELLER_TYPE_DESC" ],
+ "hierarchy" : false
+ }, {
+ "id" : 6,
+ "name" : "SELLER_ID",
+ "table" : "DEFAULT.TEST_KYLIN_FACT",
+ "column" : [ "SELLER_ID" ],
+ "derived" : null,
+ "hierarchy" : false
+ } ],
+ "measures" : [ {
+ "id" : 1,
+ "name" : "GMV_SUM",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 2,
+ "name" : "GMV_MIN",
+ "function" : {
+ "expression" : "MIN",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 3,
+ "name" : "GMV_MAX",
+ "function" : {
+ "expression" : "MAX",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 4,
+ "name" : "TRANS_CNT",
+ "function" : {
+ "expression" : "COUNT",
+ "parameter" : {
+ "type" : "constant",
+ "value" : "1"
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ } ],
+ "rowkey" : {
+ "rowkey_columns" : [ {
+ "column" : "seller_id",
+ "length" : 18,
+ "dictionary" : null,
+ "mandatory" : true
+ }, {
+ "column" : "cal_dt",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "leaf_categ_id",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "meta_categ_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "categ_lvl2_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "categ_lvl3_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "lstg_format_name",
+ "length" : 12,
+ "dictionary" : null,
+ "mandatory" : false
+ }, {
+ "column" : "lstg_site_id",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "slr_segment_cd",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ } ],
+ "aggregation_groups" : [ [ "leaf_categ_id", "meta_categ_name", "categ_lvl2_name", "categ_lvl3_name", "cal_dt" ] ]
+ },
+ "signature" : "ljba0vaTnt00lU4rdhG9Xw==",
+ "last_modified" : 1422435345352,
+ "model_name" : "test_kylin_with_slr_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" ]
+ } ]
+ } ]
+ },
+ "notify_list" : null
+}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fda51eae/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_desc.json b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_desc.json
index fd58dbd..1ab02ac 100644
--- a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_desc.json
+++ b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_desc.json
@@ -1,226 +1,197 @@
-{
- "uuid": "9ac9b7a8-3929-4dff-b59d-2100aadc8dbf",
- "name": "test_kylin_cube_without_slr_desc",
- "model_name": "test_kylin_without_slr_model_desc",
- "capacity": "SMALL",
- "cube_partition_desc": {
- "partition_date_column": null,
- "partition_date_start": null,
- "cube_partition_type": "APPEND"
- },
- "filter_condition": null,
- "dimensions": [
- {
- "name": "cal_dt",
- "table": "edw.test_cal_dt",
- "derived": [
- "week_beg_dt"
- ]
- },
- {
- "name": "category",
- "table": "default.test_category_groupings",
- "column": ["meta_categ_name", "categ_lvl2_name", "categ_lvl3_name"],
- "hierarchy": true
- },
- {
- "name": "category_derived",
- "table": "default.test_category_groupings",
- "derived": [
- "USER_DEFINED_FIELD1",
- "USER_DEFINED_FIELD3",
- "UPD_DATE",
- "UPD_USER"
- ]
- },
- {
- "name": "lstg_format_name",
- "table": "default.test_kylin_fact",
- "column": ["lstg_format_name"]
- },
- {
- "name": "site_id",
- "table": "edw.test_sites",
- "derived": [
- "site_name",
- "cre_user"
- ]
- },
- {
- "name": "seller_type_cd",
- "table": "edw.test_seller_type_dim",
- "derived": [
- "seller_type_desc"
- ]
- }
- ],
- "measures": [
- {
- "id": "1",
- "name": "gmv_sum",
- "function": {
- "expression": "sum",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "2",
- "name": "gmv_min",
- "function": {
- "expression": "min",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "3",
- "name": "gmv_max",
- "function": {
- "expression": "max",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "4",
- "name": "trans_cnt",
- "function": {
- "expression": "count",
- "returntype": "bigint",
- "parameter": {
- "type": "constant",
- "value": "1"
- }
- }
- },
- {
- "id": "5",
- "name": "seller_cnt_hll",
- "function": {
- "expression": "count_distinct",
- "returntype": "hllc(10)",
- "parameter": {
- "type": "column",
- "value": "seller_id"
- }
- }
- },
- {
- "id": "6",
- "name": "seller_cnt_long",
- "function": {
- "expression": "count_distinct",
- "returntype": "bigint",
- "parameter": {
- "type": "column",
- "value": "seller_id"
- }
- },
- "dependent_measure_ref" : "seller_cnt_hll"
- },
- {
- "id": "7",
- "name": "seller_format_cnt",
- "function": {
- "expression": "count_distinct",
- "returntype": "hllc(10)",
- "parameter": {
- "type": "column",
- "value": "seller_id, lstg_format_name"
- }
- }
- }
- ],
- "rowkey": {
- "rowkey_columns": [
- {
- "column": "cal_dt",
- "dictionary": "true",
- "mandatory": "true"
- },
- {
- "column": "leaf_categ_id",
- "dictionary": "true"
- },
- {
- "column": "meta_categ_name",
- "dictionary": "true"
- },
- {
- "column": "categ_lvl2_name",
- "dictionary": "true"
- },
- {
- "column": "categ_lvl3_name",
- "dictionary": "true"
- },
- {
- "column": "lstg_format_name",
- "dictionary": "true"
- },
- {
- "column": "lstg_site_id",
- "dictionary": "true"
- },
- {
- "column": "slr_segment_cd",
- "dictionary": "true"
- }
- ],
- "aggregation_groups": [
- [
- "lstg_format_name",
- "lstg_site_id",
- "slr_segment_cd"
- ],
- [
- "leaf_categ_id",
- "meta_categ_name",
- "categ_lvl3_name",
- "categ_lvl2_name",
- "lstg_format_name"
- ]
- ]
- },
- "hbase_mapping": {
- "column_family": [
- {
- "name": "f1",
- "columns": [
- {
- "qualifier": "m",
- "measure_refs": [
- "gmv_sum",
- "gmv_min",
- "gmv_max",
- "trans_cnt",
- "seller_cnt_long"
- ]
- }
- ]
- },
- {
- "name": "f2",
- "columns": [
- {
- "qualifier": "m",
- "measure_refs": [
- "seller_cnt_hll",
- "seller_format_cnt"
- ]
- }
- ]
- }
- ]
- }
+{
+ "uuid" : "9ac9b7a8-3929-4dff-b59d-2100aadc8dbf",
+ "name" : "test_kylin_cube_without_slr_desc",
+ "description" : null,
+ "dimensions" : [ {
+ "id" : 0,
+ "name" : "CAL_DT",
+ "table" : "EDW.TEST_CAL_DT",
+ "column" : null,
+ "derived" : [ "WEEK_BEG_DT" ],
+ "hierarchy" : false
+ }, {
+ "id" : 1,
+ "name" : "CATEGORY",
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "column" : null,
+ "derived" : [ "USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER" ],
+ "hierarchy" : false
+ }, {
+ "id" : 2,
+ "name" : "CATEGORY_HIERARCHY",
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "column" : [ "META_CATEG_NAME", "CATEG_LVL2_NAME", "CATEG_LVL3_NAME" ],
+ "derived" : null,
+ "hierarchy" : true
+ }, {
+ "id" : 3,
+ "name" : "LSTG_FORMAT_NAME",
+ "table" : "DEFAULT.TEST_KYLIN_FACT",
+ "column" : [ "LSTG_FORMAT_NAME" ],
+ "derived" : null,
+ "hierarchy" : false
+ }, {
+ "id" : 4,
+ "name" : "SITE_ID",
+ "table" : "EDW.TEST_SITES",
+ "column" : null,
+ "derived" : [ "SITE_NAME", "CRE_USER" ],
+ "hierarchy" : false
+ }, {
+ "id" : 5,
+ "name" : "SELLER_TYPE_CD",
+ "table" : "EDW.TEST_SELLER_TYPE_DIM",
+ "column" : null,
+ "derived" : [ "SELLER_TYPE_DESC" ],
+ "hierarchy" : false
+ } ],
+ "measures" : [ {
+ "id" : 1,
+ "name" : "GMV_SUM",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 2,
+ "name" : "GMV_MIN",
+ "function" : {
+ "expression" : "MIN",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 3,
+ "name" : "GMV_MAX",
+ "function" : {
+ "expression" : "MAX",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 4,
+ "name" : "TRANS_CNT",
+ "function" : {
+ "expression" : "COUNT",
+ "parameter" : {
+ "type" : "constant",
+ "value" : "1"
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 5,
+ "name" : "SELLER_CNT_HLL",
+ "function" : {
+ "expression" : "COUNT_DISTINCT",
+ "parameter" : {
+ "type" : "column",
+ "value" : "SELLER_ID"
+ },
+ "returntype" : "hllc(10)"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 6,
+ "name" : "SELLER_CNT_LONG",
+ "function" : {
+ "expression" : "COUNT_DISTINCT",
+ "parameter" : {
+ "type" : "column",
+ "value" : "SELLER_ID"
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : "SELLER_CNT_HLL"
+ }, {
+ "id" : 7,
+ "name" : "SELLER_FORMAT_CNT",
+ "function" : {
+ "expression" : "COUNT_DISTINCT",
+ "parameter" : {
+ "type" : "column",
+ "value" : "LSTG_FORMAT_NAME,SELLER_ID"
+ },
+ "returntype" : "hllc(10)"
+ },
+ "dependent_measure_ref" : null
+ } ],
+ "rowkey" : {
+ "rowkey_columns" : [ {
+ "column" : "cal_dt",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : true
+ }, {
+ "column" : "leaf_categ_id",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "meta_categ_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "categ_lvl2_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "categ_lvl3_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "lstg_format_name",
+ "length" : 12,
+ "dictionary" : null,
+ "mandatory" : false
+ }, {
+ "column" : "lstg_site_id",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "slr_segment_cd",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ } ],
+ "aggregation_groups" : [ [ "lstg_format_name", "lstg_site_id", "slr_segment_cd" ], [ "leaf_categ_id", "meta_categ_name", "categ_lvl3_name", "categ_lvl2_name", "lstg_format_name" ] ]
+ },
+ "signature" : "7qJiv2MEGoGf1AAgksQmZw==",
+ "last_modified" : 1422435345362,
+ "model_name" : "test_kylin_without_slr_model_desc",
+ "null_string" : null,
+ "hbase_mapping" : {
+ "column_family" : [ {
+ "name" : "f1",
+ "columns" : [ {
+ "qualifier" : "m",
+ "measure_refs" : [ "gmv_sum", "gmv_min", "gmv_max", "trans_cnt", "seller_cnt_long" ]
+ } ]
+ }, {
+ "name" : "f2",
+ "columns" : [ {
+ "qualifier" : "m",
+ "measure_refs" : [ "seller_cnt_hll", "seller_format_cnt" ]
+ } ]
+ } ]
+ },
+ "notify_list" : null
}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fda51eae/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_left_join_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_left_join_desc.json b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_left_join_desc.json
index 0519dbc..82b680f 100644
--- a/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_left_join_desc.json
+++ b/examples/test_case_data/localmeta/cube_desc/test_kylin_cube_without_slr_left_join_desc.json
@@ -1,224 +1,197 @@
-{
- "uuid": "9ac9b7a8-3929-4dff-b59d-2100aadc8dbf",
- "name": "test_kylin_cube_without_slr_left_join_desc",
- "model_name": "test_kylin_without_slr_left_join_model_desc",
- "cube_partition_desc": {
- "partition_date_column": "default.test_kylin_fact.cal_dt",
- "partition_date_start": 0,
- "cube_partition_type": "UPDATE_INSERT"
- },
- "dimensions": [
- {
- "name": "cal_dt",
- "table": "edw.test_cal_dt",
- "derived": [
- "week_beg_dt"
- ]
- },
- {
- "name": "category",
- "table": "default.test_category_groupings",
- "column": ["meta_categ_name", "categ_lvl2_name", "categ_lvl3_name"],
- "hierarchy": true
- },
- {
- "name": "category_derived",
- "table": "default.test_category_groupings",
- "derived": [
- "USER_DEFINED_FIELD1",
- "USER_DEFINED_FIELD3",
- "UPD_DATE",
- "UPD_USER"
- ]
- },
- {
- "name": "lstg_format_name",
- "table": "default.test_kylin_fact",
- "column": ["lstg_format_name"]
- },
- {
- "name": "site_id",
- "table": "edw.test_sites",
- "derived": [
- "site_name",
- "cre_user"
- ]
- },
- {
- "name": "seller_type_cd",
- "table": "edw.test_seller_type_dim",
- "derived": [
- "seller_type_desc"
- ]
- }
- ],
- "measures": [
- {
- "id": "1",
- "name": "gmv_sum",
- "function": {
- "expression": "sum",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "2",
- "name": "gmv_min",
- "function": {
- "expression": "min",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "3",
- "name": "gmv_max",
- "function": {
- "expression": "max",
- "returntype": "decimal",
- "parameter": {
- "type": "column",
- "value": "price"
- }
- }
- },
- {
- "id": "4",
- "name": "trans_cnt",
- "function": {
- "expression": "count",
- "returntype": "bigint",
- "parameter": {
- "type": "constant",
- "value": "1"
- }
- }
- },
- {
- "id": "5",
- "name": "seller_cnt_hll",
- "function": {
- "expression": "count_distinct",
- "returntype": "hllc(10)",
- "parameter": {
- "type": "column",
- "value": "seller_id"
- }
- }
- },
- {
- "id": "6",
- "name": "seller_cnt_long",
- "function": {
- "expression": "count_distinct",
- "returntype": "bigint",
- "parameter": {
- "type": "column",
- "value": "seller_id"
- }
- },
- "dependent_measure_ref" : "seller_cnt_hll"
- },
- {
- "id": "7",
- "name": "seller_format_cnt",
- "function": {
- "expression": "count_distinct",
- "returntype": "hllc(10)",
- "parameter": {
- "type": "column",
- "value": "seller_id, lstg_format_name"
- }
- }
- }
- ],
- "rowkey": {
- "rowkey_columns": [
- {
- "column": "cal_dt",
- "dictionary": "true",
- "mandatory": "true"
- },
- {
- "column": "leaf_categ_id",
- "dictionary": "true"
- },
- {
- "column": "meta_categ_name",
- "dictionary": "true"
- },
- {
- "column": "categ_lvl2_name",
- "dictionary": "true"
- },
- {
- "column": "categ_lvl3_name",
- "dictionary": "true"
- },
- {
- "column": "lstg_format_name",
- "dictionary": "true"
- },
- {
- "column": "lstg_site_id",
- "dictionary": "true"
- },
- {
- "column": "slr_segment_cd",
- "dictionary": "true"
- }
- ],
- "aggregation_groups": [
- [
- "lstg_format_name",
- "lstg_site_id",
- "slr_segment_cd"
- ],
- [
- "leaf_categ_id",
- "meta_categ_name",
- "categ_lvl3_name",
- "categ_lvl2_name",
- "lstg_format_name"
- ]
- ]
- },
- "hbase_mapping": {
- "column_family": [
- {
- "name": "f1",
- "columns": [
- {
- "qualifier": "m",
- "measure_refs": [
- "gmv_sum",
- "gmv_min",
- "gmv_max",
- "trans_cnt",
- "seller_cnt_long"
- ]
- }
- ]
- },
- {
- "name": "f2",
- "columns": [
- {
- "qualifier": "m",
- "measure_refs": [
- "seller_cnt_hll",
- "seller_format_cnt"
- ]
- }
- ]
- }
- ]
- }
+{
+ "uuid" : "9ac9b7a8-3929-4dff-b59d-2100aadc8dbf",
+ "name" : "test_kylin_cube_without_slr_left_join_desc",
+ "description" : null,
+ "dimensions" : [ {
+ "id" : 0,
+ "name" : "CAL_DT",
+ "table" : "EDW.TEST_CAL_DT",
+ "column" : null,
+ "derived" : [ "WEEK_BEG_DT" ],
+ "hierarchy" : false
+ }, {
+ "id" : 1,
+ "name" : "CATEGORY",
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "column" : null,
+ "derived" : [ "USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER" ],
+ "hierarchy" : false
+ }, {
+ "id" : 2,
+ "name" : "CATEGORY_HIERARCHY",
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "column" : [ "META_CATEG_NAME", "CATEG_LVL2_NAME", "CATEG_LVL3_NAME" ],
+ "derived" : null,
+ "hierarchy" : true
+ }, {
+ "id" : 3,
+ "name" : "LSTG_FORMAT_NAME",
+ "table" : "DEFAULT.TEST_KYLIN_FACT",
+ "column" : [ "LSTG_FORMAT_NAME" ],
+ "derived" : null,
+ "hierarchy" : false
+ }, {
+ "id" : 4,
+ "name" : "SITE_ID",
+ "table" : "EDW.TEST_SITES",
+ "column" : null,
+ "derived" : [ "SITE_NAME", "CRE_USER" ],
+ "hierarchy" : false
+ }, {
+ "id" : 5,
+ "name" : "SELLER_TYPE_CD",
+ "table" : "EDW.TEST_SELLER_TYPE_DIM",
+ "column" : null,
+ "derived" : [ "SELLER_TYPE_DESC" ],
+ "hierarchy" : false
+ } ],
+ "measures" : [ {
+ "id" : 1,
+ "name" : "GMV_SUM",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 2,
+ "name" : "GMV_MIN",
+ "function" : {
+ "expression" : "MIN",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 3,
+ "name" : "GMV_MAX",
+ "function" : {
+ "expression" : "MAX",
+ "parameter" : {
+ "type" : "column",
+ "value" : "PRICE"
+ },
+ "returntype" : "decimal"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 4,
+ "name" : "TRANS_CNT",
+ "function" : {
+ "expression" : "COUNT",
+ "parameter" : {
+ "type" : "constant",
+ "value" : "1"
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 5,
+ "name" : "SELLER_CNT_HLL",
+ "function" : {
+ "expression" : "COUNT_DISTINCT",
+ "parameter" : {
+ "type" : "column",
+ "value" : "SELLER_ID"
+ },
+ "returntype" : "hllc(10)"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "id" : 6,
+ "name" : "SELLER_CNT_LONG",
+ "function" : {
+ "expression" : "COUNT_DISTINCT",
+ "parameter" : {
+ "type" : "column",
+ "value" : "SELLER_ID"
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : "SELLER_CNT_HLL"
+ }, {
+ "id" : 7,
+ "name" : "SELLER_FORMAT_CNT",
+ "function" : {
+ "expression" : "COUNT_DISTINCT",
+ "parameter" : {
+ "type" : "column",
+ "value" : "LSTG_FORMAT_NAME,SELLER_ID"
+ },
+ "returntype" : "hllc(10)"
+ },
+ "dependent_measure_ref" : null
+ } ],
+ "rowkey" : {
+ "rowkey_columns" : [ {
+ "column" : "cal_dt",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : true
+ }, {
+ "column" : "leaf_categ_id",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "meta_categ_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "categ_lvl2_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "categ_lvl3_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "lstg_format_name",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "lstg_site_id",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ }, {
+ "column" : "slr_segment_cd",
+ "length" : 0,
+ "dictionary" : "true",
+ "mandatory" : false
+ } ],
+ "aggregation_groups" : [ [ "lstg_format_name", "lstg_site_id", "slr_segment_cd" ], [ "leaf_categ_id", "meta_categ_name", "categ_lvl3_name", "categ_lvl2_name", "lstg_format_name" ] ]
+ },
+ "signature" : "TPdd/nnYLZnsI8TtZzoCng==",
+ "last_modified" : 1422435345373,
+ "model_name" : "test_kylin_without_slr_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", "seller_cnt_long" ]
+ } ]
+ }, {
+ "name" : "f2",
+ "columns" : [ {
+ "qualifier" : "m",
+ "measure_refs" : [ "seller_cnt_hll", "seller_format_cnt" ]
+ } ]
+ } ]
+ },
+ "notify_list" : null
}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fda51eae/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_left_join_model_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_left_join_model_desc.json b/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_left_join_model_desc.json
index ca72e05..75cd42a 100644
--- a/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_left_join_model_desc.json
+++ b/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_left_join_model_desc.json
@@ -1,46 +1,49 @@
-{
- "name": "test_kylin_with_slr_left_join_model_desc",
- "fact_table": "DEFAULT.test_kylin_fact",
- "lookups": [
- {
- "table": "EDW.test_cal_dt",
- "join": {
- "type": "left",
- "primary_key": ["cal_dt"],
- "foreign_key": ["cal_dt"]
- }
- },
- {
- "table": "DEFAULT.test_category_groupings",
- "join": {
- "type": "left",
- "primary_key": ["leaf_categ_id", "site_id"],
- "foreign_key": ["leaf_categ_id", "lstg_site_id"]
- }
- },
- {
- "table": "DEFAULT.test_category_groupings",
- "join": {
- "type": "left",
- "primary_key": ["leaf_categ_id", "site_id"],
- "foreign_key": ["leaf_categ_id", "lstg_site_id"]
- }
- },
- {
- "table": "EDW.test_sites",
- "join": {
- "type": "left",
- "primary_key": ["site_id"],
- "foreign_key": ["lstg_site_id"]
- }
- },
- {
- "table": "EDW.test_seller_type_dim",
- "join": {
- "type": "left",
- "primary_key": ["seller_type_cd"],
- "foreign_key": ["slr_segment_cd"]
- }
- }
- ]
-}
+{
+ "uuid" : "9c0f4ee2-1ccb-4b07-a38e-4c298563e0f7",
+ "name" : "test_kylin_cube_with_slr_left_join_desc",
+ "lookups" : [ {
+ "table" : "EDW.TEST_CAL_DT",
+ "join" : {
+ "type" : "left",
+ "primary_key" : [ "CAL_DT" ],
+ "foreign_key" : [ "CAL_DT" ]
+ }
+ }, {
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "join" : {
+ "type" : "left",
+ "primary_key" : [ "LEAF_CATEG_ID", "SITE_ID" ],
+ "foreign_key" : [ "LEAF_CATEG_ID", "LSTG_SITE_ID" ]
+ }
+ }, {
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "join" : {
+ "type" : "left",
+ "primary_key" : [ "LEAF_CATEG_ID", "SITE_ID" ],
+ "foreign_key" : [ "LEAF_CATEG_ID", "LSTG_SITE_ID" ]
+ }
+ }, {
+ "table" : "EDW.TEST_SITES",
+ "join" : {
+ "type" : "left",
+ "primary_key" : [ "SITE_ID" ],
+ "foreign_key" : [ "LSTG_SITE_ID" ]
+ }
+ }, {
+ "table" : "EDW.TEST_SELLER_TYPE_DIM",
+ "join" : {
+ "type" : "left",
+ "primary_key" : [ "SELLER_TYPE_CD" ],
+ "foreign_key" : [ "SLR_SEGMENT_CD" ]
+ }
+ } ],
+ "capacity" : "MEDIUM",
+ "last_modified" : 1422435345352,
+ "fact_table" : "DEFAULT.TEST_KYLIN_FACT",
+ "filter_condition" : null,
+ "partition_desc" : {
+ "partition_date_column" : "DEFAULT.TEST_KYLIN_FACT.cal_dt",
+ "partition_date_start" : 0,
+ "partition_type" : "APPEND"
+ }
+}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fda51eae/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_model_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_model_desc.json b/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_model_desc.json
index e1a175d..5695344 100644
--- a/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_model_desc.json
+++ b/examples/test_case_data/localmeta/model_desc/test_kylin_with_slr_model_desc.json
@@ -1,56 +1,42 @@
-{
- "name": "test_kylin_with_slr_model_desc",
- "fact_table": "DEFAULT.test_kylin_fact",
- "lookups": [
- {
- "table": "EDW.test_cal_dt",
- "join": {
- "type": "inner",
- "primary_key": [
- "cal_dt"
- ],
- "foreign_key": [
- "cal_dt"
- ]
- }
- },
- {
- "table": "DEFAULT.test_category_groupings",
- "join": {
- "type": "inner",
- "primary_key": [
- "leaf_categ_id",
- "site_id"
- ],
- "foreign_key": [
- "leaf_categ_id",
- "lstg_site_id"
- ]
- }
- },
- {
- "table": "EDW.test_sites",
- "join": {
- "type": "inner",
- "primary_key": [
- "site_id"
- ],
- "foreign_key": [
- "lstg_site_id"
- ]
- }
- },
- {
- "table": "EDW.test_seller_type_dim",
- "join": {
- "type": "inner",
- "primary_key": [
- "seller_type_cd"
- ],
- "foreign_key": [
- "slr_segment_cd"
- ]
- }
- }
- ]
+{
+ "uuid" : "ff527b94-f860-44c3-8452-93b17774c647",
+ "name" : "test_kylin_cube_with_slr_desc",
+ "lookups" : [ {
+ "table" : "EDW.TEST_CAL_DT",
+ "join" : {
+ "type" : "inner",
+ "primary_key" : [ "CAL_DT" ],
+ "foreign_key" : [ "CAL_DT" ]
+ }
+ }, {
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "join" : {
+ "type" : "inner",
+ "primary_key" : [ "LEAF_CATEG_ID", "SITE_ID" ],
+ "foreign_key" : [ "LEAF_CATEG_ID", "LSTG_SITE_ID" ]
+ }
+ }, {
+ "table" : "EDW.TEST_SITES",
+ "join" : {
+ "type" : "inner",
+ "primary_key" : [ "SITE_ID" ],
+ "foreign_key" : [ "LSTG_SITE_ID" ]
+ }
+ }, {
+ "table" : "EDW.TEST_SELLER_TYPE_DIM",
+ "join" : {
+ "type" : "inner",
+ "primary_key" : [ "SELLER_TYPE_CD" ],
+ "foreign_key" : [ "SLR_SEGMENT_CD" ]
+ }
+ } ],
+ "capacity" : "MEDIUM",
+ "last_modified" : 1422435345324,
+ "fact_table" : "DEFAULT.TEST_KYLIN_FACT",
+ "filter_condition" : null,
+ "partition_desc" : {
+ "partition_date_column" : "DEFAULT.TEST_KYLIN_FACT.cal_dt",
+ "partition_date_start" : 0,
+ "partition_type" : "APPEND"
+ }
}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fda51eae/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_left_join_model_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_left_join_model_desc.json b/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_left_join_model_desc.json
index a3380d0..0e97e73 100644
--- a/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_left_join_model_desc.json
+++ b/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_left_join_model_desc.json
@@ -1,56 +1,42 @@
-{
- "name": "test_kylin_without_slr_left_join_model_desc",
- "fact_table": "DEFAULT.test_kylin_fact",
- "lookups": [
- {
- "table": "EDW.test_cal_dt",
- "join": {
- "type": "left",
- "primary_key": [
- "cal_dt"
- ],
- "foreign_key": [
- "cal_dt"
- ]
- }
- },
- {
- "table": "DEFAULT.test_category_groupings",
- "join": {
- "type": "left",
- "primary_key": [
- "leaf_categ_id",
- "site_id"
- ],
- "foreign_key": [
- "leaf_categ_id",
- "lstg_site_id"
- ]
- }
- },
- {
- "table": "EDW.test_sites",
- "join": {
- "type": "left",
- "primary_key": [
- "site_id"
- ],
- "foreign_key": [
- "lstg_site_id"
- ]
- }
- },
- {
- "table": "EDW.test_seller_type_dim",
- "join": {
- "type": "left",
- "primary_key": [
- "seller_type_cd"
- ],
- "foreign_key": [
- "slr_segment_cd"
- ]
- }
- }
- ]
+{
+ "uuid" : "9a4207bd-3bf9-48dd-b334-cf27fa55d629",
+ "name" : "test_kylin_cube_without_slr_left_join_desc",
+ "lookups" : [ {
+ "table" : "EDW.TEST_CAL_DT",
+ "join" : {
+ "type" : "left",
+ "primary_key" : [ "CAL_DT" ],
+ "foreign_key" : [ "CAL_DT" ]
+ }
+ }, {
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "join" : {
+ "type" : "left",
+ "primary_key" : [ "LEAF_CATEG_ID", "SITE_ID" ],
+ "foreign_key" : [ "LEAF_CATEG_ID", "LSTG_SITE_ID" ]
+ }
+ }, {
+ "table" : "EDW.TEST_SITES",
+ "join" : {
+ "type" : "left",
+ "primary_key" : [ "SITE_ID" ],
+ "foreign_key" : [ "LSTG_SITE_ID" ]
+ }
+ }, {
+ "table" : "EDW.TEST_SELLER_TYPE_DIM",
+ "join" : {
+ "type" : "left",
+ "primary_key" : [ "SELLER_TYPE_CD" ],
+ "foreign_key" : [ "SLR_SEGMENT_CD" ]
+ }
+ } ],
+ "capacity" : "MEDIUM",
+ "last_modified" : 1422435345372,
+ "fact_table" : "DEFAULT.TEST_KYLIN_FACT",
+ "filter_condition" : null,
+ "partition_desc" : {
+ "partition_date_column" : "DEFAULT.TEST_KYLIN_FACT.cal_dt",
+ "partition_date_start" : 0,
+ "partition_type" : "UPDATE_INSERT"
+ }
}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/incubator-kylin/blob/fda51eae/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_model_desc.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_model_desc.json b/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_model_desc.json
index 87d68f4..fb6edae 100644
--- a/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_model_desc.json
+++ b/examples/test_case_data/localmeta/model_desc/test_kylin_without_slr_model_desc.json
@@ -1,56 +1,42 @@
-{
- "name": "test_kylin_without_slr_model_desc",
- "fact_table": "DEFAULT.test_kylin_fact",
- "lookups": [
- {
- "table": "EDW.test_cal_dt",
- "join": {
- "type": "inner",
- "primary_key": [
- "cal_dt"
- ],
- "foreign_key": [
- "cal_dt"
- ]
- }
- },
- {
- "table": "DEFAULT.test_category_groupings",
- "join": {
- "type": "inner",
- "primary_key": [
- "leaf_categ_id",
- "site_id"
- ],
- "foreign_key": [
- "leaf_categ_id",
- "lstg_site_id"
- ]
- }
- },
- {
- "table": "EDW.test_sites",
- "join": {
- "type": "inner",
- "primary_key": [
- "site_id"
- ],
- "foreign_key": [
- "lstg_site_id"
- ]
- }
- },
- {
- "table": "EDW.test_seller_type_dim",
- "join": {
- "type": "inner",
- "primary_key": [
- "seller_type_cd"
- ],
- "foreign_key": [
- "slr_segment_cd"
- ]
- }
- }
- ]
+{
+ "uuid" : "0928468a-9fab-4185-9a14-6f2e7c74823f",
+ "name" : "test_kylin_cube_without_slr_desc",
+ "lookups" : [ {
+ "table" : "EDW.TEST_CAL_DT",
+ "join" : {
+ "type" : "inner",
+ "primary_key" : [ "CAL_DT" ],
+ "foreign_key" : [ "CAL_DT" ]
+ }
+ }, {
+ "table" : "DEFAULT.TEST_CATEGORY_GROUPINGS",
+ "join" : {
+ "type" : "inner",
+ "primary_key" : [ "LEAF_CATEG_ID", "SITE_ID" ],
+ "foreign_key" : [ "LEAF_CATEG_ID", "LSTG_SITE_ID" ]
+ }
+ }, {
+ "table" : "EDW.TEST_SITES",
+ "join" : {
+ "type" : "inner",
+ "primary_key" : [ "SITE_ID" ],
+ "foreign_key" : [ "LSTG_SITE_ID" ]
+ }
+ }, {
+ "table" : "EDW.TEST_SELLER_TYPE_DIM",
+ "join" : {
+ "type" : "inner",
+ "primary_key" : [ "SELLER_TYPE_CD" ],
+ "foreign_key" : [ "SLR_SEGMENT_CD" ]
+ }
+ } ],
+ "capacity" : "SMALL",
+ "last_modified" : 1422435345362,
+ "fact_table" : "DEFAULT.TEST_KYLIN_FACT",
+ "filter_condition" : null,
+ "partition_desc" : {
+ "partition_date_column" : null,
+ "partition_date_start" : 0,
+ "partition_type" : "APPEND"
+ }
}
\ No newline at end of file