kylin-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "apache_dev@163.com" <apache_...@163.com>
Subject Cube can run right,but query is error
Date Wed, 25 Oct 2017 07:28:38 GMT
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
}







apache_dev@163.com
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message