I've changed the "CARD_ID" dimension encoding as fixed lenght , it seems like work well.
2019-06-13 lk_hadoop 发件人:ShaoFeng Shi <shaofeng...@apache.org> 发送时间:2019-06-12 18:10 主题:Re: AppendTrieDictionary can't retrieve value from id 收件人:"user"<u...@kylin.apache.org> 抄送:"dev"<dev@kylin.apache.org> 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: shaofeng...@apache.org Apache Kylin FAQ: https://kylin.apache.org/docs/gettingstarted/faq.html Join Kylin user mail group: user-subscr...@kylin.apache.org Join Kylin dev mail group: dev-subscr...@kylin.apache.org lk_hadoop <lk_had...@163.com> 于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