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/09/03 06:37:45 UTC
[38/50] [abbrv] kylin git commit: minor, fix all useless columns
minor, fix all useless columns
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/894c16f2
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/894c16f2
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/894c16f2
Branch: refs/heads/1.5.x-HBase1.x
Commit: 894c16f2c978667e2526c6a2a9e46c861e644ff8
Parents: 9702dff
Author: Hongbin Ma <ma...@apache.org>
Authored: Wed Aug 31 20:12:45 2016 +0800
Committer: Hongbin Ma <ma...@apache.org>
Committed: Wed Aug 31 20:12:45 2016 +0800
----------------------------------------------------------------------
.../metadata/table/DEFAULT.KYLIN_CAL_DT.json | 887 +++++++++---------
.../table/DEFAULT.KYLIN_CATEGORY_GROUPINGS.json | 4 +-
.../table/DEFAULT.TEST_CATEGORY_GROUPINGS.json | 4 +-
.../localmeta/table/EDW.TEST_CAL_DT.json | 892 +++++++++----------
.../table/EDW.TEST_SELLER_TYPE_DIM.json | 8 +-
.../localmeta/table/EDW.TEST_SITES.json | 4 +-
.../localmeta/table/EDW.V_TEST_CAL_DT.json | 889 +++++++++---------
7 files changed, 1229 insertions(+), 1459 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/894c16f2/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CAL_DT.json
----------------------------------------------------------------------
diff --git a/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CAL_DT.json b/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CAL_DT.json
index de404f1..d197115 100644
--- a/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CAL_DT.json
+++ b/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CAL_DT.json
@@ -1,483 +1,408 @@
{
- "uuid": "0ff420eb-79ad-40bd-bca9-12d8cd05c60a",
- "name": "KYLIN_CAL_DT",
- "columns": [
- {
- "id": "1",
- "name": "CAL_DT",
- "datatype": "date"
- },
- {
- "id": "2",
- "name": "YEAR_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "3",
- "name": "QTR_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "4",
- "name": "MONTH_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "5",
- "name": "WEEK_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "6",
- "name": "AGE_FOR_YEAR_ID",
- "datatype": "smallint"
- },
- {
- "id": "7",
- "name": "AGE_FOR_QTR_ID",
- "datatype": "smallint"
- },
- {
- "id": "8",
- "name": "AGE_FOR_MONTH_ID",
- "datatype": "smallint"
- },
- {
- "id": "9",
- "name": "AGE_FOR_WEEK_ID",
- "datatype": "smallint"
- },
- {
- "id": "10",
- "name": "AGE_FOR_DT_ID",
- "datatype": "smallint"
- },
- {
- "id": "11",
- "name": "AGE_FOR_RTL_YEAR_ID",
- "datatype": "smallint"
- },
- {
- "id": "12",
- "name": "AGE_FOR_RTL_QTR_ID",
- "datatype": "smallint"
- },
- {
- "id": "13",
- "name": "AGE_FOR_RTL_MONTH_ID",
- "datatype": "smallint"
- },
- {
- "id": "14",
- "name": "AGE_FOR_RTL_WEEK_ID",
- "datatype": "smallint"
- },
- {
- "id": "15",
- "name": "AGE_FOR_CS_WEEK_ID",
- "datatype": "smallint"
- },
- {
- "id": "16",
- "name": "DAY_OF_CAL_ID",
- "datatype": "int"
- },
- {
- "id": "17",
- "name": "DAY_OF_YEAR_ID",
- "datatype": "smallint"
- },
- {
- "id": "18",
- "name": "DAY_OF_QTR_ID",
- "datatype": "smallint"
- },
- {
- "id": "19",
- "name": "DAY_OF_MONTH_ID",
- "datatype": "smallint"
- },
- {
- "id": "20",
- "name": "DAY_OF_WEEK_ID",
- "datatype": "int"
- },
- {
- "id": "21",
- "name": "WEEK_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "22",
- "name": "WEEK_OF_CAL_ID",
- "datatype": "int"
- },
- {
- "id": "23",
- "name": "MONTH_OF_QTR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "24",
- "name": "MONTH_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "25",
- "name": "MONTH_OF_CAL_ID",
- "datatype": "smallint"
- },
- {
- "id": "26",
- "name": "QTR_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "27",
- "name": "QTR_OF_CAL_ID",
- "datatype": "smallint"
- },
- {
- "id": "28",
- "name": "YEAR_OF_CAL_ID",
- "datatype": "smallint"
- },
- {
- "id": "29",
- "name": "YEAR_END_DT",
- "datatype": "string"
- },
- {
- "id": "30",
- "name": "QTR_END_DT",
- "datatype": "string"
- },
- {
- "id": "31",
- "name": "MONTH_END_DT",
- "datatype": "string"
- },
- {
- "id": "32",
- "name": "WEEK_END_DT",
- "datatype": "string"
- },
- {
- "id": "33",
- "name": "CAL_DT_NAME",
- "datatype": "string"
- },
- {
- "id": "34",
- "name": "CAL_DT_DESC",
- "datatype": "string"
- },
- {
- "id": "35",
- "name": "CAL_DT_SHORT_NAME",
- "datatype": "string"
- },
- {
- "id": "36",
- "name": "YTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "37",
- "name": "QTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "38",
- "name": "MTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "39",
- "name": "WTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "40",
- "name": "SEASON_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "41",
- "name": "DAY_IN_YEAR_COUNT",
- "datatype": "smallint"
- },
- {
- "id": "42",
- "name": "DAY_IN_QTR_COUNT",
- "datatype": "tinyint"
- },
- {
- "id": "43",
- "name": "DAY_IN_MONTH_COUNT",
- "datatype": "tinyint"
- },
- {
- "id": "44",
- "name": "DAY_IN_WEEK_COUNT",
- "datatype": "tinyint"
- },
- {
- "id": "45",
- "name": "RTL_YEAR_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "46",
- "name": "RTL_QTR_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "47",
- "name": "RTL_MONTH_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "48",
- "name": "RTL_WEEK_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "49",
- "name": "CS_WEEK_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "50",
- "name": "CAL_DATE",
- "datatype": "string"
- },
- {
- "id": "51",
- "name": "DAY_OF_WEEK",
- "datatype": "string"
- },
- {
- "id": "52",
- "name": "MONTH_ID",
- "datatype": "string"
- },
- {
- "id": "53",
- "name": "PRD_DESC",
- "datatype": "string"
- },
- {
- "id": "54",
- "name": "PRD_FLAG",
- "datatype": "string"
- },
- {
- "id": "55",
- "name": "PRD_ID",
- "datatype": "string"
- },
- {
- "id": "56",
- "name": "PRD_IND",
- "datatype": "string"
- },
- {
- "id": "57",
- "name": "QTR_DESC",
- "datatype": "string"
- },
- {
- "id": "58",
- "name": "QTR_ID",
- "datatype": "string"
- },
- {
- "id": "59",
- "name": "QTR_IND",
- "datatype": "string"
- },
- {
- "id": "60",
- "name": "RETAIL_WEEK",
- "datatype": "string"
- },
- {
- "id": "61",
- "name": "RETAIL_YEAR",
- "datatype": "string"
- },
- {
- "id": "62",
- "name": "RETAIL_START_DATE",
- "datatype": "string"
- },
- {
- "id": "63",
- "name": "RETAIL_WK_END_DATE",
- "datatype": "string"
- },
- {
- "id": "64",
- "name": "WEEK_IND",
- "datatype": "string"
- },
- {
- "id": "65",
- "name": "WEEK_NUM_DESC",
- "datatype": "string"
- },
- {
- "id": "66",
- "name": "WEEK_BEG_DATE",
- "datatype": "string"
- },
- {
- "id": "67",
- "name": "WEEK_END_DATE",
- "datatype": "string"
- },
- {
- "id": "68",
- "name": "WEEK_IN_YEAR_ID",
- "datatype": "string"
- },
- {
- "id": "69",
- "name": "WEEK_ID",
- "datatype": "string"
- },
- {
- "id": "70",
- "name": "WEEK_BEG_END_DESC_MDY",
- "datatype": "string"
- },
- {
- "id": "71",
- "name": "WEEK_BEG_END_DESC_MD",
- "datatype": "string"
- },
- {
- "id": "72",
- "name": "YEAR_ID",
- "datatype": "string"
- },
- {
- "id": "73",
- "name": "YEAR_IND",
- "datatype": "string"
- },
- {
- "id": "74",
- "name": "CAL_DT_MNS_1YEAR_DT",
- "datatype": "string"
- },
- {
- "id": "75",
- "name": "CAL_DT_MNS_2YEAR_DT",
- "datatype": "string"
- },
- {
- "id": "76",
- "name": "CAL_DT_MNS_1QTR_DT",
- "datatype": "string"
- },
- {
- "id": "77",
- "name": "CAL_DT_MNS_2QTR_DT",
- "datatype": "string"
- },
- {
- "id": "78",
- "name": "CAL_DT_MNS_1MONTH_DT",
- "datatype": "string"
- },
- {
- "id": "79",
- "name": "CAL_DT_MNS_2MONTH_DT",
- "datatype": "string"
- },
- {
- "id": "80",
- "name": "CAL_DT_MNS_1WEEK_DT",
- "datatype": "string"
- },
- {
- "id": "81",
- "name": "CAL_DT_MNS_2WEEK_DT",
- "datatype": "string"
- },
- {
- "id": "82",
- "name": "CURR_CAL_DT_MNS_1YEAR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "83",
- "name": "CURR_CAL_DT_MNS_2YEAR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "84",
- "name": "CURR_CAL_DT_MNS_1QTR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "85",
- "name": "CURR_CAL_DT_MNS_2QTR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "86",
- "name": "CURR_CAL_DT_MNS_1MONTH_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "87",
- "name": "CURR_CAL_DT_MNS_2MONTH_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "88",
- "name": "CURR_CAL_DT_MNS_1WEEK_YN_IND",
- "datatype": "tinyint"
- },
- {
- "id": "89",
- "name": "CURR_CAL_DT_MNS_2WEEK_YN_IND",
- "datatype": "tinyint"
- },
- {
- "id": "90",
- "name": "RTL_MONTH_OF_RTL_YEAR_ID",
- "datatype": "string"
- },
- {
- "id": "91",
- "name": "RTL_QTR_OF_RTL_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "92",
- "name": "RTL_WEEK_OF_RTL_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "93",
- "name": "SEASON_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "94",
- "name": "YTM_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "95",
- "name": "YTQ_YN_ID",
- "datatype": "tinyint"
- }
- ],
- "database": "default",
- "last_modified": 0
+ "uuid" : "0ff420eb-79ad-40bd-bca9-12d8cd05c60a",
+
+ "name" : "KYLIN_CAL_DT",
+ "columns" : [ {
+ "id" : "1",
+ "name" : "CAL_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "2",
+ "name" : "YEAR_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "3",
+ "name" : "QTR_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "4",
+ "name" : "MONTH_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "5",
+ "name" : "WEEK_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "6",
+ "name" : "AGE_FOR_YEAR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "7",
+ "name" : "AGE_FOR_QTR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "8",
+ "name" : "AGE_FOR_MONTH_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "9",
+ "name" : "AGE_FOR_WEEK_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "10",
+ "name" : "AGE_FOR_DT_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "11",
+ "name" : "AGE_FOR_RTL_YEAR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "12",
+ "name" : "AGE_FOR_RTL_QTR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "13",
+ "name" : "AGE_FOR_RTL_MONTH_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "14",
+ "name" : "AGE_FOR_RTL_WEEK_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "15",
+ "name" : "AGE_FOR_CS_WEEK_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "16",
+ "name" : "DAY_OF_CAL_ID",
+ "datatype" : "int"
+ }, {
+ "id" : "17",
+ "name" : "DAY_OF_YEAR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "18",
+ "name" : "DAY_OF_QTR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "19",
+ "name" : "DAY_OF_MONTH_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "20",
+ "name" : "DAY_OF_WEEK_ID",
+ "datatype" : "int"
+ }, {
+ "id" : "21",
+ "name" : "WEEK_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "22",
+ "name" : "WEEK_OF_CAL_ID",
+ "datatype" : "int"
+ }, {
+ "id" : "23",
+ "name" : "MONTH_OF_QTR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "24",
+ "name" : "MONTH_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "25",
+ "name" : "MONTH_OF_CAL_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "26",
+ "name" : "QTR_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "27",
+ "name" : "QTR_OF_CAL_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "28",
+ "name" : "YEAR_OF_CAL_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "29",
+ "name" : "YEAR_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "30",
+ "name" : "QTR_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "31",
+ "name" : "MONTH_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "32",
+ "name" : "WEEK_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "33",
+ "name" : "CAL_DT_NAME",
+ "datatype" : "string"
+ }, {
+ "id" : "34",
+ "name" : "CAL_DT_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "35",
+ "name" : "CAL_DT_SHORT_NAME",
+ "datatype" : "string"
+ }, {
+ "id" : "36",
+ "name" : "YTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "37",
+ "name" : "QTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "38",
+ "name" : "MTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "39",
+ "name" : "WTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "40",
+ "name" : "SEASON_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "41",
+ "name" : "DAY_IN_YEAR_COUNT",
+ "datatype" : "smallint"
+ }, {
+ "id" : "42",
+ "name" : "DAY_IN_QTR_COUNT",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "43",
+ "name" : "DAY_IN_MONTH_COUNT",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "44",
+ "name" : "DAY_IN_WEEK_COUNT",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "45",
+ "name" : "RTL_YEAR_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "46",
+ "name" : "RTL_QTR_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "47",
+ "name" : "RTL_MONTH_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "48",
+ "name" : "RTL_WEEK_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "49",
+ "name" : "CS_WEEK_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "50",
+ "name" : "CAL_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "51",
+ "name" : "DAY_OF_WEEK",
+ "datatype" : "string"
+ }, {
+ "id" : "52",
+ "name" : "MONTH_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "53",
+ "name" : "PRD_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "54",
+ "name" : "PRD_FLAG",
+ "datatype" : "string"
+ }, {
+ "id" : "55",
+ "name" : "PRD_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "56",
+ "name" : "PRD_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "57",
+ "name" : "QTR_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "58",
+ "name" : "QTR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "59",
+ "name" : "QTR_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "60",
+ "name" : "RETAIL_WEEK",
+ "datatype" : "string"
+ }, {
+ "id" : "61",
+ "name" : "RETAIL_YEAR",
+ "datatype" : "string"
+ }, {
+ "id" : "62",
+ "name" : "RETAIL_START_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "63",
+ "name" : "RETAIL_WK_END_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "64",
+ "name" : "WEEK_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "65",
+ "name" : "WEEK_NUM_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "66",
+ "name" : "WEEK_BEG_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "67",
+ "name" : "WEEK_END_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "68",
+ "name" : "WEEK_IN_YEAR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "69",
+ "name" : "WEEK_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "70",
+ "name" : "WEEK_BEG_END_DESC_MDY",
+ "datatype" : "string"
+ }, {
+ "id" : "71",
+ "name" : "WEEK_BEG_END_DESC_MD",
+ "datatype" : "string"
+ }, {
+ "id" : "72",
+ "name" : "YEAR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "73",
+ "name" : "YEAR_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "74",
+ "name" : "CAL_DT_MNS_1YEAR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "75",
+ "name" : "CAL_DT_MNS_2YEAR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "76",
+ "name" : "CAL_DT_MNS_1QTR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "77",
+ "name" : "CAL_DT_MNS_2QTR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "78",
+ "name" : "CAL_DT_MNS_1MONTH_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "79",
+ "name" : "CAL_DT_MNS_2MONTH_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "80",
+ "name" : "CAL_DT_MNS_1WEEK_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "81",
+ "name" : "CAL_DT_MNS_2WEEK_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "82",
+ "name" : "CURR_CAL_DT_MNS_1YEAR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "83",
+ "name" : "CURR_CAL_DT_MNS_2YEAR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "84",
+ "name" : "CURR_CAL_DT_MNS_1QTR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "85",
+ "name" : "CURR_CAL_DT_MNS_2QTR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "86",
+ "name" : "CURR_CAL_DT_MNS_1MONTH_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "87",
+ "name" : "CURR_CAL_DT_MNS_2MONTH_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "88",
+ "name" : "CURR_CAL_DT_MNS_1WEEK_YN_IND",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "89",
+ "name" : "CURR_CAL_DT_MNS_2WEEK_YN_IND",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "90",
+ "name" : "RTL_MONTH_OF_RTL_YEAR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "91",
+ "name" : "RTL_QTR_OF_RTL_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "92",
+ "name" : "RTL_WEEK_OF_RTL_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "93",
+ "name" : "SEASON_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "94",
+ "name" : "YTM_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "95",
+ "name" : "YTQ_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "96",
+ "name" : "YTW_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "97",
+ "name" : "KYLIN_CAL_DT_CRE_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "98",
+ "name" : "KYLIN_CAL_DT_CRE_USER",
+ "datatype" : "string"
+ }, {
+ "id" : "99",
+ "name" : "KYLIN_CAL_DT_UPD_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "100",
+ "name" : "KYLIN_CAL_DT_UPD_USER",
+ "datatype" : "string"
+ } ],
+ "database" : "default",
+ "last_modified" : 0
}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/kylin/blob/894c16f2/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CATEGORY_GROUPINGS.json
----------------------------------------------------------------------
diff --git a/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CATEGORY_GROUPINGS.json b/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CATEGORY_GROUPINGS.json
index b9891dc..8e97309 100644
--- a/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CATEGORY_GROUPINGS.json
+++ b/examples/sample_cube/metadata/table/DEFAULT.KYLIN_CATEGORY_GROUPINGS.json
@@ -36,7 +36,7 @@
"datatype" : "string"
}, {
"id" : "9",
- "name" : "CRE_DATE",
+ "name" : "KYLIN_GROUPINGS_CRE_DATE",
"datatype" : "string"
}, {
"id" : "10",
@@ -44,7 +44,7 @@
"datatype" : "string"
}, {
"id" : "11",
- "name" : "CRE_USER",
+ "name" : "KYLIN_GROUPINGS_CRE_USER",
"datatype" : "string"
}, {
"id" : "12",
http://git-wip-us.apache.org/repos/asf/kylin/blob/894c16f2/examples/test_case_data/localmeta/table/DEFAULT.TEST_CATEGORY_GROUPINGS.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/table/DEFAULT.TEST_CATEGORY_GROUPINGS.json b/examples/test_case_data/localmeta/table/DEFAULT.TEST_CATEGORY_GROUPINGS.json
index 7d2964f..069f41b 100644
--- a/examples/test_case_data/localmeta/table/DEFAULT.TEST_CATEGORY_GROUPINGS.json
+++ b/examples/test_case_data/localmeta/table/DEFAULT.TEST_CATEGORY_GROUPINGS.json
@@ -36,7 +36,7 @@
"datatype" : "string"
}, {
"id" : "9",
- "name" : "CRE_DATE",
+ "name" : "GROUPINGS_CRE_DATE",
"datatype" : "string"
}, {
"id" : "10",
@@ -44,7 +44,7 @@
"datatype" : "string"
}, {
"id" : "11",
- "name" : "CRE_USER",
+ "name" : "GROUPINGS_CRE_USER",
"datatype" : "string"
}, {
"id" : "12",
http://git-wip-us.apache.org/repos/asf/kylin/blob/894c16f2/examples/test_case_data/localmeta/table/EDW.TEST_CAL_DT.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/table/EDW.TEST_CAL_DT.json b/examples/test_case_data/localmeta/table/EDW.TEST_CAL_DT.json
index d64eb80..dde24cf 100644
--- a/examples/test_case_data/localmeta/table/EDW.TEST_CAL_DT.json
+++ b/examples/test_case_data/localmeta/table/EDW.TEST_CAL_DT.json
@@ -1,488 +1,408 @@
{
- "uuid": "0ff420eb-79ad-40bd-bca9-12d8cd05c60a",
- "name": "TEST_CAL_DT",
- "columns": [
- {
- "id": "1",
- "name": "CAL_DT",
- "datatype": "date"
- },
- {
- "id": "2",
- "name": "YEAR_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "3",
- "name": "QTR_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "4",
- "name": "MONTH_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "5",
- "name": "WEEK_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "6",
- "name": "AGE_FOR_YEAR_ID",
- "datatype": "smallint"
- },
- {
- "id": "7",
- "name": "AGE_FOR_QTR_ID",
- "datatype": "smallint"
- },
- {
- "id": "8",
- "name": "AGE_FOR_MONTH_ID",
- "datatype": "smallint"
- },
- {
- "id": "9",
- "name": "AGE_FOR_WEEK_ID",
- "datatype": "smallint"
- },
- {
- "id": "10",
- "name": "AGE_FOR_DT_ID",
- "datatype": "smallint"
- },
- {
- "id": "11",
- "name": "AGE_FOR_RTL_YEAR_ID",
- "datatype": "smallint"
- },
- {
- "id": "12",
- "name": "AGE_FOR_RTL_QTR_ID",
- "datatype": "smallint"
- },
- {
- "id": "13",
- "name": "AGE_FOR_RTL_MONTH_ID",
- "datatype": "smallint"
- },
- {
- "id": "14",
- "name": "AGE_FOR_RTL_WEEK_ID",
- "datatype": "smallint"
- },
- {
- "id": "15",
- "name": "AGE_FOR_CS_WEEK_ID",
- "datatype": "smallint"
- },
- {
- "id": "16",
- "name": "DAY_OF_CAL_ID",
- "datatype": "int"
- },
- {
- "id": "17",
- "name": "DAY_OF_YEAR_ID",
- "datatype": "smallint"
- },
- {
- "id": "18",
- "name": "DAY_OF_QTR_ID",
- "datatype": "smallint"
- },
- {
- "id": "19",
- "name": "DAY_OF_MONTH_ID",
- "datatype": "smallint"
- },
- {
- "id": "20",
- "name": "DAY_OF_WEEK_ID",
- "datatype": "int"
- },
- {
- "id": "21",
- "name": "WEEK_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "22",
- "name": "WEEK_OF_CAL_ID",
- "datatype": "int"
- },
- {
- "id": "23",
- "name": "MONTH_OF_QTR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "24",
- "name": "MONTH_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "25",
- "name": "MONTH_OF_CAL_ID",
- "datatype": "smallint"
- },
- {
- "id": "26",
- "name": "QTR_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "27",
- "name": "QTR_OF_CAL_ID",
- "datatype": "smallint"
- },
- {
- "id": "28",
- "name": "YEAR_OF_CAL_ID",
- "datatype": "smallint"
- },
- {
- "id": "29",
- "name": "YEAR_END_DT",
- "datatype": "string"
- },
- {
- "id": "30",
- "name": "QTR_END_DT",
- "datatype": "string"
- },
- {
- "id": "31",
- "name": "MONTH_END_DT",
- "datatype": "string"
- },
- {
- "id": "32",
- "name": "WEEK_END_DT",
- "datatype": "string"
- },
- {
- "id": "33",
- "name": "CAL_DT_NAME",
- "datatype": "string"
- },
- {
- "id": "34",
- "name": "CAL_DT_DESC",
- "datatype": "string"
- },
- {
- "id": "35",
- "name": "CAL_DT_SHORT_NAME",
- "datatype": "string"
- },
- {
- "id": "36",
- "name": "YTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "37",
- "name": "QTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "38",
- "name": "MTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "39",
- "name": "WTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "40",
- "name": "SEASON_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "41",
- "name": "DAY_IN_YEAR_COUNT",
- "datatype": "smallint"
- },
- {
- "id": "42",
- "name": "DAY_IN_QTR_COUNT",
- "datatype": "tinyint"
- },
- {
- "id": "43",
- "name": "DAY_IN_MONTH_COUNT",
- "datatype": "tinyint"
- },
- {
- "id": "44",
- "name": "DAY_IN_WEEK_COUNT",
- "datatype": "tinyint"
- },
- {
- "id": "45",
- "name": "RTL_YEAR_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "46",
- "name": "RTL_QTR_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "47",
- "name": "RTL_MONTH_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "48",
- "name": "RTL_WEEK_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "49",
- "name": "CS_WEEK_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "50",
- "name": "CAL_DATE",
- "datatype": "string"
- },
- {
- "id": "51",
- "name": "DAY_OF_WEEK",
- "datatype": "string"
- },
- {
- "id": "52",
- "name": "MONTH_ID",
- "datatype": "string"
- },
- {
- "id": "53",
- "name": "PRD_DESC",
- "datatype": "string"
- },
- {
- "id": "54",
- "name": "PRD_FLAG",
- "datatype": "string"
- },
- {
- "id": "55",
- "name": "PRD_ID",
- "datatype": "string"
- },
- {
- "id": "56",
- "name": "PRD_IND",
- "datatype": "string"
- },
- {
- "id": "57",
- "name": "QTR_DESC",
- "datatype": "string"
- },
- {
- "id": "58",
- "name": "QTR_ID",
- "datatype": "string"
- },
- {
- "id": "59",
- "name": "QTR_IND",
- "datatype": "string"
- },
- {
- "id": "60",
- "name": "RETAIL_WEEK",
- "datatype": "string"
- },
- {
- "id": "61",
- "name": "RETAIL_YEAR",
- "datatype": "string"
- },
- {
- "id": "62",
- "name": "RETAIL_START_DATE",
- "datatype": "string"
- },
- {
- "id": "63",
- "name": "RETAIL_WK_END_DATE",
- "datatype": "string"
- },
- {
- "id": "64",
- "name": "WEEK_IND",
- "datatype": "string"
- },
- {
- "id": "65",
- "name": "WEEK_NUM_DESC",
- "datatype": "string"
- },
- {
- "id": "66",
- "name": "WEEK_BEG_DATE",
- "datatype": "string"
- },
- {
- "id": "67",
- "name": "WEEK_END_DATE",
- "datatype": "string"
- },
- {
- "id": "68",
- "name": "WEEK_IN_YEAR_ID",
- "datatype": "string"
- },
- {
- "id": "69",
- "name": "WEEK_ID",
- "datatype": "string"
- },
- {
- "id": "70",
- "name": "WEEK_BEG_END_DESC_MDY",
- "datatype": "string"
- },
- {
- "id": "71",
- "name": "WEEK_BEG_END_DESC_MD",
- "datatype": "string"
- },
- {
- "id": "72",
- "name": "YEAR_ID",
- "datatype": "string"
- },
- {
- "id": "73",
- "name": "YEAR_IND",
- "datatype": "string"
- },
- {
- "id": "74",
- "name": "CAL_DT_MNS_1YEAR_DT",
- "datatype": "string"
- },
- {
- "id": "75",
- "name": "CAL_DT_MNS_2YEAR_DT",
- "datatype": "string"
- },
- {
- "id": "76",
- "name": "CAL_DT_MNS_1QTR_DT",
- "datatype": "string"
- },
- {
- "id": "77",
- "name": "CAL_DT_MNS_2QTR_DT",
- "datatype": "string"
- },
- {
- "id": "78",
- "name": "CAL_DT_MNS_1MONTH_DT",
- "datatype": "string"
- },
- {
- "id": "79",
- "name": "CAL_DT_MNS_2MONTH_DT",
- "datatype": "string"
- },
- {
- "id": "80",
- "name": "CAL_DT_MNS_1WEEK_DT",
- "datatype": "string"
- },
- {
- "id": "81",
- "name": "CAL_DT_MNS_2WEEK_DT",
- "datatype": "string"
- },
- {
- "id": "82",
- "name": "CURR_CAL_DT_MNS_1YEAR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "83",
- "name": "CURR_CAL_DT_MNS_2YEAR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "84",
- "name": "CURR_CAL_DT_MNS_1QTR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "85",
- "name": "CURR_CAL_DT_MNS_2QTR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "86",
- "name": "CURR_CAL_DT_MNS_1MONTH_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "87",
- "name": "CURR_CAL_DT_MNS_2MONTH_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "88",
- "name": "CURR_CAL_DT_MNS_1WEEK_YN_IND",
- "datatype": "tinyint"
- },
- {
- "id": "89",
- "name": "CURR_CAL_DT_MNS_2WEEK_YN_IND",
- "datatype": "tinyint"
- },
- {
- "id": "90",
- "name": "RTL_MONTH_OF_RTL_YEAR_ID",
- "datatype": "string"
- },
- {
- "id": "91",
- "name": "RTL_QTR_OF_RTL_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "92",
- "name": "RTL_WEEK_OF_RTL_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "93",
- "name": "SEASON_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "94",
- "name": "YTM_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "95",
- "name": "YTQ_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "96",
- "name": "YTW_YN_ID",
- "datatype": "tinyint"
- }
- ],
- "database": "edw",
- "last_modified": 0
+
+ "uuid" : "0ff420eb-79ad-40bd-bca9-12d8cd05c60a",
+ "name" : "TEST_CAL_DT",
+ "columns" : [ {
+ "id" : "1",
+ "name" : "CAL_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "2",
+ "name" : "YEAR_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "3",
+ "name" : "QTR_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "4",
+ "name" : "MONTH_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "5",
+ "name" : "WEEK_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "6",
+ "name" : "AGE_FOR_YEAR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "7",
+ "name" : "AGE_FOR_QTR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "8",
+ "name" : "AGE_FOR_MONTH_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "9",
+ "name" : "AGE_FOR_WEEK_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "10",
+ "name" : "AGE_FOR_DT_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "11",
+ "name" : "AGE_FOR_RTL_YEAR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "12",
+ "name" : "AGE_FOR_RTL_QTR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "13",
+ "name" : "AGE_FOR_RTL_MONTH_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "14",
+ "name" : "AGE_FOR_RTL_WEEK_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "15",
+ "name" : "AGE_FOR_CS_WEEK_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "16",
+ "name" : "DAY_OF_CAL_ID",
+ "datatype" : "int"
+ }, {
+ "id" : "17",
+ "name" : "DAY_OF_YEAR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "18",
+ "name" : "DAY_OF_QTR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "19",
+ "name" : "DAY_OF_MONTH_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "20",
+ "name" : "DAY_OF_WEEK_ID",
+ "datatype" : "int"
+ }, {
+ "id" : "21",
+ "name" : "WEEK_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "22",
+ "name" : "WEEK_OF_CAL_ID",
+ "datatype" : "int"
+ }, {
+ "id" : "23",
+ "name" : "MONTH_OF_QTR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "24",
+ "name" : "MONTH_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "25",
+ "name" : "MONTH_OF_CAL_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "26",
+ "name" : "QTR_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "27",
+ "name" : "QTR_OF_CAL_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "28",
+ "name" : "YEAR_OF_CAL_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "29",
+ "name" : "YEAR_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "30",
+ "name" : "QTR_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "31",
+ "name" : "MONTH_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "32",
+ "name" : "WEEK_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "33",
+ "name" : "CAL_DT_NAME",
+ "datatype" : "string"
+ }, {
+ "id" : "34",
+ "name" : "CAL_DT_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "35",
+ "name" : "CAL_DT_SHORT_NAME",
+ "datatype" : "string"
+ }, {
+ "id" : "36",
+ "name" : "YTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "37",
+ "name" : "QTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "38",
+ "name" : "MTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "39",
+ "name" : "WTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "40",
+ "name" : "SEASON_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "41",
+ "name" : "DAY_IN_YEAR_COUNT",
+ "datatype" : "smallint"
+ }, {
+ "id" : "42",
+ "name" : "DAY_IN_QTR_COUNT",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "43",
+ "name" : "DAY_IN_MONTH_COUNT",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "44",
+ "name" : "DAY_IN_WEEK_COUNT",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "45",
+ "name" : "RTL_YEAR_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "46",
+ "name" : "RTL_QTR_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "47",
+ "name" : "RTL_MONTH_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "48",
+ "name" : "RTL_WEEK_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "49",
+ "name" : "CS_WEEK_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "50",
+ "name" : "CAL_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "51",
+ "name" : "DAY_OF_WEEK",
+ "datatype" : "string"
+ }, {
+ "id" : "52",
+ "name" : "MONTH_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "53",
+ "name" : "PRD_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "54",
+ "name" : "PRD_FLAG",
+ "datatype" : "string"
+ }, {
+ "id" : "55",
+ "name" : "PRD_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "56",
+ "name" : "PRD_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "57",
+ "name" : "QTR_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "58",
+ "name" : "QTR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "59",
+ "name" : "QTR_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "60",
+ "name" : "RETAIL_WEEK",
+ "datatype" : "string"
+ }, {
+ "id" : "61",
+ "name" : "RETAIL_YEAR",
+ "datatype" : "string"
+ }, {
+ "id" : "62",
+ "name" : "RETAIL_START_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "63",
+ "name" : "RETAIL_WK_END_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "64",
+ "name" : "WEEK_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "65",
+ "name" : "WEEK_NUM_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "66",
+ "name" : "WEEK_BEG_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "67",
+ "name" : "WEEK_END_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "68",
+ "name" : "WEEK_IN_YEAR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "69",
+ "name" : "WEEK_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "70",
+ "name" : "WEEK_BEG_END_DESC_MDY",
+ "datatype" : "string"
+ }, {
+ "id" : "71",
+ "name" : "WEEK_BEG_END_DESC_MD",
+ "datatype" : "string"
+ }, {
+ "id" : "72",
+ "name" : "YEAR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "73",
+ "name" : "YEAR_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "74",
+ "name" : "CAL_DT_MNS_1YEAR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "75",
+ "name" : "CAL_DT_MNS_2YEAR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "76",
+ "name" : "CAL_DT_MNS_1QTR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "77",
+ "name" : "CAL_DT_MNS_2QTR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "78",
+ "name" : "CAL_DT_MNS_1MONTH_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "79",
+ "name" : "CAL_DT_MNS_2MONTH_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "80",
+ "name" : "CAL_DT_MNS_1WEEK_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "81",
+ "name" : "CAL_DT_MNS_2WEEK_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "82",
+ "name" : "CURR_CAL_DT_MNS_1YEAR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "83",
+ "name" : "CURR_CAL_DT_MNS_2YEAR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "84",
+ "name" : "CURR_CAL_DT_MNS_1QTR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "85",
+ "name" : "CURR_CAL_DT_MNS_2QTR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "86",
+ "name" : "CURR_CAL_DT_MNS_1MONTH_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "87",
+ "name" : "CURR_CAL_DT_MNS_2MONTH_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "88",
+ "name" : "CURR_CAL_DT_MNS_1WEEK_YN_IND",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "89",
+ "name" : "CURR_CAL_DT_MNS_2WEEK_YN_IND",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "90",
+ "name" : "RTL_MONTH_OF_RTL_YEAR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "91",
+ "name" : "RTL_QTR_OF_RTL_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "92",
+ "name" : "RTL_WEEK_OF_RTL_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "93",
+ "name" : "SEASON_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "94",
+ "name" : "YTM_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "95",
+ "name" : "YTQ_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "96",
+ "name" : "YTW_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "97",
+ "name" : "CAL_DT_CRE_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "98",
+ "name" : "CAL_DT_CRE_USER",
+ "datatype" : "string"
+ }, {
+ "id" : "99",
+ "name" : "CAL_DT_UPD_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "100",
+ "name" : "CAL_DT_UPD_USER",
+ "datatype" : "string"
+ } ],
+ "database" : "edw",
+ "last_modified" : 0
}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/kylin/blob/894c16f2/examples/test_case_data/localmeta/table/EDW.TEST_SELLER_TYPE_DIM.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/table/EDW.TEST_SELLER_TYPE_DIM.json b/examples/test_case_data/localmeta/table/EDW.TEST_SELLER_TYPE_DIM.json
index 6bc2815..eec48ea 100644
--- a/examples/test_case_data/localmeta/table/EDW.TEST_SELLER_TYPE_DIM.json
+++ b/examples/test_case_data/localmeta/table/EDW.TEST_SELLER_TYPE_DIM.json
@@ -24,19 +24,19 @@
"datatype" : "string"
}, {
"id" : "6",
- "name" : "CRE_DATE",
+ "name" : "DIM_CRE_DATE",
"datatype" : "string"
}, {
"id" : "7",
- "name" : "CRE_USER",
+ "name" : "DIM_CRE_USER",
"datatype" : "string"
}, {
"id" : "8",
- "name" : "UPD_DATE",
+ "name" : "DIM_UPD_DATE",
"datatype" : "string"
}, {
"id" : "9",
- "name" : "UPD_USER",
+ "name" : "DIM_UPD_USER",
"datatype" : "string"
} ],
"database" : "edw",
http://git-wip-us.apache.org/repos/asf/kylin/blob/894c16f2/examples/test_case_data/localmeta/table/EDW.TEST_SITES.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/table/EDW.TEST_SITES.json b/examples/test_case_data/localmeta/table/EDW.TEST_SITES.json
index d5cc116..06a0b2e 100644
--- a/examples/test_case_data/localmeta/table/EDW.TEST_SITES.json
+++ b/examples/test_case_data/localmeta/table/EDW.TEST_SITES.json
@@ -32,7 +32,7 @@
"datatype" : "string"
}, {
"id" : "8",
- "name" : "UPD_DATE",
+ "name" : "SITES_UPD_DATE",
"datatype" : "string"
}, {
"id" : "9",
@@ -40,7 +40,7 @@
"datatype" : "string"
}, {
"id" : "10",
- "name" : "UPD_USER",
+ "name" : "SITES_UPD_USER",
"datatype" : "string"
} ],
"database" : "edw",
http://git-wip-us.apache.org/repos/asf/kylin/blob/894c16f2/examples/test_case_data/localmeta/table/EDW.V_TEST_CAL_DT.json
----------------------------------------------------------------------
diff --git a/examples/test_case_data/localmeta/table/EDW.V_TEST_CAL_DT.json b/examples/test_case_data/localmeta/table/EDW.V_TEST_CAL_DT.json
index c48b9e2..9298c7f 100644
--- a/examples/test_case_data/localmeta/table/EDW.V_TEST_CAL_DT.json
+++ b/examples/test_case_data/localmeta/table/EDW.V_TEST_CAL_DT.json
@@ -1,484 +1,409 @@
{
- "uuid": "0ff420eb-79ad-40bd-bca9-12d8cd05c60a",
- "name": "V_TEST_CAL_DT",
- "columns": [
- {
- "id": "1",
- "name": "CAL_DT",
- "datatype": "date"
- },
- {
- "id": "2",
- "name": "YEAR_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "3",
- "name": "QTR_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "4",
- "name": "MONTH_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "5",
- "name": "WEEK_BEG_DT",
- "datatype": "date"
- },
- {
- "id": "6",
- "name": "AGE_FOR_YEAR_ID",
- "datatype": "smallint"
- },
- {
- "id": "7",
- "name": "AGE_FOR_QTR_ID",
- "datatype": "smallint"
- },
- {
- "id": "8",
- "name": "AGE_FOR_MONTH_ID",
- "datatype": "smallint"
- },
- {
- "id": "9",
- "name": "AGE_FOR_WEEK_ID",
- "datatype": "smallint"
- },
- {
- "id": "10",
- "name": "AGE_FOR_DT_ID",
- "datatype": "smallint"
- },
- {
- "id": "11",
- "name": "AGE_FOR_RTL_YEAR_ID",
- "datatype": "smallint"
- },
- {
- "id": "12",
- "name": "AGE_FOR_RTL_QTR_ID",
- "datatype": "smallint"
- },
- {
- "id": "13",
- "name": "AGE_FOR_RTL_MONTH_ID",
- "datatype": "smallint"
- },
- {
- "id": "14",
- "name": "AGE_FOR_RTL_WEEK_ID",
- "datatype": "smallint"
- },
- {
- "id": "15",
- "name": "AGE_FOR_CS_WEEK_ID",
- "datatype": "smallint"
- },
- {
- "id": "16",
- "name": "DAY_OF_CAL_ID",
- "datatype": "int"
- },
- {
- "id": "17",
- "name": "DAY_OF_YEAR_ID",
- "datatype": "smallint"
- },
- {
- "id": "18",
- "name": "DAY_OF_QTR_ID",
- "datatype": "smallint"
- },
- {
- "id": "19",
- "name": "DAY_OF_MONTH_ID",
- "datatype": "smallint"
- },
- {
- "id": "20",
- "name": "DAY_OF_WEEK_ID",
- "datatype": "int"
- },
- {
- "id": "21",
- "name": "WEEK_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "22",
- "name": "WEEK_OF_CAL_ID",
- "datatype": "int"
- },
- {
- "id": "23",
- "name": "MONTH_OF_QTR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "24",
- "name": "MONTH_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "25",
- "name": "MONTH_OF_CAL_ID",
- "datatype": "smallint"
- },
- {
- "id": "26",
- "name": "QTR_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "27",
- "name": "QTR_OF_CAL_ID",
- "datatype": "smallint"
- },
- {
- "id": "28",
- "name": "YEAR_OF_CAL_ID",
- "datatype": "smallint"
- },
- {
- "id": "29",
- "name": "YEAR_END_DT",
- "datatype": "string"
- },
- {
- "id": "30",
- "name": "QTR_END_DT",
- "datatype": "string"
- },
- {
- "id": "31",
- "name": "MONTH_END_DT",
- "datatype": "string"
- },
- {
- "id": "32",
- "name": "WEEK_END_DT",
- "datatype": "string"
- },
- {
- "id": "33",
- "name": "CAL_DT_NAME",
- "datatype": "string"
- },
- {
- "id": "34",
- "name": "CAL_DT_DESC",
- "datatype": "string"
- },
- {
- "id": "35",
- "name": "CAL_DT_SHORT_NAME",
- "datatype": "string"
- },
- {
- "id": "36",
- "name": "YTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "37",
- "name": "QTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "38",
- "name": "MTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "39",
- "name": "WTD_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "40",
- "name": "SEASON_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "41",
- "name": "DAY_IN_YEAR_COUNT",
- "datatype": "smallint"
- },
- {
- "id": "42",
- "name": "DAY_IN_QTR_COUNT",
- "datatype": "tinyint"
- },
- {
- "id": "43",
- "name": "DAY_IN_MONTH_COUNT",
- "datatype": "tinyint"
- },
- {
- "id": "44",
- "name": "DAY_IN_WEEK_COUNT",
- "datatype": "tinyint"
- },
- {
- "id": "45",
- "name": "RTL_YEAR_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "46",
- "name": "RTL_QTR_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "47",
- "name": "RTL_MONTH_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "48",
- "name": "RTL_WEEK_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "49",
- "name": "CS_WEEK_BEG_DT",
- "datatype": "string"
- },
- {
- "id": "50",
- "name": "CAL_DATE",
- "datatype": "string"
- },
- {
- "id": "51",
- "name": "DAY_OF_WEEK",
- "datatype": "string"
- },
- {
- "id": "52",
- "name": "MONTH_ID",
- "datatype": "string"
- },
- {
- "id": "53",
- "name": "PRD_DESC",
- "datatype": "string"
- },
- {
- "id": "54",
- "name": "PRD_FLAG",
- "datatype": "string"
- },
- {
- "id": "55",
- "name": "PRD_ID",
- "datatype": "string"
- },
- {
- "id": "56",
- "name": "PRD_IND",
- "datatype": "string"
- },
- {
- "id": "57",
- "name": "QTR_DESC",
- "datatype": "string"
- },
- {
- "id": "58",
- "name": "QTR_ID",
- "datatype": "string"
- },
- {
- "id": "59",
- "name": "QTR_IND",
- "datatype": "string"
- },
- {
- "id": "60",
- "name": "RETAIL_WEEK",
- "datatype": "string"
- },
- {
- "id": "61",
- "name": "RETAIL_YEAR",
- "datatype": "string"
- },
- {
- "id": "62",
- "name": "RETAIL_START_DATE",
- "datatype": "string"
- },
- {
- "id": "63",
- "name": "RETAIL_WK_END_DATE",
- "datatype": "string"
- },
- {
- "id": "64",
- "name": "WEEK_IND",
- "datatype": "string"
- },
- {
- "id": "65",
- "name": "WEEK_NUM_DESC",
- "datatype": "string"
- },
- {
- "id": "66",
- "name": "WEEK_BEG_DATE",
- "datatype": "string"
- },
- {
- "id": "67",
- "name": "WEEK_END_DATE",
- "datatype": "string"
- },
- {
- "id": "68",
- "name": "WEEK_IN_YEAR_ID",
- "datatype": "string"
- },
- {
- "id": "69",
- "name": "WEEK_ID",
- "datatype": "string"
- },
- {
- "id": "70",
- "name": "WEEK_BEG_END_DESC_MDY",
- "datatype": "string"
- },
- {
- "id": "71",
- "name": "WEEK_BEG_END_DESC_MD",
- "datatype": "string"
- },
- {
- "id": "72",
- "name": "YEAR_ID",
- "datatype": "string"
- },
- {
- "id": "73",
- "name": "YEAR_IND",
- "datatype": "string"
- },
- {
- "id": "74",
- "name": "CAL_DT_MNS_1YEAR_DT",
- "datatype": "string"
- },
- {
- "id": "75",
- "name": "CAL_DT_MNS_2YEAR_DT",
- "datatype": "string"
- },
- {
- "id": "76",
- "name": "CAL_DT_MNS_1QTR_DT",
- "datatype": "string"
- },
- {
- "id": "77",
- "name": "CAL_DT_MNS_2QTR_DT",
- "datatype": "string"
- },
- {
- "id": "78",
- "name": "CAL_DT_MNS_1MONTH_DT",
- "datatype": "string"
- },
- {
- "id": "79",
- "name": "CAL_DT_MNS_2MONTH_DT",
- "datatype": "string"
- },
- {
- "id": "80",
- "name": "CAL_DT_MNS_1WEEK_DT",
- "datatype": "string"
- },
- {
- "id": "81",
- "name": "CAL_DT_MNS_2WEEK_DT",
- "datatype": "string"
- },
- {
- "id": "82",
- "name": "CURR_CAL_DT_MNS_1YEAR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "83",
- "name": "CURR_CAL_DT_MNS_2YEAR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "84",
- "name": "CURR_CAL_DT_MNS_1QTR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "85",
- "name": "CURR_CAL_DT_MNS_2QTR_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "86",
- "name": "CURR_CAL_DT_MNS_1MONTH_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "87",
- "name": "CURR_CAL_DT_MNS_2MONTH_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "88",
- "name": "CURR_CAL_DT_MNS_1WEEK_YN_IND",
- "datatype": "tinyint"
- },
- {
- "id": "89",
- "name": "CURR_CAL_DT_MNS_2WEEK_YN_IND",
- "datatype": "tinyint"
- },
- {
- "id": "90",
- "name": "RTL_MONTH_OF_RTL_YEAR_ID",
- "datatype": "string"
- },
- {
- "id": "91",
- "name": "RTL_QTR_OF_RTL_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "92",
- "name": "RTL_WEEK_OF_RTL_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "93",
- "name": "SEASON_OF_YEAR_ID",
- "datatype": "tinyint"
- },
- {
- "id": "94",
- "name": "YTM_YN_ID",
- "datatype": "tinyint"
- },
- {
- "id": "95",
- "name": "YTQ_YN_ID",
- "datatype": "tinyint"
- }
- ],
- "database": "edw",
- "table_type": "VIRTUAL_VIEW",
- "last_modified": 0
+
+ "uuid" : "0ff420eb-79ad-40bd-bca9-12d8cd05c60a",
+ "name" : "V_TEST_CAL_DT",
+ "columns" : [ {
+ "id" : "1",
+ "name" : "CAL_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "2",
+ "name" : "YEAR_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "3",
+ "name" : "QTR_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "4",
+ "name" : "MONTH_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "5",
+ "name" : "WEEK_BEG_DT",
+ "datatype" : "date"
+ }, {
+ "id" : "6",
+ "name" : "AGE_FOR_YEAR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "7",
+ "name" : "AGE_FOR_QTR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "8",
+ "name" : "AGE_FOR_MONTH_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "9",
+ "name" : "AGE_FOR_WEEK_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "10",
+ "name" : "AGE_FOR_DT_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "11",
+ "name" : "AGE_FOR_RTL_YEAR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "12",
+ "name" : "AGE_FOR_RTL_QTR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "13",
+ "name" : "AGE_FOR_RTL_MONTH_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "14",
+ "name" : "AGE_FOR_RTL_WEEK_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "15",
+ "name" : "AGE_FOR_CS_WEEK_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "16",
+ "name" : "DAY_OF_CAL_ID",
+ "datatype" : "int"
+ }, {
+ "id" : "17",
+ "name" : "DAY_OF_YEAR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "18",
+ "name" : "DAY_OF_QTR_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "19",
+ "name" : "DAY_OF_MONTH_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "20",
+ "name" : "DAY_OF_WEEK_ID",
+ "datatype" : "int"
+ }, {
+ "id" : "21",
+ "name" : "WEEK_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "22",
+ "name" : "WEEK_OF_CAL_ID",
+ "datatype" : "int"
+ }, {
+ "id" : "23",
+ "name" : "MONTH_OF_QTR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "24",
+ "name" : "MONTH_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "25",
+ "name" : "MONTH_OF_CAL_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "26",
+ "name" : "QTR_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "27",
+ "name" : "QTR_OF_CAL_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "28",
+ "name" : "YEAR_OF_CAL_ID",
+ "datatype" : "smallint"
+ }, {
+ "id" : "29",
+ "name" : "YEAR_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "30",
+ "name" : "QTR_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "31",
+ "name" : "MONTH_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "32",
+ "name" : "WEEK_END_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "33",
+ "name" : "CAL_DT_NAME",
+ "datatype" : "string"
+ }, {
+ "id" : "34",
+ "name" : "CAL_DT_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "35",
+ "name" : "CAL_DT_SHORT_NAME",
+ "datatype" : "string"
+ }, {
+ "id" : "36",
+ "name" : "YTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "37",
+ "name" : "QTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "38",
+ "name" : "MTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "39",
+ "name" : "WTD_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "40",
+ "name" : "SEASON_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "41",
+ "name" : "DAY_IN_YEAR_COUNT",
+ "datatype" : "smallint"
+ }, {
+ "id" : "42",
+ "name" : "DAY_IN_QTR_COUNT",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "43",
+ "name" : "DAY_IN_MONTH_COUNT",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "44",
+ "name" : "DAY_IN_WEEK_COUNT",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "45",
+ "name" : "RTL_YEAR_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "46",
+ "name" : "RTL_QTR_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "47",
+ "name" : "RTL_MONTH_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "48",
+ "name" : "RTL_WEEK_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "49",
+ "name" : "CS_WEEK_BEG_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "50",
+ "name" : "CAL_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "51",
+ "name" : "DAY_OF_WEEK",
+ "datatype" : "string"
+ }, {
+ "id" : "52",
+ "name" : "MONTH_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "53",
+ "name" : "PRD_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "54",
+ "name" : "PRD_FLAG",
+ "datatype" : "string"
+ }, {
+ "id" : "55",
+ "name" : "PRD_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "56",
+ "name" : "PRD_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "57",
+ "name" : "QTR_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "58",
+ "name" : "QTR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "59",
+ "name" : "QTR_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "60",
+ "name" : "RETAIL_WEEK",
+ "datatype" : "string"
+ }, {
+ "id" : "61",
+ "name" : "RETAIL_YEAR",
+ "datatype" : "string"
+ }, {
+ "id" : "62",
+ "name" : "RETAIL_START_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "63",
+ "name" : "RETAIL_WK_END_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "64",
+ "name" : "WEEK_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "65",
+ "name" : "WEEK_NUM_DESC",
+ "datatype" : "string"
+ }, {
+ "id" : "66",
+ "name" : "WEEK_BEG_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "67",
+ "name" : "WEEK_END_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "68",
+ "name" : "WEEK_IN_YEAR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "69",
+ "name" : "WEEK_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "70",
+ "name" : "WEEK_BEG_END_DESC_MDY",
+ "datatype" : "string"
+ }, {
+ "id" : "71",
+ "name" : "WEEK_BEG_END_DESC_MD",
+ "datatype" : "string"
+ }, {
+ "id" : "72",
+ "name" : "YEAR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "73",
+ "name" : "YEAR_IND",
+ "datatype" : "string"
+ }, {
+ "id" : "74",
+ "name" : "CAL_DT_MNS_1YEAR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "75",
+ "name" : "CAL_DT_MNS_2YEAR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "76",
+ "name" : "CAL_DT_MNS_1QTR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "77",
+ "name" : "CAL_DT_MNS_2QTR_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "78",
+ "name" : "CAL_DT_MNS_1MONTH_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "79",
+ "name" : "CAL_DT_MNS_2MONTH_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "80",
+ "name" : "CAL_DT_MNS_1WEEK_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "81",
+ "name" : "CAL_DT_MNS_2WEEK_DT",
+ "datatype" : "string"
+ }, {
+ "id" : "82",
+ "name" : "CURR_CAL_DT_MNS_1YEAR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "83",
+ "name" : "CURR_CAL_DT_MNS_2YEAR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "84",
+ "name" : "CURR_CAL_DT_MNS_1QTR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "85",
+ "name" : "CURR_CAL_DT_MNS_2QTR_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "86",
+ "name" : "CURR_CAL_DT_MNS_1MONTH_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "87",
+ "name" : "CURR_CAL_DT_MNS_2MONTH_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "88",
+ "name" : "CURR_CAL_DT_MNS_1WEEK_YN_IND",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "89",
+ "name" : "CURR_CAL_DT_MNS_2WEEK_YN_IND",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "90",
+ "name" : "RTL_MONTH_OF_RTL_YEAR_ID",
+ "datatype" : "string"
+ }, {
+ "id" : "91",
+ "name" : "RTL_QTR_OF_RTL_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "92",
+ "name" : "RTL_WEEK_OF_RTL_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "93",
+ "name" : "SEASON_OF_YEAR_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "94",
+ "name" : "YTM_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "95",
+ "name" : "YTQ_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "96",
+ "name" : "YTW_YN_ID",
+ "datatype" : "tinyint"
+ }, {
+ "id" : "97",
+ "name" : "V_CAL_DT_CRE_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "98",
+ "name" : "V_CAL_DT_CRE_USER",
+ "datatype" : "string"
+ }, {
+ "id" : "99",
+ "name" : "V_CAL_DT_UPD_DATE",
+ "datatype" : "string"
+ }, {
+ "id" : "100",
+ "name" : "V_CAL_DT_UPD_USER",
+ "datatype" : "string"
+ } ],
+ "database" : "edw",
+ "table_type" : "VIRTUAL_VIEW",
+ "last_modified" : 0
}
\ No newline at end of file