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-CDH5.7 Commit: 894c16f2c978667e2526c6a2a9e46c861e644ff8 Parents: 9702dff Author: Hongbin Ma <mahong...@apache.org> Authored: Wed Aug 31 20:12:45 2016 +0800 Committer: Hongbin Ma <mahong...@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
