"select *" is not a good OLAP query. Try sum() on some measure with group by.
On Wed, Oct 25, 2017 at 3:28 PM, [email protected] <[email protected]> wrote: > 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] >
