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
