Repository: kylin Updated Branches: refs/heads/KYLIN-2197 [created] 83a99ac99
add test case testCuboid_onlyBaseCuboid() Project: http://git-wip-us.apache.org/repos/asf/kylin/repo Commit: http://git-wip-us.apache.org/repos/asf/kylin/commit/83a99ac9 Tree: http://git-wip-us.apache.org/repos/asf/kylin/tree/83a99ac9 Diff: http://git-wip-us.apache.org/repos/asf/kylin/diff/83a99ac9 Branch: refs/heads/KYLIN-2197 Commit: 83a99ac9946ffc5c08b22f9205a56ac897baa36a Parents: 9410b01 Author: Li Yang <[email protected]> Authored: Wed Nov 16 13:33:08 2016 +0800 Committer: Li Yang <[email protected]> Committed: Wed Nov 16 13:33:08 2016 +0800 ---------------------------------------------------------------------- .../kylin/cube/cuboid/CuboidSchedulerTest.java | 6 + .../localmeta/cube_desc/ALL_LABEL_CU.json | 682 +++++++++++++++ .../table/DEFAULT.DM_CLJY_M_ALL_LABEL.json | 862 +++++++++++++++++++ 3 files changed, 1550 insertions(+) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/kylin/blob/83a99ac9/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java ---------------------------------------------------------------------- diff --git a/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java b/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java index ecb1200..8dcbfcf 100644 --- a/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java +++ b/core-cube/src/test/java/org/apache/kylin/cube/cuboid/CuboidSchedulerTest.java @@ -283,6 +283,12 @@ public class CuboidSchedulerTest extends LocalFileMetadataTestCase { assertEquals(cuboidScheduler.getCuboidCount(), sum); } + @Test + public void testCuboid_onlyBaseCuboid() { + CubeDesc cube = getCubeDescManager().getCubeDesc("ALL_LABEL_CU"); + CuboidCLI.simulateCuboidGeneration(cube, true); + } + public CubeDescManager getCubeDescManager() { return CubeDescManager.getInstance(getTestConfig()); } http://git-wip-us.apache.org/repos/asf/kylin/blob/83a99ac9/examples/test_case_data/localmeta/cube_desc/ALL_LABEL_CU.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/cube_desc/ALL_LABEL_CU.json b/examples/test_case_data/localmeta/cube_desc/ALL_LABEL_CU.json new file mode 100644 index 0000000..d8ca467 --- /dev/null +++ b/examples/test_case_data/localmeta/cube_desc/ALL_LABEL_CU.json @@ -0,0 +1,682 @@ +{ + "uuid" : "9e89e128-f13e-4209-82d2-973985114793", + "last_modified" : 1479207711845, + "version" : "1.6.0", + "name" : "ALL_LABEL_CU", + "model_name" : "ALL_LABEL", + "description" : "", + "null_string" : null, + "dimensions" : [ { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.MONTH_ID", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "MONTH_ID", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.PROV_ID", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "PROV_ID", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.AREA_ID", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "AREA_ID", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.SERVICE_TYPE", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "SERVICE_TYPE", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.PAY_MODE", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "PAY_MODE", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_INNET", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_INNET", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_DEV", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_DEV", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_BREAK", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_BREAK", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_ACTIVE", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_ACTIVE", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_LOWER_VALUE_USER", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_LOWER_VALUE_USER", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.PRODUCT_CLASS", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "PRODUCT_CLASS", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.PRODUCT_CLASS_DESC", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "PRODUCT_CLASS_DESC", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.PRODUCT_BASE_CLASS", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "PRODUCT_BASE_CLASS", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.PRODUCT_BASE_CLASS_DESC", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "PRODUCT_BASE_CLASS_DESC", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.USER_STATUS", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "USER_STATUS", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_THIS_ACCT", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_THIS_ACCT", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_CARD", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_CARD", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.ACTIVITY_TYPE", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "ACTIVITY_TYPE", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.AGREE_EFF_DATE", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "AGREE_EFF_DATE", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_USE_4G", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_USE_4G", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_SNAPSHOT_USER", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_SNAPSHOT_USER", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_SNAPSHOT_USER_4GSJJS", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_SNAPSHOT_USER_4GSJJS", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_SK", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_SK", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.SK_TYPE", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "SK_TYPE", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_HONOR", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_HONOR", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_LOYAL", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_LOYAL", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_GROUP", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_GROUP", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_YZDYH", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_YZDYH", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_SIM", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_SIM", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_SANWU", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_SANWU", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_VIP_VALID", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_VIP_VALID", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_USIM", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_USIM", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_NEW_4G_SERV", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_NEW_4G_SERV", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.CUST_SEX", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "CUST_SEX", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.CERT_AGE", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "CERT_AGE", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_YK", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_YK", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_CRW", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_CRW", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.CITY_DESC", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "CITY_DESC", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.SERVICE_TYPE_NEW", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "SERVICE_TYPE_NEW", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_ZHWJ", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_ZHWJ", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_GXZH", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_GXZH", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_ZF", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_ZF", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.IS_WJT", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "IS_WJT", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.CARD_TYPE", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "CARD_TYPE", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.CHANNEL_ID", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "CHANNEL_ID", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.CHANNEL_TYPE", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "CHANNEL_TYPE", + "derived" : null + }, { + "name" : "DEFAULT.DM_CLJY_M_ALL_LABEL.CHANNEL_NAME", + "table" : "DEFAULT.DM_CLJY_M_ALL_LABEL", + "column" : "CHANNEL_NAME", + "derived" : null + }, { + "name" : "DEFAULT.DIM_KFPT_IS_OR_NO_DERIVED", + "table" : "DEFAULT.DIM_KFPT_IS_OR_NO", + "column" : null, + "derived" : [ "IS_ID" ] + }, { + "name" : "DEFAULT.DIM_KFPT_IS_OR_NO_DERIVED", + "table" : "DEFAULT.DIM_KFPT_IS_OR_NO", + "column" : null, + "derived" : [ "IS_NAME" ] + }, { + "name" : "DEFAULT.DIM_KFPT_SERVICE_TYPE_DERIVED", + "table" : "DEFAULT.DIM_KFPT_SERVICE_TYPE", + "column" : null, + "derived" : [ "SERVICE_TYPE" ] + }, { + "name" : "DEFAULT.DIM_KFPT_SERVICE_TYPE_DERIVED", + "table" : "DEFAULT.DIM_KFPT_SERVICE_TYPE", + "column" : null, + "derived" : [ "SERVICE_TYPE_NAME" ] + }, { + "name" : "DEFAULT.DIM_KFPT_PAY_MODE_CLASS_DERIVED", + "table" : "DEFAULT.DIM_KFPT_PAY_MODE_CLASS", + "column" : null, + "derived" : [ "PAY_MODE" ] + }, { + "name" : "DEFAULT.DIM_KFPT_PAY_MODE_CLASS_DERIVED", + "table" : "DEFAULT.DIM_KFPT_PAY_MODE_CLASS", + "column" : null, + "derived" : [ "PAY_MODE_DESC" ] + }, { + "name" : "DEFAULT.DIM_KFPT_AREA_DERIVED", + "table" : "DEFAULT.DIM_KFPT_AREA", + "column" : null, + "derived" : [ "AREA_ID" ] + }, { + "name" : "DEFAULT.DIM_KFPT_AREA_DERIVED", + "table" : "DEFAULT.DIM_KFPT_AREA", + "column" : null, + "derived" : [ "AREA_NAME" ] + }, { + "name" : "DEFAULT.DIM_KFPT_PROVINCE_DERIVED", + "table" : "DEFAULT.DIM_KFPT_PROVINCE", + "column" : null, + "derived" : [ "PROV_ID" ] + }, { + "name" : "DEFAULT.DIM_KFPT_PROVINCE_DERIVED", + "table" : "DEFAULT.DIM_KFPT_PROVINCE", + "column" : null, + "derived" : [ "PROV_NAME" ] + } ], + "measures" : [ { + "name" : "_COUNT_", + "function" : { + "expression" : "COUNT", + "parameter" : { + "type" : "constant", + "value" : "1", + "next_parameter" : null + }, + "returntype" : "bigint" + }, + "dependent_measure_ref" : null + }, { + "name" : "åºè´¦è´¹ç¨", + "function" : { + "expression" : "SUM", + "parameter" : { + "type" : "column", + "value" : "ACCT_FEE", + "next_parameter" : null + }, + "returntype" : "bigint" + }, + "dependent_measure_ref" : null + }, { + "name" : "æç§è´¹", + "function" : { + "expression" : "SUM", + "parameter" : { + "type" : "column", + "value" : "RENT_FEE", + "next_parameter" : null + }, + "returntype" : "bigint" + }, + "dependent_measure_ref" : null + }, { + "name" : "åè½è´¹", + "function" : { + "expression" : "SUM", + "parameter" : { + "type" : "column", + "value" : "FUNC_FEE", + "next_parameter" : null + }, + "returntype" : "bigint" + }, + "dependent_measure_ref" : null + }, { + "name" : "å ¶ä»åºå®è´¹", + "function" : { + "expression" : "SUM", + "parameter" : { + "type" : "column", + "value" : "OT_FIX_FEE", + "next_parameter" : null + }, + "returntype" : "bigint" + }, + "dependent_measure_ref" : null + }, { + "name" : "æ¬å°éè¯è´¹", + "function" : { + "expression" : "SUM", + "parameter" : { + "type" : "column", + "value" : "LOCAL_VOICE_FEE", + "next_parameter" : null + }, + "returntype" : "bigint" + }, + "dependent_measure_ref" : null + }, { + "name" : "é¿ééè¯è´¹", + "function" : { + "expression" : "SUM", + "parameter" : { + "type" : "column", + "value" : "LONG_VOICE_FEE", + "next_parameter" : null + }, + "returntype" : "bigint" + }, + "dependent_measure_ref" : null + }, { + "name" : "漫游éè¯è´¹", + "function" : { + "expression" : "SUM", + "parameter" : { + "type" : "column", + "value" : "ROAM_VOICE_FEE", + "next_parameter" : null + }, + "returntype" : "bigint" + }, + "dependent_measure_ref" : null + }, { + "name" : "å ¶ä»è¯é³éè¯è´¹", + "function" : { + "expression" : "SUM", + "parameter" : { + "type" : "column", + "value" : "OT_VOICE_FEE", + "next_parameter" : null + }, + "returntype" : "bigint" + }, + "dependent_measure_ref" : null + } ], + "dictionaries" : [ ], + "rowkey" : { + "rowkey_columns" : [ { + "column" : "MONTH_ID", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "PROV_ID", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "AREA_ID", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "SERVICE_TYPE", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "PAY_MODE", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_INNET", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_DEV", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_BREAK", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_ACTIVE", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_LOWER_VALUE_USER", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "PRODUCT_CLASS", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "PRODUCT_CLASS_DESC", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "PRODUCT_BASE_CLASS", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "PRODUCT_BASE_CLASS_DESC", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "USER_STATUS", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_THIS_ACCT", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_CARD", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "ACTIVITY_TYPE", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "AGREE_EFF_DATE", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_USE_4G", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_SNAPSHOT_USER", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_SNAPSHOT_USER_4GSJJS", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_SK", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "SK_TYPE", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_HONOR", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_LOYAL", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_GROUP", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_YZDYH", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_SIM", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_SANWU", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_VIP_VALID", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_USIM", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_NEW_4G_SERV", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "CUST_SEX", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "CERT_AGE", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_YK", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_CRW", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "CITY_DESC", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "SERVICE_TYPE_NEW", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_ZHWJ", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_GXZH", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_ZF", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "IS_WJT", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "CARD_TYPE", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "CHANNEL_ID", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "CHANNEL_TYPE", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + }, { + "column" : "CHANNEL_NAME", + "encoding" : "dict", + "isShardBy" : false, + "index" : "eq" + } ] + }, + "hbase_mapping" : { + "column_family" : [ { + "name" : "F1", + "columns" : [ { + "qualifier" : "M", + "measure_refs" : [ "_COUNT_", "åºè´¦è´¹ç¨", "æç§è´¹", "åè½è´¹", "å ¶ä»åºå®è´¹", "æ¬å°éè¯è´¹", "é¿ééè¯è´¹", "漫游éè¯è´¹", "å ¶ä»è¯é³éè¯è´¹" ] + } ] + } ] + }, + "aggregation_groups" : [ { + "includes" : [ "MONTH_ID", "PROV_ID", "AREA_ID", "PAY_MODE", "IS_INNET" ], + "select_rule" : { + "hierarchy_dims" : [ [ "PROV_ID", "AREA_ID" ] ], + "mandatory_dims" : [ "MONTH_ID" ], + "joint_dims" : [ [ "IS_INNET", "PAY_MODE" ] ] + } + }, { + "includes" : [ "SERVICE_TYPE", "PRODUCT_CLASS", "AGREE_EFF_DATE", "CHANNEL_ID", "CHANNEL_TYPE", "CHANNEL_NAME", "IS_CARD", "MONTH_ID" ], + "select_rule" : { + "hierarchy_dims" : [ ], + "mandatory_dims" : [ "MONTH_ID" ], + "joint_dims" : [ [ "CHANNEL_ID", "CHANNEL_TYPE", "CHANNEL_NAME" ], [ "SERVICE_TYPE", "IS_CARD" ] ] + } + } ], + "signature" : "4NqJVcVIYRF5PkJ0jS+9Rg==", + "notify_list" : [ ], + "status_need_notify" : [ "ERROR", "DISCARDED", "SUCCEED" ], + "partition_date_start" : 1469923200000, + "partition_date_end" : 3153600000000, + "auto_merge_time_ranges" : [ 604800000, 2419200000 ], + "retention_range" : 0, + "engine_type" : 100, + "storage_type" : 100, + "override_kylin_properties" : { + "kylin.cube.algorithm" : "auto", + "kylin.cube.aggrgroup.max.combination" : "4096", + "kylin.job.cubing.inmem.sampling.percent" : "100", + "kylin.hbase.default.compression.codec" : "none" + } +} \ No newline at end of file http://git-wip-us.apache.org/repos/asf/kylin/blob/83a99ac9/examples/test_case_data/localmeta/table/DEFAULT.DM_CLJY_M_ALL_LABEL.json ---------------------------------------------------------------------- diff --git a/examples/test_case_data/localmeta/table/DEFAULT.DM_CLJY_M_ALL_LABEL.json b/examples/test_case_data/localmeta/table/DEFAULT.DM_CLJY_M_ALL_LABEL.json new file mode 100644 index 0000000..8e9fb9c --- /dev/null +++ b/examples/test_case_data/localmeta/table/DEFAULT.DM_CLJY_M_ALL_LABEL.json @@ -0,0 +1,862 @@ +{ + "uuid" : "cd267e5b-6835-4db2-a861-8b78f38271fe", + "last_modified" : 1479202699684, + "version" : "1.6.0", + "name" : "DM_CLJY_M_ALL_LABEL", + "columns" : [ { + "id" : "1", + "name" : "MONTH_ID", + "datatype" : "varchar(256)" + }, { + "id" : "2", + "name" : "PROV_ID", + "datatype" : "varchar(256)" + }, { + "id" : "3", + "name" : "AREA_ID", + "datatype" : "varchar(256)" + }, { + "id" : "4", + "name" : "SUBS_INSTANCE_ID", + "datatype" : "varchar(256)" + }, { + "id" : "5", + "name" : "DEVICE_BIGINT", + "datatype" : "varchar(256)" + }, { + "id" : "6", + "name" : "SERVICE_TYPE", + "datatype" : "varchar(256)" + }, { + "id" : "7", + "name" : "PAY_MODE", + "datatype" : "varchar(256)" + }, { + "id" : "8", + "name" : "IS_INNET", + "datatype" : "varchar(256)" + }, { + "id" : "9", + "name" : "IS_DEV", + "datatype" : "varchar(256)" + }, { + "id" : "10", + "name" : "IS_BREAK", + "datatype" : "varchar(256)" + }, { + "id" : "11", + "name" : "IS_ACTIVE", + "datatype" : "varchar(256)" + }, { + "id" : "12", + "name" : "IS_LOWER_VALUE_USER", + "datatype" : "varchar(256)" + }, { + "id" : "13", + "name" : "CUST_ID", + "datatype" : "varchar(256)" + }, { + "id" : "14", + "name" : "PRODUCT_CLASS", + "datatype" : "varchar(256)" + }, { + "id" : "15", + "name" : "PRODUCT_CLASS_DESC", + "datatype" : "varchar(256)" + }, { + "id" : "16", + "name" : "PRODUCT_BASE_CLASS", + "datatype" : "varchar(256)" + }, { + "id" : "17", + "name" : "PRODUCT_BASE_CLASS_DESC", + "datatype" : "varchar(256)" + }, { + "id" : "18", + "name" : "USER_STATUS", + "datatype" : "varchar(256)" + }, { + "id" : "19", + "name" : "ACCT_FEE", + "datatype" : "bigint" + }, { + "id" : "20", + "name" : "RENT_FEE", + "datatype" : "bigint" + }, { + "id" : "21", + "name" : "FUNC_FEE", + "datatype" : "bigint" + }, { + "id" : "22", + "name" : "OT_FIX_FEE", + "datatype" : "bigint" + }, { + "id" : "23", + "name" : "LOCAL_VOICE_FEE", + "datatype" : "bigint" + }, { + "id" : "24", + "name" : "LONG_VOICE_FEE", + "datatype" : "bigint" + }, { + "id" : "25", + "name" : "ROAM_VOICE_FEE", + "datatype" : "bigint" + }, { + "id" : "26", + "name" : "OT_VOICE_FEE", + "datatype" : "bigint" + }, { + "id" : "27", + "name" : "NO_ROAM_CALL_DURA", + "datatype" : "bigint" + }, { + "id" : "28", + "name" : "SN_ROAM_CALL_DURA", + "datatype" : "bigint" + }, { + "id" : "29", + "name" : "GN_ROAM_CALL_DURA", + "datatype" : "bigint" + }, { + "id" : "30", + "name" : "GAT_ROAM_CALL_DURA", + "datatype" : "bigint" + }, { + "id" : "31", + "name" : "GJ_ROAM_CALL_DURA", + "datatype" : "bigint" + }, { + "id" : "32", + "name" : "NO_ROAM_CDR_NUM", + "datatype" : "bigint" + }, { + "id" : "33", + "name" : "SN_ROAM_CDR_NUM", + "datatype" : "bigint" + }, { + "id" : "34", + "name" : "GN_ROAM_CDR_NUM", + "datatype" : "bigint" + }, { + "id" : "35", + "name" : "GAT_ROAM_CDR_NUM", + "datatype" : "bigint" + }, { + "id" : "36", + "name" : "GJ_ROAM_CDR_NUM", + "datatype" : "bigint" + }, { + "id" : "37", + "name" : "LOCAL_FLUX", + "datatype" : "bigint" + }, { + "id" : "38", + "name" : "SN_ROAM_FLUX", + "datatype" : "bigint" + }, { + "id" : "39", + "name" : "GN_ROAM_FLUX", + "datatype" : "bigint" + }, { + "id" : "40", + "name" : "GAT_ROAM_FLUX", + "datatype" : "bigint" + }, { + "id" : "41", + "name" : "GJ_ROAM_FLUX", + "datatype" : "bigint" + }, { + "id" : "42", + "name" : "PP_SMS_CNT_UP", + "datatype" : "bigint" + }, { + "id" : "43", + "name" : "SP_SMS_CNT_UP", + "datatype" : "bigint" + }, { + "id" : "44", + "name" : "SP_SMS_CNT_DOWN", + "datatype" : "bigint" + }, { + "id" : "45", + "name" : "OWE_FEE", + "datatype" : "bigint" + }, { + "id" : "46", + "name" : "CALL_FEE", + "datatype" : "bigint" + }, { + "id" : "47", + "name" : "CALL_SC", + "datatype" : "bigint" + }, { + "id" : "48", + "name" : "CALL_TIMES", + "datatype" : "bigint" + }, { + "id" : "49", + "name" : "USE_FLOW", + "datatype" : "bigint" + }, { + "id" : "50", + "name" : "ACTIVATE_DATE", + "datatype" : "varchar(256)" + }, { + "id" : "51", + "name" : "ONLINE_DUR_LVL", + "datatype" : "bigint" + }, { + "id" : "52", + "name" : "CHURN_FLAG", + "datatype" : "varchar(256)" + }, { + "id" : "53", + "name" : "IF_MBTOCB", + "datatype" : "bigint" + }, { + "id" : "54", + "name" : "SWITCH_EFF_DATE", + "datatype" : "varchar(256)" + }, { + "id" : "55", + "name" : "JF_TIMES", + "datatype" : "bigint" + }, { + "id" : "56", + "name" : "IS_THIS_ACCT", + "datatype" : "varchar(256)" + }, { + "id" : "57", + "name" : "IS_CARD", + "datatype" : "varchar(256)" + }, { + "id" : "58", + "name" : "ACTIVITY_TYPE", + "datatype" : "varchar(256)" + }, { + "id" : "59", + "name" : "AGREE_EFF_DATE", + "datatype" : "bigint" + }, { + "id" : "60", + "name" : "EXP_DATE", + "datatype" : "bigint" + }, { + "id" : "61", + "name" : "ACTIVITY_END_TIME", + "datatype" : "bigint" + }, { + "id" : "62", + "name" : "FIRST_CREDIT", + "datatype" : "bigint" + }, { + "id" : "63", + "name" : "NOW_CREDIT", + "datatype" : "bigint" + }, { + "id" : "64", + "name" : "SMS_MMS_PKG", + "datatype" : "varchar(256)" + }, { + "id" : "65", + "name" : "SMS_RATIO", + "datatype" : "bigint" + }, { + "id" : "66", + "name" : "FLUX_PKG", + "datatype" : "varchar(256)" + }, { + "id" : "67", + "name" : "STREAM_RATIO", + "datatype" : "bigint" + }, { + "id" : "68", + "name" : "VOICE_PKG", + "datatype" : "varchar(256)" + }, { + "id" : "69", + "name" : "CALL_RATIO", + "datatype" : "bigint" + }, { + "id" : "70", + "name" : "MON_FEE", + "datatype" : "bigint" + }, { + "id" : "71", + "name" : "PROV_DESC", + "datatype" : "varchar(256)" + }, { + "id" : "72", + "name" : "AREA_NAME", + "datatype" : "varchar(256)" + }, { + "id" : "73", + "name" : "CHNL_TYPE1", + "datatype" : "varchar(256)" + }, { + "id" : "74", + "name" : "CHNL_TYPE", + "datatype" : "varchar(256)" + }, { + "id" : "75", + "name" : "CHNL_TYPE3", + "datatype" : "varchar(256)" + }, { + "id" : "76", + "name" : "IS_DUAL", + "datatype" : "varchar(256)" + }, { + "id" : "77", + "name" : "NETMWORK_TYPE", + "datatype" : "varchar(256)" + }, { + "id" : "78", + "name" : "U_MIZE", + "datatype" : "varchar(256)" + }, { + "id" : "79", + "name" : "T_MIZE", + "datatype" : "varchar(256)" + }, { + "id" : "80", + "name" : "M_MIZE", + "datatype" : "varchar(256)" + }, { + "id" : "81", + "name" : "ALL_MIZE", + "datatype" : "varchar(256)" + }, { + "id" : "82", + "name" : "TMNL_TYPE", + "datatype" : "varchar(256)" + }, { + "id" : "83", + "name" : "NEW_TYPE", + "datatype" : "varchar(256)" + }, { + "id" : "84", + "name" : "OS_DESC_IPHONE5", + "datatype" : "varchar(256)" + }, { + "id" : "85", + "name" : "FACTORY_DESC", + "datatype" : "varchar(256)" + }, { + "id" : "86", + "name" : "TERM_DESC", + "datatype" : "varchar(256)" + }, { + "id" : "87", + "name" : "USE_MONTHS", + "datatype" : "bigint" + }, { + "id" : "88", + "name" : "AVG_USE_MONTH", + "datatype" : "bigint" + }, { + "id" : "89", + "name" : "IS_USE_4G", + "datatype" : "bigint" + }, { + "id" : "90", + "name" : "IS_SNAPSHOT_USER", + "datatype" : "varchar(256)" + }, { + "id" : "91", + "name" : "IS_SNAPSHOT_USER_4GSJJS", + "datatype" : "varchar(256)" + }, { + "id" : "92", + "name" : "IS_SK", + "datatype" : "varchar(256)" + }, { + "id" : "93", + "name" : "SK_TYPE", + "datatype" : "varchar(256)" + }, { + "id" : "94", + "name" : "JIAZHI_FLAG", + "datatype" : "varchar(256)" + }, { + "id" : "95", + "name" : "JIAZHI_SCROE", + "datatype" : "bigint" + }, { + "id" : "96", + "name" : "MANU_ALIAS1", + "datatype" : "varchar(256)" + }, { + "id" : "97", + "name" : "MODEL_NAME1", + "datatype" : "varchar(256)" + }, { + "id" : "98", + "name" : "MANU_ALIAS", + "datatype" : "varchar(256)" + }, { + "id" : "99", + "name" : "MODEL_NAME", + "datatype" : "varchar(256)" + }, { + "id" : "100", + "name" : "MANU_ALIAS3", + "datatype" : "varchar(256)" + }, { + "id" : "101", + "name" : "MODEL_NAME3", + "datatype" : "varchar(256)" + }, { + "id" : "102", + "name" : "WENDING_FLAG", + "datatype" : "varchar(256)" + }, { + "id" : "103", + "name" : "LOST_RATE", + "datatype" : "bigint" + }, { + "id" : "104", + "name" : "USER_LEVEL_ZS", + "datatype" : "varchar(256)" + }, { + "id" : "105", + "name" : "USER_LEVEL_DESC_ZS", + "datatype" : "varchar(256)" + }, { + "id" : "106", + "name" : "WDJZ_CUBE_ZS", + "datatype" : "varchar(256)" + }, { + "id" : "107", + "name" : "WDJZ_CUBE1_ZS", + "datatype" : "varchar(256)" + }, { + "id" : "108", + "name" : "IS_HONOR", + "datatype" : "varchar(256)" + }, { + "id" : "109", + "name" : "IS_LOYAL", + "datatype" : "varchar(256)" + }, { + "id" : "110", + "name" : "USER_LEVEL_YPJ", + "datatype" : "varchar(256)" + }, { + "id" : "111", + "name" : "USER_LEVEL_DESC_YPJ", + "datatype" : "varchar(256)" + }, { + "id" : "112", + "name" : "WDJZ_CUBE_YPJ", + "datatype" : "varchar(256)" + }, { + "id" : "113", + "name" : "WDJZ_CUBE1_YPJ", + "datatype" : "varchar(256)" + }, { + "id" : "114", + "name" : "IS_GROUP", + "datatype" : "varchar(256)" + }, { + "id" : "115", + "name" : "CUST_SIZE", + "datatype" : "varchar(256)" + }, { + "id" : "116", + "name" : "CUST_NAME", + "datatype" : "varchar(256)" + }, { + "id" : "117", + "name" : "VIP_LEVEL", + "datatype" : "varchar(256)" + }, { + "id" : "118", + "name" : "IS_YZDYH", + "datatype" : "bigint" + }, { + "id" : "119", + "name" : "IS_SIM", + "datatype" : "varchar(256)" + }, { + "id" : "120", + "name" : "TMNL_TYPE_UNICOM", + "datatype" : "varchar(256)" + }, { + "id" : "121", + "name" : "IS_SANWU", + "datatype" : "varchar(256)" + }, { + "id" : "122", + "name" : "IS_VIP_VALID", + "datatype" : "varchar(256)" + }, { + "id" : "123", + "name" : "IS_USIM", + "datatype" : "varchar(256)" + }, { + "id" : "124", + "name" : "IS_NEW_4G_SERV", + "datatype" : "varchar(256)" + }, { + "id" : "125", + "name" : "CUST_SEX", + "datatype" : "varchar(256)" + }, { + "id" : "126", + "name" : "CERT_AGE", + "datatype" : "bigint" + }, { + "id" : "127", + "name" : "CONSTELLATION_DESC", + "datatype" : "varchar(256)" + }, { + "id" : "128", + "name" : "IS_VALID_FLAG", + "datatype" : "varchar(256)" + }, { + "id" : "129", + "name" : "PRE", + "datatype" : "varchar(256)" + }, { + "id" : "130", + "name" : "CHNL_TYPE4", + "datatype" : "varchar(256)" + }, { + "id" : "131", + "name" : "CHNL_TYPE1_151", + "datatype" : "varchar(256)" + }, { + "id" : "132", + "name" : "CHNL_TYPE_151", + "datatype" : "varchar(256)" + }, { + "id" : "133", + "name" : "CHNL_TYPE3_151", + "datatype" : "varchar(256)" + }, { + "id" : "134", + "name" : "CHNL_TYPE4_151", + "datatype" : "varchar(256)" + }, { + "id" : "135", + "name" : "IS_YK", + "datatype" : "varchar(256)" + }, { + "id" : "136", + "name" : "IS_CRW", + "datatype" : "varchar(256)" + }, { + "id" : "137", + "name" : "USER_STATUS_EXTEND", + "datatype" : "varchar(256)" + }, { + "id" : "138", + "name" : "PAY_MODE_EXTEND", + "datatype" : "varchar(256)" + }, { + "id" : "139", + "name" : "EFF_DATE_8", + "datatype" : "varchar(256)" + }, { + "id" : "140", + "name" : "EXP_DATE_8", + "datatype" : "varchar(256)" + }, { + "id" : "141", + "name" : "IS_RH", + "datatype" : "varchar(256)" + }, { + "id" : "142", + "name" : "CITY_NO", + "datatype" : "varchar(256)" + }, { + "id" : "143", + "name" : "CITY_DESC", + "datatype" : "varchar(256)" + }, { + "id" : "144", + "name" : "SERVICE_TYPE_NEW", + "datatype" : "varchar(256)" + }, { + "id" : "145", + "name" : "IS_151_ACCT", + "datatype" : "varchar(256)" + }, { + "id" : "146", + "name" : "CALL_DURA_TAG", + "datatype" : "bigint" + }, { + "id" : "147", + "name" : "FLUX_M_TAG", + "datatype" : "bigint" + }, { + "id" : "148", + "name" : "IS_16_HIGH_U", + "datatype" : "varchar(256)" + }, { + "id" : "149", + "name" : "LAST_STOP_DATE", + "datatype" : "varchar(256)" + }, { + "id" : "150", + "name" : "OUT_CALL_DURA", + "datatype" : "bigint" + }, { + "id" : "151", + "name" : "NO_ROAM_OUT_CALL_DURA", + "datatype" : "bigint" + }, { + "id" : "152", + "name" : "ROAM_OUT_CALL_DURA", + "datatype" : "bigint" + }, { + "id" : "153", + "name" : "OUT_JF_TIMES", + "datatype" : "bigint" + }, { + "id" : "154", + "name" : "NO_ROAM_OUT_JF_TIMES", + "datatype" : "bigint" + }, { + "id" : "155", + "name" : "ROAM_OUT_JF_TIMES", + "datatype" : "bigint" + }, { + "id" : "156", + "name" : "SERVICE_TYPE_OLD", + "datatype" : "varchar(256)" + }, { + "id" : "157", + "name" : "IS_ZHWJ", + "datatype" : "varchar(256)" + }, { + "id" : "158", + "name" : "IS_GXZH", + "datatype" : "varchar(256)" + }, { + "id" : "159", + "name" : "IS_ZF", + "datatype" : "varchar(256)" + }, { + "id" : "160", + "name" : "IS_WJT", + "datatype" : "varchar(256)" + }, { + "id" : "161", + "name" : "ONEIN1MON_NET_TYPE_REV", + "datatype" : "varchar(256)" + }, { + "id" : "162", + "name" : "LANQIU_FLOW", + "datatype" : "bigint" + }, { + "id" : "163", + "name" : "ZUQIU_FLOW", + "datatype" : "bigint" + }, { + "id" : "164", + "name" : "YUMAOQIU_FLOW", + "datatype" : "bigint" + }, { + "id" : "165", + "name" : "PINGPANG_FLOW", + "datatype" : "bigint" + }, { + "id" : "166", + "name" : "TAIQIU_FLOW", + "datatype" : "bigint" + }, { + "id" : "167", + "name" : "WANGQIU_FLOW", + "datatype" : "bigint" + }, { + "id" : "168", + "name" : "PAIQIU_FLOW", + "datatype" : "bigint" + }, { + "id" : "169", + "name" : "QUANJI_FLOW", + "datatype" : "bigint" + }, { + "id" : "170", + "name" : "GAOQIU_FLOW", + "datatype" : "bigint" + }, { + "id" : "171", + "name" : "SHUISHANG_FLOW", + "datatype" : "bigint" + }, { + "id" : "172", + "name" : "TICAO_FLOW", + "datatype" : "bigint" + }, { + "id" : "173", + "name" : "TIANJIN_FLOW", + "datatype" : "bigint" + }, { + "id" : "174", + "name" : "YUNDONG_FLOW", + "datatype" : "bigint" + }, { + "id" : "175", + "name" : "BINGXUE_FLOW", + "datatype" : "bigint" + }, { + "id" : "176", + "name" : "SAICHE_FLOW", + "datatype" : "bigint" + }, { + "id" : "177", + "name" : "JIXIAN_FLOW", + "datatype" : "bigint" + }, { + "id" : "178", + "name" : "QIPAI_FLOW", + "datatype" : "bigint" + }, { + "id" : "179", + "name" : "HUWAI_FLOW", + "datatype" : "bigint" + }, { + "id" : "180", + "name" : "SHEJI_FLOW", + "datatype" : "bigint" + }, { + "id" : "181", + "name" : "WUSHU_FLOW", + "datatype" : "bigint" + }, { + "id" : "182", + "name" : "DUIKANG_FLOW", + "datatype" : "bigint" + }, { + "id" : "183", + "name" : "SHIPIN_FLOW", + "datatype" : "bigint" + }, { + "id" : "184", + "name" : "YINPIN_FLOW", + "datatype" : "bigint" + }, { + "id" : "185", + "name" : "YILIAO_FLOW", + "datatype" : "bigint" + }, { + "id" : "186", + "name" : "LVYOU_FLOW", + "datatype" : "bigint" + }, { + "id" : "187", + "name" : "DACHE_FLOW", + "datatype" : "bigint" + }, { + "id" : "188", + "name" : "GOUWU_FLOW", + "datatype" : "bigint" + }, { + "id" : "189", + "name" : "WOMENHU_FLOW", + "datatype" : "bigint" + }, { + "id" : "190", + "name" : "WOZHIFU_FLOW", + "datatype" : "bigint" + }, { + "id" : "191", + "name" : "WODIANSHI_FLOW", + "datatype" : "bigint" + }, { + "id" : "192", + "name" : "WOSHANGDIAN_FLOW", + "datatype" : "bigint" + }, { + "id" : "193", + "name" : "WOYOUXIANG_FLOW", + "datatype" : "bigint" + }, { + "id" : "194", + "name" : "YINGYE_FLOW", + "datatype" : "bigint" + }, { + "id" : "195", + "name" : "WEIXIN", + "datatype" : "bigint" + }, { + "id" : "196", + "name" : "QQ", + "datatype" : "bigint" + }, { + "id" : "197", + "name" : "XINLANGWEIBO", + "datatype" : "bigint" + }, { + "id" : "198", + "name" : "SHOUJIYINGYETING", + "datatype" : "bigint" + }, { + "id" : "199", + "name" : "LAST3_TOTAL_FEE", + "datatype" : "bigint" + }, { + "id" : "200", + "name" : "LAST6_TOTAL_FEE", + "datatype" : "bigint" + }, { + "id" : "201", + "name" : "LAST3_TOTAL_DURA", + "datatype" : "bigint" + }, { + "id" : "202", + "name" : "LAST3_OUT_DURA", + "datatype" : "bigint" + }, { + "id" : "203", + "name" : "LAST3_ROAM_NUMS", + "datatype" : "bigint" + }, { + "id" : "204", + "name" : "LAST6_ROAM_DURA", + "datatype" : "bigint" + }, { + "id" : "205", + "name" : "LAST6_TOTAL_DURA", + "datatype" : "bigint" + }, { + "id" : "206", + "name" : "LAST6_OUT_DURA", + "datatype" : "bigint" + }, { + "id" : "207", + "name" : "LAST3_FLUX", + "datatype" : "bigint" + }, { + "id" : "208", + "name" : "LAST6_FLUX", + "datatype" : "bigint" + }, { + "id" : "209", + "name" : "CARD_TYPE", + "datatype" : "bigint" + }, { + "id" : "210", + "name" : "CHANNEL_ID", + "datatype" : "varchar(256)" + }, { + "id" : "211", + "name" : "CHANNEL_TYPE", + "datatype" : "varchar(256)" + }, { + "id" : "212", + "name" : "CHANNEL_NAME", + "datatype" : "varchar(256)" + }, { + "id" : "213", + "name" : "YEAR_MONTH", + "datatype" : "varchar(256)" + } ], + "source_type" : 0, + "table_type" : "MANAGED_TABLE", + "database" : "DEFAULT" +} \ No newline at end of file
