litewood created KYLIN-3827: ------------------------------- Summary: kylin 某一字段必须使用trim才可以查出来 Key: KYLIN-3827 URL: https://issues.apache.org/jira/browse/KYLIN-3827 Project: Kylin Issue Type: Bug Affects Versions: v2.5.1 Reporter: litewood
SELECT pt ,pageid from st.ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1 where pt = '20190114' and pageid='用户标签文档' GROUP BY pt,pageid; 当前sql 使用hive查询可以查出来结果。 但是使用kylin接口查询,除去一个近视去重选用全局字段的cube能查询出来,其他cube 必须trim(pageid) 或者使用like 关键字才能查出来。下面帖出三个cube信息。 {color:#FF0000}可以查出来的cube info (近视去重){color} { "uuid": "ad8cbc65-dd6c-8c12-7d18-2f625cedf7ea", "last_modified": 1550719049143, "version": "2.5.1.20500", "name": "c_pageview", "is_draft": false, "model_name": "m_bury_point_analysis", "description": "c_pageview", "null_string": null, "dimensions": [ \{ "name": "APPTYPE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "APPTYPE", "derived": null }, \{ "name": "PLATFORM", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "PLATFORM", "derived": null }, \{ "name": "UTM_SOURCE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "UTM_SOURCE", "derived": null }, \{ "name": "ADCODE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "ADCODE", "derived": null }, \{ "name": "ADDITIONTYPE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "ADDITIONTYPE", "derived": null }, \{ "name": "ADDITIONVALUE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "ADDITIONVALUE", "derived": null }, \{ "name": "APPVERSION", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "APPVERSION", "derived": null }, \{ "name": "CATEGORYID", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "CATEGORYID", "derived": null }, \{ "name": "CITYCODE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "CITYCODE", "derived": null }, \{ "name": "FLAGVALUE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "FLAGVALUE", "derived": null }, \{ "name": "PAGEID", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "PAGEID", "derived": null }, \{ "name": "H_DATE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "H_DATE", "derived": null }, \{ "name": "PT", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "PT", "derived": null }, \{ "name": "WEEKYTH_CNT_CN", "table": "DIM_PUB_DATE", "column": null, "derived": [ "WEEKYTH_CNT_CN" ] }, \{ "name": "WEEKYTH_START_DATA_CN", "table": "DIM_PUB_DATE", "column": null, "derived": [ "WEEKYTH_START_DATA_CN" ] }, \{ "name": "WEEKYTH_END_DATA_CN", "table": "DIM_PUB_DATE", "column": null, "derived": [ "WEEKYTH_END_DATA_CN" ] } ], "measures": [ \{ "name": "PV", "function": { "expression": "COUNT", "parameter": { "type": "constant", "value": "1" }, "returntype": "bigint" } }, \{ "name": "UV", "function": { "expression": "COUNT_DISTINCT", "parameter": { "type": "column", "value": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.USERGUID" }, "returntype": "hllc(16)" } }, \{ "name": "DUV", "function": { "expression": "COUNT_DISTINCT", "parameter": { "type": "column", "value": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.SSID" }, "returntype": "hllc(16)" } } ], "dictionaries": [], "rowkey": \{ "rowkey_columns": [ { "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.H_DATE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PAGEID", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PLATFORM", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CATEGORYID", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPVERSION", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPTYPE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONTYPE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONVALUE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CITYCODE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADCODE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.FLAGVALUE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.UTM_SOURCE", "encoding": "dict", "encoding_version": 1, "isShardBy": false } ] }, "hbase_mapping": \{ "column_family": [ { "name": "F1", "columns": [ { "qualifier": "M", "measure_refs": [ "PV" ] } ] }, \{ "name": "F2", "columns": [ { "qualifier": "M", "measure_refs": [ "UV", "DUV" ] } ] } ] }, "aggregation_groups": [ \{ "includes": [ "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPTYPE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PLATFORM", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.UTM_SOURCE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADCODE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONTYPE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONVALUE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPVERSION", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CATEGORYID", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CITYCODE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.FLAGVALUE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PAGEID", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.H_DATE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT" ], "select_rule": { "hierarchy_dims": [], "mandatory_dims": [ "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT" ], "joint_dims": [] } } ], "signature": "DioSDlLhFMNSh4LZxsOSjg==", "notify_list": [], "status_need_notify": [ "ERROR", "DISCARDED", "SUCCEED" ], "partition_date_start": 1547424000000, "partition_date_end": 3153600000000, "auto_merge_time_ranges": [ 604800000, 2419200000 ], "volatile_range": 0, "retention_range": 0, "engine_type": 2, "storage_type": 2, "override_kylin_properties": {}, "cuboid_black_list": [], "parent_forward": 3, "mandatory_dimension_set_list": [], "snapshot_table_desc_list": [] } {color:#FF0000}不可以查看来的cube info (近视去重) {color}-- { "uuid": "99e7f383-3f12-7d40-2df2-8b774cdf6c7c", "last_modified": 1548387563546, "version": "2.5.1.20500", "name": "c_day_hour", "is_draft": false, "model_name": "m_bury_point_analysis", "description": "c_day_hour", "null_string": null, "dimensions": [ \{ "name": "APPTYPE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "APPTYPE", "derived": null }, \{ "name": "PLATFORM", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "PLATFORM", "derived": null }, \{ "name": "UTM_SOURCE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "UTM_SOURCE", "derived": null }, \{ "name": "ADCODE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "ADCODE", "derived": null }, \{ "name": "ADDITIONTYPE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "ADDITIONTYPE", "derived": null }, \{ "name": "ADDITIONVALUE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "ADDITIONVALUE", "derived": null }, \{ "name": "APPVERSION", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "APPVERSION", "derived": null }, \{ "name": "CATEGORYID", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "CATEGORYID", "derived": null }, \{ "name": "CITYCODE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "CITYCODE", "derived": null }, \{ "name": "FLAGVALUE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "FLAGVALUE", "derived": null }, \{ "name": "PAGEID", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "PAGEID", "derived": null }, \{ "name": "H_DATE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "H_DATE", "derived": null }, \{ "name": "PT", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "PT", "derived": null } ], "measures": [ \{ "name": "PV", "function": { "expression": "COUNT", "parameter": { "type": "constant", "value": "1" }, "returntype": "bigint" } }, \{ "name": "UV", "function": { "expression": "COUNT_DISTINCT", "parameter": { "type": "column", "value": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.USERGUID" }, "returntype": "hllc(10)" } }, \{ "name": "DUV", "function": { "expression": "COUNT_DISTINCT", "parameter": { "type": "column", "value": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.SSID" }, "returntype": "hllc(16)" } } ], "dictionaries": [], "rowkey": \{ "rowkey_columns": [ { "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.H_DATE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PAGEID", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PLATFORM", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CATEGORYID", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPVERSION", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPTYPE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONTYPE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONVALUE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CITYCODE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADCODE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.FLAGVALUE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.UTM_SOURCE", "encoding": "fixed_length:16", "encoding_version": 1, "isShardBy": false } ] }, "hbase_mapping": \{ "column_family": [ { "name": "F1", "columns": [ { "qualifier": "M", "measure_refs": [ "PV" ] } ] }, \{ "name": "F2", "columns": [ { "qualifier": "M", "measure_refs": [ "UV", "DUV" ] } ] } ] }, "aggregation_groups": [ \{ "includes": [ "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPTYPE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PLATFORM", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.UTM_SOURCE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADCODE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONTYPE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONVALUE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPVERSION", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CATEGORYID", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CITYCODE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.FLAGVALUE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PAGEID", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.H_DATE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT" ], "select_rule": { "hierarchy_dims": [ [ "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.H_DATE" ] ], "mandatory_dims": [], "joint_dims": [] } } ], "signature": "E8DYtXCTE5qjsjeM8c2/0g==", "notify_list": [ "weiyaxiong05...@hellobike.com" ], "status_need_notify": [ "ERROR", "DISCARDED", "SUCCEED" ], "partition_date_start": 1546992000000, "partition_date_end": 3153600000000, "auto_merge_time_ranges": [], "volatile_range": 0, "retention_range": 15552000000, "engine_type": 2, "storage_type": 2, "override_kylin_properties": \{ "kylin.source.hive.config-override.mapred.job.priority": "VERY_HIGH", "kylin.source.hive.config-override.hive.exec.parallel": "true", "kylin.source.hive.config-override.hive.merge.mapredfiles": "TRUE", "kylin.source.hive.config-override.hive.merge.smallfiles.avgsize": "100000000", "kylin.source.hive.config-override.hive.merge.size.per.task": "128000000", "kylin.source.hive.config-override.mapred.max.split.size": "256000000", "kylin.source.hive.config-override.hive.exec.parallel.thread.number": "32" }, "cuboid_black_list": [], "parent_forward": 3, "mandatory_dimension_set_list": [], "snapshot_table_desc_list": [] } -- {color:#FF0000}不可以查看来的cube info (精确去重){color} { "uuid": "ad8cbc65-dd6c-8c12-7d18-2f625cedf7ea", "last_modified": 1550719049143, "version": "2.5.1.20500", "name": "c_pageview", "is_draft": false, "model_name": "m_bury_point_analysis", "description": "c_pageview", "null_string": null, "dimensions": [ \{ "name": "APPTYPE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "APPTYPE", "derived": null }, \{ "name": "PLATFORM", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "PLATFORM", "derived": null }, \{ "name": "UTM_SOURCE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "UTM_SOURCE", "derived": null }, \{ "name": "ADCODE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "ADCODE", "derived": null }, \{ "name": "ADDITIONTYPE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "ADDITIONTYPE", "derived": null }, \{ "name": "ADDITIONVALUE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "ADDITIONVALUE", "derived": null }, \{ "name": "APPVERSION", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "APPVERSION", "derived": null }, \{ "name": "CATEGORYID", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "CATEGORYID", "derived": null }, \{ "name": "CITYCODE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "CITYCODE", "derived": null }, \{ "name": "FLAGVALUE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "FLAGVALUE", "derived": null }, \{ "name": "PAGEID", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "PAGEID", "derived": null }, \{ "name": "H_DATE", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "H_DATE", "derived": null }, \{ "name": "PT", "table": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1", "column": "PT", "derived": null }, \{ "name": "WEEKYTH_CNT_CN", "table": "DIM_PUB_DATE", "column": null, "derived": [ "WEEKYTH_CNT_CN" ] }, \{ "name": "WEEKYTH_START_DATA_CN", "table": "DIM_PUB_DATE", "column": null, "derived": [ "WEEKYTH_START_DATA_CN" ] }, \{ "name": "WEEKYTH_END_DATA_CN", "table": "DIM_PUB_DATE", "column": null, "derived": [ "WEEKYTH_END_DATA_CN" ] } ], "measures": [ \{ "name": "PV", "function": { "expression": "COUNT", "parameter": { "type": "constant", "value": "1" }, "returntype": "bigint" } }, \{ "name": "UV", "function": { "expression": "COUNT_DISTINCT", "parameter": { "type": "column", "value": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.USERGUID" }, "returntype": "hllc(16)" } }, \{ "name": "DUV", "function": { "expression": "COUNT_DISTINCT", "parameter": { "type": "column", "value": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.SSID" }, "returntype": "hllc(16)" } } ], "dictionaries": [], "rowkey": \{ "rowkey_columns": [ { "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.H_DATE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PAGEID", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PLATFORM", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CATEGORYID", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPVERSION", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPTYPE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONTYPE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONVALUE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CITYCODE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADCODE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.FLAGVALUE", "encoding": "dict", "encoding_version": 1, "isShardBy": false }, \{ "column": "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.UTM_SOURCE", "encoding": "dict", "encoding_version": 1, "isShardBy": false } ] }, "hbase_mapping": \{ "column_family": [ { "name": "F1", "columns": [ { "qualifier": "M", "measure_refs": [ "PV" ] } ] }, \{ "name": "F2", "columns": [ { "qualifier": "M", "measure_refs": [ "UV", "DUV" ] } ] } ] }, "aggregation_groups": [ \{ "includes": [ "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPTYPE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PLATFORM", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.UTM_SOURCE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADCODE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONTYPE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.ADDITIONVALUE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.APPVERSION", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CATEGORYID", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.CITYCODE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.FLAGVALUE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PAGEID", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.H_DATE", "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT" ], "select_rule": { "hierarchy_dims": [], "mandatory_dims": [ "ST_T_BIKE_YUKON_PRO_PAGEVIEW_CLEAN1.PT" ], "joint_dims": [] } } ], "signature": "DioSDlLhFMNSh4LZxsOSjg==", "notify_list": [], "status_need_notify": [ "ERROR", "DISCARDED", "SUCCEED" ], "partition_date_start": 1547424000000, "partition_date_end": 3153600000000, "auto_merge_time_ranges": [ 604800000, 2419200000 ], "volatile_range": 0, "retention_range": 0, "engine_type": 2, "storage_type": 2, "override_kylin_properties": {}, "cuboid_black_list": [], "parent_forward": 3, "mandatory_dimension_set_list": [], "snapshot_table_desc_list": [] } -- This message was sent by Atlassian JIRA (v7.6.3#76005)