You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@kylin.apache.org by "Shaofeng SHI (JIRA)" <ji...@apache.org> on 2019/03/18 03:42:00 UTC
[jira] [Resolved] (KYLIN-3827) kylin 某一字段必须使用trim才可以查出来
[ https://issues.apache.org/jira/browse/KYLIN-3827?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Shaofeng SHI resolved KYLIN-3827.
---------------------------------
Resolution: Resolved
> 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
> Priority: Major
> Attachments: image-2019-03-04-14-51-50-736.png, image-2019-03-04-14-52-35-683.png
>
>
> 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": [
> "weiyaxiong05443@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)