Hi,
Kylin2.1 HDP2.5.3
After i create mode and cube ,cube build complete ,but query is errror:
select * from loan_group left join dim_appr_crext
on loan_group.appr_crext_rent = dim_appr_crext.appr_crext_rent
Error while executing SQL "select * from loan_group left join dim_appr_crext on
loan_group.appr_crext_rent = dim_appr_crext.appr_crext_rent LIMIT 50000": No
model found forrel#200300:OLAPTableScan.OLAP.[](table=[METRIC,
LOAN_GROUP],fields=[0, 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16,
17, 18, 19, 20, 21, 22])
Model json:
{
"uuid": "20cdd042-15c6-4a8f-8a80-2da41755da28",
"last_modified": 1508914014333,
"version": "2.1.0",
"name": "cube_loan",
"is_draft": false,
"model_name": "model_loan",
"description": "edit at 20171025",
"null_string": null,
"dimensions": [
{
"name": "DATE_CD",
"table": "LOAN_GROUP",
"column": "DATE_CD",
"derived": null
},
{
"name": "ORG_CD",
"table": "LOAN_GROUP",
"column": "ORG_CD",
"derived": null
},
{
"name": "CURR_CD",
"table": "LOAN_GROUP",
"column": "CURR_CD",
"derived": null
},
{
"name": "GL_ACC_CD",
"table": "LOAN_GROUP",
"column": "GL_ACC_CD",
"derived": null
},
{
"name": "ENT_SCA_CD",
"table": "LOAN_GROUP",
"column": "ENT_SCA_CD",
"derived": null
},
{
"name": "INDU_CD",
"table": "LOAN_GROUP",
"column": "INDU_CD",
"derived": null
},
{
"name": "ENT_PSN_CD",
"table": "LOAN_GROUP",
"column": "ENT_PSN_CD",
"derived": null
},
{
"name": "PER_LON_CD",
"table": "LOAN_GROUP",
"column": "PER_LON_CD",
"derived": null
},
{
"name": "APPR_CREXT_RENT",
"table": "LOAN_GROUP",
"column": "APPR_CREXT_RENT",
"derived": null
},
{
"name": "PRD_NO",
"table": "LOAN_GROUP",
"column": "PRD_NO",
"derived": null
},
{
"name": "CUST_LON_TYPE",
"table": "LOAN_GROUP",
"column": "CUST_LON_TYPE",
"derived": null
},
{
"name": "PRD_PINGZ",
"table": "LOAN_GROUP",
"column": "PRD_PINGZ",
"derived": null
},
{
"name": "CLASS_FIVE_CD",
"table": "LOAN_GROUP",
"column": "CLASS_FIVE_CD",
"derived": null
},
{
"name": "MAIN_GUAR_CD",
"table": "LOAN_GROUP",
"column": "MAIN_GUAR_CD",
"derived": null
},
{
"name": "REG_ADMI_AREA",
"table": "LOAN_GROUP",
"column": "REG_ADMI_AREA",
"derived": null
},
{
"name": "FORE_LON_TYPE",
"table": "LOAN_GROUP",
"column": "FORE_LON_TYPE",
"derived": null
},
{
"name": "BC_FLAG",
"table": "LOAN_GROUP",
"column": "BC_FLAG",
"derived": null
},
{
"name": "STRA_INDU_NAME",
"table": "LOAN_GROUP",
"column": "STRA_INDU_NAME",
"derived": null
},
{
"name": "INDU_TRF_UPD_PRO",
"table": "LOAN_GROUP",
"column": "INDU_TRF_UPD_PRO",
"derived": null
},
{
"name": "ATRE_TYPE_NAME",
"table": "LOAN_GROUP",
"column": "ATRE_TYPE_NAME",
"derived": null
},
{
"name": "ESTATE_TYPE",
"table": "LOAN_GROUP",
"column": "ESTATE_TYPE",
"derived": null
},
{
"name": "DATE_CD",
"table": "DIM_DATE",
"column": "DATE_CD",
"derived": null
},
{
"name": "LAST_D",
"table": "DIM_DATE",
"column": null,
"derived": [
"LAST_D"
]
},
{
"name": "LAST_M",
"table": "DIM_DATE",
"column": null,
"derived": [
"LAST_M"
]
},
{
"name": "LAST_Q",
"table": "DIM_DATE",
"column": null,
"derived": [
"LAST_Q"
]
},
{
"name": "LAST_Y",
"table": "DIM_DATE",
"column": null,
"derived": [
"LAST_Y"
]
},
{
"name": "M_END",
"table": "DIM_DATE",
"column": null,
"derived": [
"M_END"
]
},
{
"name": "Q_END",
"table": "DIM_DATE",
"column": null,
"derived": [
"Q_END"
]
},
{
"name": "Y_END",
"table": "DIM_DATE",
"column": null,
"derived": [
"Y_END"
]
},
{
"name": "ORG_CD",
"table": "DIM_ORG",
"column": "ORG_CD",
"derived": null
},
{
"name": "ORG_NAME",
"table": "DIM_ORG",
"column": null,
"derived": [
"ORG_NAME"
]
},
{
"name": "CURR_CD",
"table": "DIM_CURR",
"column": "CURR_CD",
"derived": null
},
{
"name": "CURR_NAME",
"table": "DIM_CURR",
"column": null,
"derived": [
"CURR_NAME"
]
},
{
"name": "ENT_SCA_CD",
"table": "DIM_ENT_SCA",
"column": "ENT_SCA_CD",
"derived": null
},
{
"name": "ENT_SCA_NAME",
"table": "DIM_ENT_SCA",
"column": null,
"derived": [
"ENT_SCA_NAME"
]
},
{
"name": "INDU_CD",
"table": "DIM_INDU",
"column": "INDU_CD",
"derived": null
},
{
"name": "INDU_NAME",
"table": "DIM_INDU",
"column": null,
"derived": [
"INDU_NAME"
]
},
{
"name": "INDU_LV",
"table": "DIM_INDU",
"column": null,
"derived": [
"INDU_LV"
]
},
{
"name": "INDU_CD_LV1",
"table": "DIM_INDU",
"column": null,
"derived": [
"INDU_CD_LV1"
]
},
{
"name": "INDU_NAME_LV1",
"table": "DIM_INDU",
"column": null,
"derived": [
"INDU_NAME_LV1"
]
},
{
"name": "ENT_PSN_CD",
"table": "DIM_ENT_PSN",
"column": "ENT_PSN_CD",
"derived": null
},
{
"name": "ENT_PSN_NAME",
"table": "DIM_ENT_PSN",
"column": null,
"derived": [
"ENT_PSN_NAME"
]
},
{
"name": "PER_LOAN_CD",
"table": "DIM_PER_LOAN",
"column": "PER_LOAN_CD",
"derived": null
},
{
"name": "PER_LOAN_NAME",
"table": "DIM_PER_LOAN",
"column": null,
"derived": [
"PER_LOAN_NAME"
]
},
{
"name": "PER_LOAN_LV",
"table": "DIM_PER_LOAN",
"column": null,
"derived": [
"PER_LOAN_LV"
]
},
{
"name": "PER_LOAN_CD_LV1",
"table": "DIM_PER_LOAN",
"column": null,
"derived": [
"PER_LOAN_CD_LV1"
]
},
{
"name": "PER_LOAN_NAME_LV1",
"table": "DIM_PER_LOAN",
"column": null,
"derived": [
"PER_LOAN_NAME_LV1"
]
},
{
"name": "APPR_CREXT_RENT",
"table": "DIM_APPR_CREXT",
"column": "APPR_CREXT_RENT",
"derived": null
},
{
"name": "APPR_CREXT_RENT_DES",
"table": "DIM_APPR_CREXT",
"column": null,
"derived": [
"APPR_CREXT_RENT_DES"
]
},
{
"name": "CUST_LON_TYPE",
"table": "DIM_CUST_LON",
"column": "CUST_LON_TYPE",
"derived": null
},
{
"name": "CUST_LON_NAME",
"table": "DIM_CUST_LON",
"column": null,
"derived": [
"CUST_LON_NAME"
]
},
{
"name": "CLASS_FIVE_CD",
"table": "DIM_CLASS_FIVE",
"column": "CLASS_FIVE_CD",
"derived": null
},
{
"name": "CLASS_FIVE_NAME",
"table": "DIM_CLASS_FIVE",
"column": null,
"derived": [
"CLASS_FIVE_NAME"
]
},
{
"name": "CLASS_FIVE_TYPE",
"table": "DIM_CLASS_FIVE",
"column": null,
"derived": [
"CLASS_FIVE_TYPE"
]
},
{
"name": "MAIN_GUAR_CD",
"table": "DIM_MAIN_GUAR",
"column": "MAIN_GUAR_CD",
"derived": null
},
{
"name": "MAIN_GUAR_NAME",
"table": "DIM_MAIN_GUAR",
"column": null,
"derived": [
"MAIN_GUAR_NAME"
]
},
{
"name": "ESTATE_CD",
"table": "DIM_ESTATE_LON",
"column": "ESTATE_CD",
"derived": null
},
{
"name": "ESTATE_DES",
"table": "DIM_ESTATE_LON",
"column": null,
"derived": [
"ESTATE_DES"
]
},
{
"name": "ESTATE_LV",
"table": "DIM_ESTATE_LON",
"column": null,
"derived": [
"ESTATE_LV"
]
},
{
"name": "ESTATE_CD_LV1",
"table": "DIM_ESTATE_LON",
"column": null,
"derived": [
"ESTATE_CD_LV1"
]
},
{
"name": "ESTATE_DES_LV1",
"table": "DIM_ESTATE_LON",
"column": null,
"derived": [
"ESTATE_DES_LV1"
]
},
{
"name": "GL_ACC_CD",
"table": "DIM_GL_ACC",
"column": "GL_ACC_CD",
"derived": null
},
{
"name": "GL_ACC_NAME",
"table": "DIM_GL_ACC",
"column": null,
"derived": [
"GL_ACC_NAME"
]
}
],
"measures": [
{
"name": "_COUNT_",
"function": {
"expression": "COUNT",
"parameter": {
"type": "constant",
"value": "1"
},
"returntype": "bigint"
}
},
{
"name": "1",
"function": {
"expression": "SUM",
"parameter": {
"type": "column",
"value": "LOAN_GROUP.BAL"
},
"returntype": "decimal(19,4)"
}
}
],
"dictionaries": [],
"rowkey": {
"rowkey_columns": [
{
"column": "LOAN_GROUP.DATE_CD",
"encoding": "date",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ORG_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.CURR_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.GL_ACC_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ENT_SCA_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.INDU_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ENT_PSN_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.PER_LON_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.APPR_CREXT_RENT",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.PRD_NO",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.CUST_LON_TYPE",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.PRD_PINGZ",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.CLASS_FIVE_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.MAIN_GUAR_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.REG_ADMI_AREA",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.FORE_LON_TYPE",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.BC_FLAG",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.STRA_INDU_NAME",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.INDU_TRF_UPD_PRO",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ATRE_TYPE_NAME",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ESTATE_TYPE",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_DATE.DATE_CD",
"encoding": "date",
"isShardBy": false
},
{
"column": "DIM_ORG.ORG_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_CURR.CURR_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_ENT_SCA.ENT_SCA_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_INDU.INDU_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_ENT_PSN.ENT_PSN_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_PER_LOAN.PER_LOAN_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_APPR_CREXT.APPR_CREXT_RENT",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_CUST_LON.CUST_LON_TYPE",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_CLASS_FIVE.CLASS_FIVE_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_MAIN_GUAR.MAIN_GUAR_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_ESTATE_LON.ESTATE_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_GL_ACC.GL_ACC_CD",
"encoding": "dict",
"isShardBy": false
}
]
},
"hbase_mapping": {
"column_family": [
{
"name": "F1",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"_COUNT_",
"1"
]
}
]
}
]
},
"aggregation_groups": [
{
"includes": [
"LOAN_GROUP.DATE_CD",
"LOAN_GROUP.ORG_CD",
"LOAN_GROUP.ENT_SCA_CD",
"LOAN_GROUP.INDU_CD",
"LOAN_GROUP.ENT_PSN_CD",
"LOAN_GROUP.PER_LON_CD",
"LOAN_GROUP.APPR_CREXT_RENT",
"LOAN_GROUP.ESTATE_TYPE",
"DIM_APPR_CREXT.APPR_CREXT_RENT"
],
"select_rule": {
"hierarchy_dims": [],
"mandatory_dims": [],
"joint_dims": []
}
}
],
"signature": "QmuvExlbmaV2+dowq1fs3w==",
"notify_list": [],
"status_need_notify": [
"ERROR",
"DISCARDED",
"SUCCEED"
],
"partition_date_start": 1451606400000,
"partition_date_end": 3153600000000,
"auto_merge_time_ranges": [
604800000,
2419200000
],
"retention_range": 0,
"engine_type": 2,
"storage_type": 2,
"override_kylin_properties": {},
"cuboid_black_list": [],
"parent_forward": 3
}
Cube json:
{
"uuid": "20cdd042-15c6-4a8f-8a80-2da41755da28",
"last_modified": 1508914014333,
"version": "2.1.0",
"name": "cube_loan",
"is_draft": false,
"model_name": "model_loan",
"description": "edit at 20171025",
"null_string": null,
"dimensions": [
{
"name": "DATE_CD",
"table": "LOAN_GROUP",
"column": "DATE_CD",
"derived": null
},
{
"name": "ORG_CD",
"table": "LOAN_GROUP",
"column": "ORG_CD",
"derived": null
},
{
"name": "CURR_CD",
"table": "LOAN_GROUP",
"column": "CURR_CD",
"derived": null
},
{
"name": "GL_ACC_CD",
"table": "LOAN_GROUP",
"column": "GL_ACC_CD",
"derived": null
},
{
"name": "ENT_SCA_CD",
"table": "LOAN_GROUP",
"column": "ENT_SCA_CD",
"derived": null
},
{
"name": "INDU_CD",
"table": "LOAN_GROUP",
"column": "INDU_CD",
"derived": null
},
{
"name": "ENT_PSN_CD",
"table": "LOAN_GROUP",
"column": "ENT_PSN_CD",
"derived": null
},
{
"name": "PER_LON_CD",
"table": "LOAN_GROUP",
"column": "PER_LON_CD",
"derived": null
},
{
"name": "APPR_CREXT_RENT",
"table": "LOAN_GROUP",
"column": "APPR_CREXT_RENT",
"derived": null
},
{
"name": "PRD_NO",
"table": "LOAN_GROUP",
"column": "PRD_NO",
"derived": null
},
{
"name": "CUST_LON_TYPE",
"table": "LOAN_GROUP",
"column": "CUST_LON_TYPE",
"derived": null
},
{
"name": "PRD_PINGZ",
"table": "LOAN_GROUP",
"column": "PRD_PINGZ",
"derived": null
},
{
"name": "CLASS_FIVE_CD",
"table": "LOAN_GROUP",
"column": "CLASS_FIVE_CD",
"derived": null
},
{
"name": "MAIN_GUAR_CD",
"table": "LOAN_GROUP",
"column": "MAIN_GUAR_CD",
"derived": null
},
{
"name": "REG_ADMI_AREA",
"table": "LOAN_GROUP",
"column": "REG_ADMI_AREA",
"derived": null
},
{
"name": "FORE_LON_TYPE",
"table": "LOAN_GROUP",
"column": "FORE_LON_TYPE",
"derived": null
},
{
"name": "BC_FLAG",
"table": "LOAN_GROUP",
"column": "BC_FLAG",
"derived": null
},
{
"name": "STRA_INDU_NAME",
"table": "LOAN_GROUP",
"column": "STRA_INDU_NAME",
"derived": null
},
{
"name": "INDU_TRF_UPD_PRO",
"table": "LOAN_GROUP",
"column": "INDU_TRF_UPD_PRO",
"derived": null
},
{
"name": "ATRE_TYPE_NAME",
"table": "LOAN_GROUP",
"column": "ATRE_TYPE_NAME",
"derived": null
},
{
"name": "ESTATE_TYPE",
"table": "LOAN_GROUP",
"column": "ESTATE_TYPE",
"derived": null
},
{
"name": "DATE_CD",
"table": "DIM_DATE",
"column": "DATE_CD",
"derived": null
},
{
"name": "LAST_D",
"table": "DIM_DATE",
"column": null,
"derived": [
"LAST_D"
]
},
{
"name": "LAST_M",
"table": "DIM_DATE",
"column": null,
"derived": [
"LAST_M"
]
},
{
"name": "LAST_Q",
"table": "DIM_DATE",
"column": null,
"derived": [
"LAST_Q"
]
},
{
"name": "LAST_Y",
"table": "DIM_DATE",
"column": null,
"derived": [
"LAST_Y"
]
},
{
"name": "M_END",
"table": "DIM_DATE",
"column": null,
"derived": [
"M_END"
]
},
{
"name": "Q_END",
"table": "DIM_DATE",
"column": null,
"derived": [
"Q_END"
]
},
{
"name": "Y_END",
"table": "DIM_DATE",
"column": null,
"derived": [
"Y_END"
]
},
{
"name": "ORG_CD",
"table": "DIM_ORG",
"column": "ORG_CD",
"derived": null
},
{
"name": "ORG_NAME",
"table": "DIM_ORG",
"column": null,
"derived": [
"ORG_NAME"
]
},
{
"name": "CURR_CD",
"table": "DIM_CURR",
"column": "CURR_CD",
"derived": null
},
{
"name": "CURR_NAME",
"table": "DIM_CURR",
"column": null,
"derived": [
"CURR_NAME"
]
},
{
"name": "ENT_SCA_CD",
"table": "DIM_ENT_SCA",
"column": "ENT_SCA_CD",
"derived": null
},
{
"name": "ENT_SCA_NAME",
"table": "DIM_ENT_SCA",
"column": null,
"derived": [
"ENT_SCA_NAME"
]
},
{
"name": "INDU_CD",
"table": "DIM_INDU",
"column": "INDU_CD",
"derived": null
},
{
"name": "INDU_NAME",
"table": "DIM_INDU",
"column": null,
"derived": [
"INDU_NAME"
]
},
{
"name": "INDU_LV",
"table": "DIM_INDU",
"column": null,
"derived": [
"INDU_LV"
]
},
{
"name": "INDU_CD_LV1",
"table": "DIM_INDU",
"column": null,
"derived": [
"INDU_CD_LV1"
]
},
{
"name": "INDU_NAME_LV1",
"table": "DIM_INDU",
"column": null,
"derived": [
"INDU_NAME_LV1"
]
},
{
"name": "ENT_PSN_CD",
"table": "DIM_ENT_PSN",
"column": "ENT_PSN_CD",
"derived": null
},
{
"name": "ENT_PSN_NAME",
"table": "DIM_ENT_PSN",
"column": null,
"derived": [
"ENT_PSN_NAME"
]
},
{
"name": "PER_LOAN_CD",
"table": "DIM_PER_LOAN",
"column": "PER_LOAN_CD",
"derived": null
},
{
"name": "PER_LOAN_NAME",
"table": "DIM_PER_LOAN",
"column": null,
"derived": [
"PER_LOAN_NAME"
]
},
{
"name": "PER_LOAN_LV",
"table": "DIM_PER_LOAN",
"column": null,
"derived": [
"PER_LOAN_LV"
]
},
{
"name": "PER_LOAN_CD_LV1",
"table": "DIM_PER_LOAN",
"column": null,
"derived": [
"PER_LOAN_CD_LV1"
]
},
{
"name": "PER_LOAN_NAME_LV1",
"table": "DIM_PER_LOAN",
"column": null,
"derived": [
"PER_LOAN_NAME_LV1"
]
},
{
"name": "APPR_CREXT_RENT",
"table": "DIM_APPR_CREXT",
"column": "APPR_CREXT_RENT",
"derived": null
},
{
"name": "APPR_CREXT_RENT_DES",
"table": "DIM_APPR_CREXT",
"column": null,
"derived": [
"APPR_CREXT_RENT_DES"
]
},
{
"name": "CUST_LON_TYPE",
"table": "DIM_CUST_LON",
"column": "CUST_LON_TYPE",
"derived": null
},
{
"name": "CUST_LON_NAME",
"table": "DIM_CUST_LON",
"column": null,
"derived": [
"CUST_LON_NAME"
]
},
{
"name": "CLASS_FIVE_CD",
"table": "DIM_CLASS_FIVE",
"column": "CLASS_FIVE_CD",
"derived": null
},
{
"name": "CLASS_FIVE_NAME",
"table": "DIM_CLASS_FIVE",
"column": null,
"derived": [
"CLASS_FIVE_NAME"
]
},
{
"name": "CLASS_FIVE_TYPE",
"table": "DIM_CLASS_FIVE",
"column": null,
"derived": [
"CLASS_FIVE_TYPE"
]
},
{
"name": "MAIN_GUAR_CD",
"table": "DIM_MAIN_GUAR",
"column": "MAIN_GUAR_CD",
"derived": null
},
{
"name": "MAIN_GUAR_NAME",
"table": "DIM_MAIN_GUAR",
"column": null,
"derived": [
"MAIN_GUAR_NAME"
]
},
{
"name": "ESTATE_CD",
"table": "DIM_ESTATE_LON",
"column": "ESTATE_CD",
"derived": null
},
{
"name": "ESTATE_DES",
"table": "DIM_ESTATE_LON",
"column": null,
"derived": [
"ESTATE_DES"
]
},
{
"name": "ESTATE_LV",
"table": "DIM_ESTATE_LON",
"column": null,
"derived": [
"ESTATE_LV"
]
},
{
"name": "ESTATE_CD_LV1",
"table": "DIM_ESTATE_LON",
"column": null,
"derived": [
"ESTATE_CD_LV1"
]
},
{
"name": "ESTATE_DES_LV1",
"table": "DIM_ESTATE_LON",
"column": null,
"derived": [
"ESTATE_DES_LV1"
]
},
{
"name": "GL_ACC_CD",
"table": "DIM_GL_ACC",
"column": "GL_ACC_CD",
"derived": null
},
{
"name": "GL_ACC_NAME",
"table": "DIM_GL_ACC",
"column": null,
"derived": [
"GL_ACC_NAME"
]
}
],
"measures": [
{
"name": "_COUNT_",
"function": {
"expression": "COUNT",
"parameter": {
"type": "constant",
"value": "1"
},
"returntype": "bigint"
}
},
{
"name": "1",
"function": {
"expression": "SUM",
"parameter": {
"type": "column",
"value": "LOAN_GROUP.BAL"
},
"returntype": "decimal(19,4)"
}
}
],
"dictionaries": [],
"rowkey": {
"rowkey_columns": [
{
"column": "LOAN_GROUP.DATE_CD",
"encoding": "date",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ORG_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.CURR_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.GL_ACC_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ENT_SCA_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.INDU_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ENT_PSN_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.PER_LON_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.APPR_CREXT_RENT",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.PRD_NO",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.CUST_LON_TYPE",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.PRD_PINGZ",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.CLASS_FIVE_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.MAIN_GUAR_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.REG_ADMI_AREA",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.FORE_LON_TYPE",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.BC_FLAG",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.STRA_INDU_NAME",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.INDU_TRF_UPD_PRO",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ATRE_TYPE_NAME",
"encoding": "dict",
"isShardBy": false
},
{
"column": "LOAN_GROUP.ESTATE_TYPE",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_DATE.DATE_CD",
"encoding": "date",
"isShardBy": false
},
{
"column": "DIM_ORG.ORG_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_CURR.CURR_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_ENT_SCA.ENT_SCA_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_INDU.INDU_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_ENT_PSN.ENT_PSN_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_PER_LOAN.PER_LOAN_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_APPR_CREXT.APPR_CREXT_RENT",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_CUST_LON.CUST_LON_TYPE",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_CLASS_FIVE.CLASS_FIVE_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_MAIN_GUAR.MAIN_GUAR_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_ESTATE_LON.ESTATE_CD",
"encoding": "dict",
"isShardBy": false
},
{
"column": "DIM_GL_ACC.GL_ACC_CD",
"encoding": "dict",
"isShardBy": false
}
]
},
"hbase_mapping": {
"column_family": [
{
"name": "F1",
"columns": [
{
"qualifier": "M",
"measure_refs": [
"_COUNT_",
"1"
]
}
]
}
]
},
"aggregation_groups": [
{
"includes": [
"LOAN_GROUP.DATE_CD",
"LOAN_GROUP.ORG_CD",
"LOAN_GROUP.ENT_SCA_CD",
"LOAN_GROUP.INDU_CD",
"LOAN_GROUP.ENT_PSN_CD",
"LOAN_GROUP.PER_LON_CD",
"LOAN_GROUP.APPR_CREXT_RENT",
"LOAN_GROUP.ESTATE_TYPE",
"DIM_APPR_CREXT.APPR_CREXT_RENT"
],
"select_rule": {
"hierarchy_dims": [],
"mandatory_dims": [],
"joint_dims": []
}
}
],
"signature": "QmuvExlbmaV2+dowq1fs3w==",
"notify_list": [],
"status_need_notify": [
"ERROR",
"DISCARDED",
"SUCCEED"
],
"partition_date_start": 1451606400000,
"partition_date_end": 3153600000000,
"auto_merge_time_ranges": [
604800000,
2419200000
],
"retention_range": 0,
"engine_type": 2,
"storage_type": 2,
"override_kylin_properties": {},
"cuboid_black_list": [],
"parent_forward": 3
}
[email protected]
