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 2016/10/19 03:01:58 UTC
[11/50] [abbrv] kylin git commit: KYLIN-2076 Improve sample cube and
data
http://git-wip-us.apache.org/repos/asf/kylin/blob/0c7e2688/examples/sample_cube/template/cube_desc/kylin_sales_cube_desc.json
----------------------------------------------------------------------
diff --git a/examples/sample_cube/template/cube_desc/kylin_sales_cube_desc.json b/examples/sample_cube/template/cube_desc/kylin_sales_cube_desc.json
index 99f8f46..cc1cd76 100644
--- a/examples/sample_cube/template/cube_desc/kylin_sales_cube_desc.json
+++ b/examples/sample_cube/template/cube_desc/kylin_sales_cube_desc.json
@@ -35,6 +35,16 @@
"table" : "DEFAULT.KYLIN_SALES",
"column" : "LSTG_FORMAT_NAME",
"derived" : null
+ }, {
+ "name" : "USER_ID",
+ "table" : "DEFAULT.KYLIN_SALES",
+ "column" : "USER_ID",
+ "derived" : null
+ }, {
+ "name" : "REGION",
+ "table" : "DEFAULT.KYLIN_SALES",
+ "column" : "REGION",
+ "derived" : null
} ],
"measures" : [ {
"name" : "GMV_SUM",
@@ -145,6 +155,12 @@
"column" : "LSTG_FORMAT_NAME",
"encoding" : "fixed_length:12"
}, {
+ "column" : "USER_ID",
+ "encoding" : "dict"
+ }, {
+ "column" : "REGION",
+ "encoding" : "dict"
+ }, {
"column" : "LSTG_SITE_ID",
"encoding" : "dict"
} ]
@@ -180,4 +196,4 @@
"engine_type" : %default_engine_type%,
"storage_type" : %default_storage_type%,
"override_kylin_properties" : { }
-}
\ No newline at end of file
+}
http://git-wip-us.apache.org/repos/asf/kylin/blob/0c7e2688/examples/sample_cube/template/model_desc/kylin_sales_model.json
----------------------------------------------------------------------
diff --git a/examples/sample_cube/template/model_desc/kylin_sales_model.json b/examples/sample_cube/template/model_desc/kylin_sales_model.json
index 7ae47c1..13fc356 100644
--- a/examples/sample_cube/template/model_desc/kylin_sales_model.json
+++ b/examples/sample_cube/template/model_desc/kylin_sales_model.json
@@ -24,7 +24,7 @@
"columns" : [ "USER_DEFINED_FIELD1", "USER_DEFINED_FIELD3", "UPD_DATE", "UPD_USER", "META_CATEG_NAME", "CATEG_LVL2_NAME", "CATEG_LVL3_NAME" ]
}, {
"table" : "DEFAULT.KYLIN_SALES",
- "columns" : [ "LSTG_FORMAT_NAME", "SELLER_ID", "PART_DT" ]
+ "columns" : [ "LSTG_FORMAT_NAME", "SELLER_ID", "PART_DT", "USER_ID", "REGION" ]
} ],
"metrics": [
"PRICE",
@@ -40,4 +40,4 @@
"partition_date_start" : 1325376000000,
"partition_type" : "APPEND"
}
-}
\ No newline at end of file
+}
http://git-wip-us.apache.org/repos/asf/kylin/blob/0c7e2688/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json
----------------------------------------------------------------------
diff --git a/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json b/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json
index 4927343..2bccbeb 100644
--- a/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json
+++ b/examples/sample_cube/template/table/DEFAULT.KYLIN_SALES.json
@@ -38,7 +38,15 @@
"id" : "9",
"name" : "SELLER_ID",
"datatype" : "bigint"
+ }, {
+ "id" : "10",
+ "name" : "USER_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "11",
+ "name" : "REGION",
+ "datatype" : "string"
} ],
"database" : "DEFAULT",
"last_modified" : 0
-}
\ No newline at end of file
+}