Hello, In your cube, "CARD_ID" is used as both dimension and a bitmap (count distinct) measure; This is not allowed currently, because to encode it to an integer, Kylin uses the "global dictionary", while the "global dictionary" couldn't be used for dimension encoding.
Please remove it from the dimension in this cube, and build again. And if you need it as a dimension, create another cube. Best regards, Shaofeng Shi 史少锋 Apache Kylin PMC Email: [email protected] Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: [email protected] Join Kylin dev mail group: [email protected] lk_hadoop <[email protected]> 于2019年6月11日周二 下午4:12写道： > hi,all: > My Model Json string is : > > > { > "uuid": "c28014c1-7dae-6900-6264-8794b683ffa7", > "last_modified": 1560226964070, > "version": "2.6.1.0", > "name": "scrm_model", > "owner": "ADMIN", > "is_draft": false, > "description": "###", > "fact_table": "GJST.SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "lookups": [ > { > "table": "TEST.MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "kind": "FACT", > "alias": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "join": { > "type": "inner", > "primary_key": [ > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.CARD_ID" > ], > "foreign_key": [ > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.CARD_ID" > ] > } > } > ], > "dimensions": [ > { > "table": "SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "columns": [ > "DATES", > "CARD_ID", > "TGOODS_ID", > "ENT_NAME", > "ORG_NAME", > "DATA_FROM", > "GOODS_NAME", > "ORG_NO", > "ATC1_NEW", > "ATC2_NEW", > "ATC3_NEW", > "ATC4_NEW", > "GOODS_ID" > ] > }, > { > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "columns": [ > "CARD_ID", > "USER_ID", > "SEX", > "AGE", > "BIRTHDAYS", > "NAME", > "NICK_NAME", > "IS_SUBSCRIBE_WX", > "IS_RECEIVE_CARD", > "SUBSCRIBE_TIME", > "SUBSCRIBE_STORE", > "ACTIVATE_TIME", > "ACTIVATE_STORE", > "FIRST_BUY_DATE", > "RECENT_CONSUME_DATE", > "RECENT_CONSUMPTION_INTERVAL_DAY", > "GAOXUEYA_BUYS", > "GAOXUEYA_FLAG", > "GAOXUEZHI_BUYS", > "GAOXUEZHI_FLAG", > "TANGNIAOBING_BUYS", > "TANGNIAOBING_FLAG", > "TOTAL_POINTS", > "REMAINDER_POINTS", > "TOTAL_COUPONS_NUMBER", > "AVAILABLE_COUPONS_NUMBER", > "TOTAL_USE_COUPONS_NUMBER", > "MAINTAIN_NUMBERS", > "MAINTAIN_TYPE", > "MARKET_PROGRAM", > "RECENT_MAINTAIN_INTERVAL_DAY", > "BELONG_STORE", > "BUSINESS_ID" > ] > } > ], > "metrics": [ > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.PAID_IN_AMT", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.TBILL_CODE", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.PROFIT" > ], > "filter_condition": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.data_from_new <>'' and > SH_FETCH_SALE_BASE_FACT_ALL_NEW.card_id is not null", > "partition_desc": { > "partition_date_column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.CDT", > "partition_time_column": null, > "partition_date_start": 0, > "partition_date_format": "yyyy-MM-dd", > "partition_time_format": "HH:mm:ss", > "partition_type": "APPEND", > "partition_condition_builder": > "org.apache.kylin.metadata.model.PartitionDesc$DefaultPartitionConditionBuilder" > }, > "capacity": "MEDIUM" > } > > > and cube json string is : > > > { > "uuid": "a1af090c-7c83-7748-2474-d47368321aff", > "last_modified": 1560227365049, > "version": "2.6.1.0", > "name": "scrm_cube", > "is_draft": false, > "model_name": "scrm_model", > "description": "", > "null_string": null, > "dimensions": [ > { > "name": "DATES", > "table": "SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "column": "DATES", > "derived": null > }, > { > "name": "GOODS_ID", > "table": "SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "column": "GOODS_ID", > "derived": null > }, > { > "name": "CARD_ID", > "table": "SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "column": "CARD_ID", > "derived": null > }, > { > "name": "ATC1_NEW", > "table": "SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "column": "ATC1_NEW", > "derived": null > }, > { > "name": "ATC2_NEW", > "table": "SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "column": "ATC2_NEW", > "derived": null > }, > { > "name": "ATC3_NEW", > "table": "SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "column": "ATC3_NEW", > "derived": null > }, > { > "name": "ATC4_NEW", > "table": "SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "column": "ATC4_NEW", > "derived": null > }, > { > "name": "GOODS_NAME", > "table": "SH_FETCH_SALE_BASE_FACT_ALL_NEW", > "column": "GOODS_NAME", > "derived": null > }, > { > "name": "SEX", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "SEX", > "derived": null > }, > { > "name": "AGE", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "AGE", > "derived": null > }, > { > "name": "BIRTHDAYS", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "BIRTHDAYS", > "derived": null > }, > { > "name": "IS_SUBSCRIBE_WX", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "IS_SUBSCRIBE_WX", > "derived": null > }, > { > "name": "SUBSCRIBE_TIME", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "SUBSCRIBE_TIME", > "derived": null > }, > { > "name": "SUBSCRIBE_STORE", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "SUBSCRIBE_STORE", > "derived": null > }, > { > "name": "ACTIVATE_TIME", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "ACTIVATE_TIME", > "derived": null > }, > { > "name": "ACTIVATE_STORE", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "ACTIVATE_STORE", > "derived": null > }, > { > "name": "FIRST_BUY_DATE", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "FIRST_BUY_DATE", > "derived": null > }, > { > "name": "RECENT_CONSUME_DATE", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "RECENT_CONSUME_DATE", > "derived": null > }, > { > "name": "RECENT_CONSUMPTION_INTERVAL_DAY", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "RECENT_CONSUMPTION_INTERVAL_DAY", > "derived": null > }, > { > "name": "TOTAL_POINTS", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "TOTAL_POINTS", > "derived": null > }, > { > "name": "REMAINDER_POINTS", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "REMAINDER_POINTS", > "derived": null > }, > { > "name": "TOTAL_COUPONS_NUMBER", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "TOTAL_COUPONS_NUMBER", > "derived": null > }, > { > "name": "AVAILABLE_COUPONS_NUMBER", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "AVAILABLE_COUPONS_NUMBER", > "derived": null > }, > { > "name": "TOTAL_USE_COUPONS_NUMBER", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "TOTAL_USE_COUPONS_NUMBER", > "derived": null > }, > { > "name": "MAINTAIN_NUMBERS", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "MAINTAIN_NUMBERS", > "derived": null > }, > { > "name": "MAINTAIN_TYPE", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "MAINTAIN_TYPE", > "derived": null > }, > { > "name": "MARKET_PROGRAM", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "MARKET_PROGRAM", > "derived": null > }, > { > "name": "RECENT_MAINTAIN_INTERVAL_DAY", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "RECENT_MAINTAIN_INTERVAL_DAY", > "derived": null > }, > { > "name": "BELONG_STORE", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "BELONG_STORE", > "derived": null > }, > { > "name": "BUSINESS_ID", > "table": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4", > "column": "BUSINESS_ID", > "derived": null > } > ], > "measures": [ > { > "name": "_COUNT_", > "function": { > "expression": "COUNT", > "parameter": { > "type": "constant", > "value": "1" > }, > "returntype": "bigint" > } > }, > { > "name": "PAID_IN_AMT_SUM", > "function": { > "expression": "SUM", > "parameter": { > "type": "column", > "value": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.PAID_IN_AMT" > }, > "returntype": "decimal(19,6)" > } > }, > { > "name": "PROFIT_SUM", > "function": { > "expression": "SUM", > "parameter": { > "type": "column", > "value": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.PROFIT" > }, > "returntype": "decimal(19,6)" > } > }, > { > "name": "COUNT_CNT", > "function": { > "expression": "COUNT_DISTINCT", > "parameter": { > "type": "column", > "value": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.TBILL_CODE" > }, > "returntype": "bitmap" > } > }, > { > "name": "COUNT_CARD_ID", > "function": { > "expression": "COUNT_DISTINCT", > "parameter": { > "type": "column", > "value": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.CARD_ID" > }, > "returntype": "bitmap" > } > } > ], > "dictionaries": [ > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.TBILL_CODE", > "builder": "org.apache.kylin.dict.global.SegmentAppendTrieDictBuilder" > }, > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.CARD_ID", > "builder": "org.apache.kylin.dict.global.SegmentAppendTrieDictBuilder" > } > ], > "rowkey": { > "rowkey_columns": [ > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BUSINESS_ID", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.AGE", > "encoding": "integer:3", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BIRTHDAYS", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SEX", > "encoding": "integer:1", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SUBSCRIBE_TIME", > "encoding": "fixed_length:10", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.ACTIVATE_TIME", > "encoding": "fixed_length:10", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BELONG_STORE", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.IS_SUBSCRIBE_WX", > "encoding": "integer:1", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SUBSCRIBE_STORE", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.ACTIVATE_STORE", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.DATES", > "encoding": "fixed_length:10", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC1_NEW", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC2_NEW", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC3_NEW", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC4_NEW", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.GOODS_ID", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.FIRST_BUY_DATE", > "encoding": "fixed_length:10", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.RECENT_CONSUME_DATE", > "encoding": "fixed_length:10", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.RECENT_CONSUMPTION_INTERVAL_DAY", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.TOTAL_POINTS", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.REMAINDER_POINTS", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.TOTAL_COUPONS_NUMBER", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.AVAILABLE_COUPONS_NUMBER", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.TOTAL_USE_COUPONS_NUMBER", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.MAINTAIN_NUMBERS", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.MAINTAIN_TYPE", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.MARKET_PROGRAM", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.RECENT_MAINTAIN_INTERVAL_DAY", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.GOODS_NAME", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": false > }, > { > "column": "SH_FETCH_SALE_BASE_FACT_ALL_NEW.CARD_ID", > "encoding": "dict", > "encoding_version": 1, > "isShardBy": true > } > ] > }, > "hbase_mapping": { > "column_family": [ > { > "name": "F1", > "columns": [ > { > "qualifier": "M", > "measure_refs": [ > "_COUNT_", > "PAID_IN_AMT_SUM", > "PROFIT_SUM" > ] > } > ] > }, > { > "name": "F2", > "columns": [ > { > "qualifier": "M", > "measure_refs": [ > "COUNT_CNT", > "COUNT_CARD_ID" > ] > } > ] > } > ] > }, > "aggregation_groups": [ > { > "includes": [ > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.DATES", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC1_NEW", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC2_NEW", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC3_NEW", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC4_NEW", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.GOODS_NAME", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BUSINESS_ID", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.CARD_ID", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.GOODS_ID" > ], > "select_rule": { > "hierarchy_dims": [ > [ > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC1_NEW", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC2_NEW", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC3_NEW", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.ATC4_NEW" > ] > ], > "mandatory_dims": [ > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.DATES", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BUSINESS_ID", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.CARD_ID" > ], > "joint_dims": [ > [ > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.GOODS_NAME", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.GOODS_ID" > ] > ] > } > }, > { > "includes": [ > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SEX", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BIRTHDAYS", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.AGE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.IS_SUBSCRIBE_WX", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SUBSCRIBE_TIME", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SUBSCRIBE_STORE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.ACTIVATE_TIME", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.ACTIVATE_STORE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.FIRST_BUY_DATE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.RECENT_CONSUME_DATE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.TOTAL_POINTS", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.REMAINDER_POINTS", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.TOTAL_COUPONS_NUMBER", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.AVAILABLE_COUPONS_NUMBER", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.TOTAL_USE_COUPONS_NUMBER", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BELONG_STORE" > ], > "select_rule": { > "hierarchy_dims": [], > "mandatory_dims": [ > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SEX", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BIRTHDAYS", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BELONG_STORE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SUBSCRIBE_STORE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.ACTIVATE_STORE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SUBSCRIBE_TIME", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.ACTIVATE_TIME" > ], > "joint_dims": [] > } > }, > { > "includes": [ > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.MAINTAIN_NUMBERS", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.MAINTAIN_TYPE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.MARKET_PROGRAM", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.RECENT_MAINTAIN_INTERVAL_DAY" > ], > "select_rule": { > "hierarchy_dims": [], > "mandatory_dims": [ > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.MAINTAIN_NUMBERS", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.MAINTAIN_TYPE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.MARKET_PROGRAM" > ], > "joint_dims": [] > } > }, > { > "includes": [ > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BUSINESS_ID", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.AGE", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BIRTHDAYS", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.SUBSCRIBE_TIME", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.ACTIVATE_TIME", > "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.BELONG_STORE", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW.DATES" > ], > "select_rule": { > "hierarchy_dims": [], > "mandatory_dims": [], > "joint_dims": [] > } > } > ], > "signature": "9RiiZox1E53acPvXs4ZSKA==", > "notify_list": [], > "status_need_notify": [ > "ERROR", > "DISCARDED", > "SUCCEED" > ], > "partition_date_start": 0, > "partition_date_end": 3153600000000, > "auto_merge_time_ranges": [], > "volatile_range": 0, > "retention_range": 86400000, > "engine_type": 2, > "storage_type": 2, > "override_kylin_properties": { > "kylin.engine.mr.mapper-input-rows": "10000000", > "kylin.engine.mr.reduce-input-mb": "2048", > "kylin.engine.mr.uhc-reducer-count": "4", > > "kylin.engine.mr.config-override.mapreduce.input.fileinputformat.split.minsize": > "536870912", > "kylin.storage.hbase.region-cut-gb": "10", > "kylin.storage.hbase.hfile-size-gb": "5" > }, > "cuboid_black_list": [], > "parent_forward": 3, > "mandatory_dimension_set_list": [], > "snapshot_table_desc_list": [] > } > > query is : > > SELECT "SH_FETCH_SALE_BASE_FACT_ALL_NEW"."DATES", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW"."CARD_ID" > ,SUM("SH_FETCH_SALE_BASE_FACT_ALL_NEW"."PAID_IN_AMT") AS sum_PAID_IN_AMT > FROM "GJST"."SH_FETCH_SALE_BASE_FACT_ALL_NEW" > "SH_FETCH_SALE_BASE_FACT_ALL_NEW" > INNER JOIN "TEST"."MEMBERSHIP_PRECISE_SELLING_EXTEND_V4" > MEMBERSHIP_PRECISE_SELLING_EXTEND_V4 ON > MEMBERSHIP_PRECISE_SELLING_EXTEND_V4.CARD_ID = > SH_FETCH_SALE_BASE_FACT_ALL_NEW.CARD_ID > WHERE "MEMBERSHIP_PRECISE_SELLING_EXTEND_V4"."BUSINESS_ID" IN ('12501') > AND ("SH_FETCH_SALE_BASE_FACT_ALL_NEW"."DATES">='2019-06-01' AND > "SH_FETCH_SALE_BASE_FACT_ALL_NEW"."DATES"<='2019-06-09') > GROUP BY "SH_FETCH_SALE_BASE_FACT_ALL_NEW"."DATES", > "SH_FETCH_SALE_BASE_FACT_ALL_NEW"."CARD_ID" > > when I group by CARD_ID I will get error : AppendTrieDictionary can't > retrieve value from id > > what should I do ? > > 2019-06-11 > ------------------------------ > lk_hadoop >
