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:43 UTC
[36/50] [abbrv] kylin git commit: minor,
remove useless columns in cal_dt in examples
minor, remove useless columns in cal_dt in examples
Project: http://git-wip-us.apache.org/repos/asf/kylin/repo
Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/eb991059
Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/eb991059
Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/eb991059
Branch: refs/heads/1.5.x-HBase1.x
Commit: eb991059fc48dee03278e729a4eeacebf92e6409
Parents: 2ed2b38
Author: Hongbin Ma <ma...@apache.org>
Authored: Wed Aug 31 19:11:16 2016 +0800
Committer: Hongbin Ma <ma...@apache.org>
Committed: Wed Aug 31 19:11:31 2016 +0800
----------------------------------------------------------------------
.../localmeta/table/EDW.TEST_CAL_DT.json | 892 ++++++++++---------
.../localmeta/table/EDW.V_TEST_CAL_DT.json | 889 +++++++++---------
2 files changed, 968 insertions(+), 813 deletions(-)
----------------------------------------------------------------------
http://git-wip-us.apache.org/repos/asf/kylin/blob/eb991059/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 9296109..d64eb80 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,408 +1,488 @@
{
-
- "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" : "CRE_DATE",
- "datatype" : "string"
- }, {
- "id" : "98",
- "name" : "CRE_USER",
- "datatype" : "string"
- }, {
- "id" : "99",
- "name" : "UPD_DATE",
- "datatype" : "string"
- }, {
- "id" : "100",
- "name" : "UPD_USER",
- "datatype" : "string"
- } ],
- "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"
+ }
+ ],
+ "database": "edw",
+ "last_modified": 0
}
\ No newline at end of file
http://git-wip-us.apache.org/repos/asf/kylin/blob/eb991059/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 0015301..c48b9e2 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,409 +1,484 @@
{
-
- "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" : "CRE_DATE",
- "datatype" : "string"
- }, {
- "id" : "98",
- "name" : "CRE_USER",
- "datatype" : "string"
- }, {
- "id" : "99",
- "name" : "UPD_DATE",
- "datatype" : "string"
- }, {
- "id" : "100",
- "name" : "UPD_USER",
- "datatype" : "string"
- } ],
- "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"
+ }
+ ],
+ "database": "edw",
+ "table_type": "VIRTUAL_VIEW",
+ "last_modified": 0
}
\ No newline at end of file