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/11/16 05:33:35 UTC
kylin git commit: add test case testCuboid_onlyBaseCuboid()
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 <li...@apache.org>
Authored: Wed Nov 16 13:33:08 2016 +0800
Committer: Li Yang <li...@apache.org>
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" : "\u51fa\u8d26\u8d39\u7528",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "ACCT_FEE",
+ "next_parameter" : null
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "name" : "\u6708\u79df\u8d39",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "RENT_FEE",
+ "next_parameter" : null
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "name" : "\u529f\u80fd\u8d39",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "FUNC_FEE",
+ "next_parameter" : null
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "name" : "\u5176\u4ed6\u56fa\u5b9a\u8d39",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "OT_FIX_FEE",
+ "next_parameter" : null
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "name" : "\u672c\u5730\u901a\u8bdd\u8d39",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "LOCAL_VOICE_FEE",
+ "next_parameter" : null
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "name" : "\u957f\u9014\u901a\u8bdd\u8d39",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "LONG_VOICE_FEE",
+ "next_parameter" : null
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "name" : "\u6f2b\u6e38\u901a\u8bdd\u8d39",
+ "function" : {
+ "expression" : "SUM",
+ "parameter" : {
+ "type" : "column",
+ "value" : "ROAM_VOICE_FEE",
+ "next_parameter" : null
+ },
+ "returntype" : "bigint"
+ },
+ "dependent_measure_ref" : null
+ }, {
+ "name" : "\u5176\u4ed6\u8bed\u97f3\u901a\u8bdd\u8d39",
+ "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_", "\u51fa\u8d26\u8d39\u7528", "\u6708\u79df\u8d39", "\u529f\u80fd\u8d39", "\u5176\u4ed6\u56fa\u5b9a\u8d39", "\u672c\u5730\u901a\u8bdd\u8d39", "\u957f\u9014\u901a\u8bdd\u8d39", "\u6f2b\u6e38\u901a\u8bdd\u8d39", "\u5176\u4ed6\u8bed\u97f3\u901a\u8bdd\u8d39" ]
+ } ]
+ } ]
+ },
+ "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