Kylin will match the queries with the data model. If the query pattern
doesn't comply with any model/cube, it will report such error.

I see your query is starting from a lookup table, can you change it to
start from fact table and followed with the lookup tables? Just take a try,
it might be this reason.

2017-07-11 22:12 GMT+08:00 Bhanu Prakash Sunkesula <[email protected]>
:

> Hi all,
>
> When we trigger a sql query, it is throwing an error like No model found
> forrel#993:OLAPTableScan.OLAP,
>
> I am using Apache kylin v2.0 with Hortonworks 2.5, The Cube got built
> successfully,when we trigger individual tables, it will shows results but
> when we join a dimension with fact table then it is throwing error.
> <http://apache-kylin.74782.x6.nabble.com/file/n8409/kylin_issues.jpg>
>
> CUbe(JSON)
> {
>   "uuid": "d1c30af6-4584-41bc-b0f1-fde9553d4130",
>   "last_modified": 1492709442188,
>   "version": "2.0.0",
>   "name": "KY_SA_CU_CUBE",
>   "model_name": "KY_SA_CU_MODEL",
>   "description": "",
>   "null_string": null,
>   "dimensions": [
>     {
>       "name": "EVENT_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "EVENT_ID",
>       "derived": null
>     },
>     {
>       "name": "CASE_NUMBER",
>       "table": "KY_SA_CU_FACT",
>       "column": "CASE_NUMBER",
>       "derived": null
>     },
>     {
>       "name": "ASSET_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "ASSET_ID",
>       "derived": null
>     },
>     {
>       "name": "ACCOUNT_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "ACCOUNT_ID",
>       "derived": null
>     },
>     {
>       "name": "PRODUCT_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "PRODUCT_ID",
>       "derived": null
>     },
>     {
>       "name": "LOCATION_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "LOCATION_ID",
>       "derived": null
>     },
>     {
>       "name": "SERVICE_DELIVERY_PART_ORDER_LINE_INTERNAL_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "SERVICE_DELIVERY_PART_ORDER_LINE_INTERNAL_ID",
>       "derived": null
>     },
>     {
>       "name": "SERVICE_DELIVERY_TASK_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "SERVICE_DELIVERY_TASK_ID",
>       "derived": null
>     },
>     {
>       "name": "SERVICE_DELIVERY_PART_ORDER_INTERNAL_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "SERVICE_DELIVERY_PART_ORDER_INTERNAL_ID",
>       "derived": null
>     },
>     {
>       "name": "TASK_TYPE_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "TASK_TYPE_ID",
>       "derived": null
>     },
>     {
>       "name": "USER_INT_ID",
>       "table": "KY_SA_CU_FACT",
>       "column": "USER_INT_ID",
>       "derived": null
>     },
>     {
>       "name": "CREATED_TIMESTAMP",
>       "table": "KY_SA_CU_FACT",
>       "column": "CREATED_TIMESTAMP",
>       "derived": null
>     },
>     {
>       "name": "UPDATE_GMT_TIMESTAMP",
>       "table": "KY_SA_CU_FACT",
>       "column": "UPDATE_GMT_TIMESTAMP",
>       "derived": null
>     },
>     {
>       "name": "SERVICE_DELIVERY_TASK_ID",
>       "table": "SERVICE_DELIVERY_TASK_DIM",
>       "column": null,
>       "derived": [
>         "SERVICE_DELIVERY_TASK_ID"
>       ]
>     },
>     {
>       "name": "ACTION_TYPE_TEXT",
>       "table": "SERVICE_DELIVERY_TASK_DIM",
>       "column": null,
>       "derived": [
>         "ACTION_TYPE_TEXT"
>       ]
>     },
>     {
>       "name": "CASE_SEVERITY_NUMBER",
>       "table": "SERVICE_DELIVERY_TASK_DIM",
>       "column": null,
>       "derived": [
>         "CASE_SEVERITY_NUMBER"
>       ]
>     },
>     {
>       "name": "CKSW_WORK_ORDER_ID",
>       "table": "SERVICE_DELIVERY_TASK_DIM",
>       "column": null,
>       "derived": [
>         "CKSW_WORK_ORDER_ID"
>       ]
>     },
>     {
>       "name": "REPAIR_CLASS_TEXT",
>       "table": "SERVICE_DELIVERY_TASK_DIM",
>       "column": null,
>       "derived": [
>         "REPAIR_CLASS_TEXT"
>       ]
>     },
>     {
>       "name": "TITLE_TEXT",
>       "table": "SERVICE_DELIVERY_TASK_DIM",
>       "column": null,
>       "derived": [
>         "TITLE_TEXT"
>       ]
>     },
>     {
>       "name": "CKSW_TASK_TYPE_ID",
>       "table": "SERVICE_DELIVERY_TASK_DIM",
>       "column": null,
>       "derived": [
>         "CKSW_TASK_TYPE_ID"
>       ]
>     },
>     {
>       "name": "SERVICE_REVISIT_FLAG",
>       "table": "SERVICE_DELIVERY_TASK_DIM",
>       "column": null,
>       "derived": [
>         "SERVICE_REVISIT_FLAG"
>       ]
>     },
>     {
>       "name": "USER_INT_ID",
>       "table": "USER_DIM",
>       "column": null,
>       "derived": [
>         "USER_INT_ID"
>       ]
>     },
>     {
>       "name": "ACCOUNT_ID",
>       "table": "USER_DIM",
>       "column": null,
>       "derived": [
>         "ACCOUNT_ID"
>       ]
>     },
>     {
>       "name": "ACCOUNT_ID_TEXT",
>       "table": "USER_DIM",
>       "column": null,
>       "derived": [
>         "ACCOUNT_ID_TEXT"
>       ]
>     },
>     {
>       "name": "COMPANY_NAME",
>       "table": "USER_DIM",
>       "column": null,
>       "derived": [
>         "COMPANY_NAME"
>       ]
>     },
>     {
>       "name": "DEPARTMENT_DESCRIPTION",
>       "table": "USER_DIM",
>       "column": null,
>       "derived": [
>         "DEPARTMENT_DESCRIPTION"
>       ]
>     },
>     {
>       "name": "EMPLOYEE_COST_CENTER",
>       "table": "USER_DIM",
>       "column": null,
>       "derived": [
>         "EMPLOYEE_COST_CENTER"
>       ]
>     },
>     {
>       "name": "EMAIL_NAME",
>       "table": "USER_DIM",
>       "column": null,
>       "derived": [
>         "EMAIL_NAME"
>       ]
>     },
>     {
>       "name": "FIRST_NAME",
>       "table": "USER_DIM",
>       "column": null,
>       "derived": [
>         "FIRST_NAME"
>       ]
>     },
>     {
>       "name": "LAST_NAME",
>       "table": "USER_DIM",
>       "column": null,
>       "derived": [
>         "LAST_NAME"
>       ]
>     },
>     {
>       "name": "SERVICE_DELIVERY_PART_ORDER_LINE_INTERNAL_ID",
>       "table": "SERVICE_DELIVERY_PART_ORDER_LINE_DIM",
>       "column": null,
>       "derived": [
>         "SERVICE_DELIVERY_PART_ORDER_LINE_INTERNAL_ID"
>       ]
>     },
>     {
>       "name": "PART_DESCRIPTION",
>       "table": "SERVICE_DELIVERY_PART_ORDER_LINE_DIM",
>       "column": null,
>       "derived": [
>         "PART_DESCRIPTION"
>       ]
>     },
>     {
>       "name": "PART_IDENTIFIER",
>       "table": "SERVICE_DELIVERY_PART_ORDER_LINE_DIM",
>       "column": null,
>       "derived": [
>         "PART_IDENTIFIER"
>       ]
>     },
>     {
>       "name": "PART_LINE_STATUS",
>       "table": "SERVICE_DELIVERY_PART_ORDER_LINE_DIM",
>       "column": null,
>       "derived": [
>         "PART_LINE_STATUS"
>       ]
>     },
>     {
>       "name": "PART_ORDER_HEADER_NUMBER_ID",
>       "table": "SERVICE_DELIVERY_PART_ORDER_LINE_DIM",
>       "column": null,
>       "derived": [
>         "PART_ORDER_HEADER_NUMBER_ID"
>       ]
>     },
>     {
>       "name": "PART_USAGE",
>       "table": "SERVICE_DELIVERY_PART_ORDER_LINE_DIM",
>       "column": null,
>       "derived": [
>         "PART_USAGE"
>       ]
>     },
>     {
>       "name": "PRODUCT_HIERARCHY_INTERNAL_ID",
>       "table": "PRODUCT_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_HIERARCHY_INTERNAL_ID"
>       ]
>     },
>     {
>       "name": "PRODUCT_DESCRIPTION",
>       "table": "PRODUCT_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_DESCRIPTION"
>       ]
>     },
>     {
>       "name": "PRODUCT_CLASSIFICATION",
>       "table": "PRODUCT_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_CLASSIFICATION"
>       ]
>     },
>     {
>       "name": "PRODUCT_ORGANIZATION",
>       "table": "PRODUCT_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_ORGANIZATION"
>       ]
>     },
>     {
>       "name": "PRODUCT_GROUP",
>       "table": "PRODUCT_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_GROUP"
>       ]
>     },
>     {
>       "name": "PRODUCT_MODEL",
>       "table": "PRODUCT_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_MODEL"
>       ]
>     },
>     {
>       "name": "PRODUCT_SERIES",
>       "table": "PRODUCT_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_SERIES"
>       ]
>     },
>     {
>       "name": "PRODUCT_CATEGORY",
>       "table": "PRODUCT_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_CATEGORY"
>       ]
>     },
>     {
>       "name": "ACCOUNT_ID",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "ACCOUNT_ID",
>       "derived": null
>     },
>     {
>       "name": "ASSET_ID",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "ASSET_ID",
>       "derived": null
>     },
>     {
>       "name": "LOCATION_ID",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "LOCATION_ID",
>       "derived": null
>     },
>     {
>       "name": "CASE_INTERNAL_ID",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "CASE_INTERNAL_ID",
>       "derived": null
>     },
>     {
>       "name": "PRODUCT_ID",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "PRODUCT_ID",
>       "derived": null
>     },
>     {
>       "name": "CASE_NUMBER",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "CASE_NUMBER",
>       "derived": null
>     },
>     {
>       "name": "ASSET_SERIAL_NUMBER",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "ASSET_SERIAL_NUMBER",
>       "derived": null
>     },
>     {
>       "name": "ASSET_COUNTRY_TEXT",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "ASSET_COUNTRY_TEXT",
>       "derived": null
>     },
>     {
>       "name": "COUNTRY_NAME",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "COUNTRY_NAME",
>       "derived": null
>     },
>     {
>       "name": "COVERAGE_RESPONSE_TEXT",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "COVERAGE_RESPONSE_TEXT",
>       "derived": null
>     },
>     {
>       "name": "ORDER_TYPE_CODE",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "ORDER_TYPE_CODE",
>       "derived": null
>     },
>     {
>       "name": "ORIGIN_NAME",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "ORIGIN_NAME",
>       "derived": null
>     },
>     {
>       "name": "RECORD_NAME",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "RECORD_NAME",
>       "derived": null
>     },
>     {
>       "name": "RESOLUTION_CODE",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "RESOLUTION_CODE",
>       "derived": null
>     },
>     {
>       "name": "SERVICE_PORTFOLIO_TEXT",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "SERVICE_PORTFOLIO_TEXT",
>       "derived": null
>     },
>     {
>       "name": "STATUS_TEXT",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "STATUS_TEXT",
>       "derived": null
>     },
>     {
>       "name": "MISSION_CRITICAL_FLAG",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "MISSION_CRITICAL_FLAG",
>       "derived": null
>     },
>     {
>       "name": "CREATED_TIMESTAMP",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "CREATED_TIMESTAMP",
>       "derived": null
>     },
>     {
>       "name": "INSERT_GMT_TIMESTAMP",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "INSERT_GMT_TIMESTAMP",
>       "derived": null
>     },
>     {
>       "name": "UPDATE_GMT_TIMESTAMP",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "UPDATE_GMT_TIMESTAMP",
>       "derived": null
>     },
>     {
>       "name": "CLOSED_DATE_TIMESTAMP",
>       "table": "SERVICE_DELIVERY_CASE_DIM",
>       "column": "CLOSED_DATE_TIMESTAMP",
>       "derived": null
>     },
>     {
>       "name": "ACCOUNT_INT_ID",
>       "table": "ACCOUNT_DIM",
>       "column": null,
>       "derived": [
>         "ACCOUNT_INT_ID"
>       ]
>     },
>     {
>       "name": "ACCOUNT_INT_NAME",
>       "table": "ACCOUNT_DIM",
>       "column": null,
>       "derived": [
>         "ACCOUNT_INT_NAME"
>       ]
>     },
>     {
>       "name": "ACCOUNT_NUMBER",
>       "table": "ACCOUNT_DIM",
>       "column": null,
>       "derived": [
>         "ACCOUNT_NUMBER"
>       ]
>     },
>     {
>       "name": "ACCOUNT_REGION",
>       "table": "ACCOUNT_DIM",
>       "column": null,
>       "derived": [
>         "ACCOUNT_REGION"
>       ]
>     },
>     {
>       "name": "WORLD_REGION",
>       "table": "ACCOUNT_DIM",
>       "column": null,
>       "derived": [
>         "WORLD_REGION"
>       ]
>     },
>     {
>       "name": "LOCATION_ID",
>       "table": "LOCATION_DIM",
>       "column": null,
>       "derived": [
>         "LOCATION_ID"
>       ]
>     },
>     {
>       "name": "REGION",
>       "table": "LOCATION_DIM",
>       "column": null,
>       "derived": [
>         "REGION"
>       ]
>     },
>     {
>       "name": "SUB_REGION",
>       "table": "LOCATION_DIM",
>       "column": null,
>       "derived": [
>         "SUB_REGION"
>       ]
>     },
>     {
>       "name": "COUNTRY",
>       "table": "LOCATION_DIM",
>       "column": null,
>       "derived": [
>         "COUNTRY"
>       ]
>     },
>     {
>       "name": "STATE_TEXT",
>       "table": "LOCATION_DIM",
>       "column": null,
>       "derived": [
>         "STATE_TEXT"
>       ]
>     },
>     {
>       "name": "CITY",
>       "table": "LOCATION_DIM",
>       "column": null,
>       "derived": [
>         "CITY"
>       ]
>     },
>     {
>       "name": "ASSET_ID",
>       "table": "ASSET_DIM",
>       "column": null,
>       "derived": [
>         "ASSET_ID"
>       ]
>     },
>     {
>       "name": "MANUFACTURER_NAME",
>       "table": "ASSET_DIM",
>       "column": null,
>       "derived": [
>         "MANUFACTURER_NAME"
>       ]
>     },
>     {
>       "name": "HP_PRODUCT_NUMBER",
>       "table": "ASSET_DIM",
>       "column": null,
>       "derived": [
>         "HP_PRODUCT_NUMBER"
>       ]
>     },
>     {
>       "name": "PRODUCT_FAMILY",
>       "table": "ASSET_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_FAMILY"
>       ]
>     },
>     {
>       "name": "ASSET_DOMAIN_TEXT",
>       "table": "ASSET_DIM",
>       "column": null,
>       "derived": [
>         "ASSET_DOMAIN_TEXT"
>       ]
>     },
>     {
>       "name": "PRODUCT_LINE_TEXT",
>       "table": "ASSET_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_LINE_TEXT"
>       ]
>     },
>     {
>       "name": "PRODUCT_HIERARCHY_INTERNAL_ID",
>       "table": "ASSET_DIM",
>       "column": null,
>       "derived": [
>         "PRODUCT_HIERARCHY_INTERNAL_ID"
>       ]
>     },
>     {
>       "name": "EVENT_ID",
>       "table": "EVENT_DIM",
>       "column": "EVENT_ID",
>       "derived": null
>     },
>     {
>       "name": "CASE_NUMBER",
>       "table": "EVENT_DIM",
>       "column": "CASE_NUMBER",
>       "derived": null
>     },
>     {
>       "name": "PROBLEM_AREA",
>       "table": "EVENT_DIM",
>       "column": "PROBLEM_AREA",
>       "derived": null
>     },
>     {
>       "name": "PROBLEM_DESCRIPTION",
>       "table": "EVENT_DIM",
>       "column": "PROBLEM_DESCRIPTION",
>       "derived": null
>     },
>     {
>       "name": "CASE_TYPE",
>       "table": "EVENT_DIM",
>       "column": "CASE_TYPE",
>       "derived": null
>     },
>     {
>       "name": "SEVERITY_NAME",
>       "table": "EVENT_DIM",
>       "column": "SEVERITY_NAME",
>       "derived": null
>     },
>     {
>       "name": "SERVICE_DELIVERY_PART_ORDER_INTERNAL_ID",
>       "table": "SERVICE_DELIVERY_PART_ORDER_DIM",
>       "column": null,
>       "derived": [
>         "SERVICE_DELIVERY_PART_ORDER_INTERNAL_ID"
>       ]
>     },
>     {
>       "name": "PART_ORDER_IDENTIFIER",
>       "table": "SERVICE_DELIVERY_PART_ORDER_DIM",
>       "column": null,
>       "derived": [
>         "PART_ORDER_IDENTIFIER"
>       ]
>     },
>     {
>       "name": "REPAIR_TASK_ID",
>       "table": "SERVICE_DELIVERY_PART_ORDER_DIM",
>       "column": null,
>       "derived": [
>         "REPAIR_TASK_ID"
>       ]
>     },
>     {
>       "name": "TASK_TYPE_INTERNAL_ID",
>       "table": "TASK_TYPE_DIM",
>       "column": null,
>       "derived": [
>         "TASK_TYPE_INTERNAL_ID"
>       ]
>     },
>     {
>       "name": "TASK_TYPE_INTERNAL_NAME",
>       "table": "TASK_TYPE_DIM",
>       "column": null,
>       "derived": [
>         "TASK_TYPE_INTERNAL_NAME"
>       ]
>     }
>   ],
>   "measures": [
>     {
>       "name": "TOTAL_COUNT",
>       "function": {
>         "expression": "COUNT",
>         "parameter": {
>           "type": "constant",
>           "value": "1"
>         },
>         "returntype": "bigint"
>       }
>     },
>     {
>       "name": "CASE_COUNT",
>       "function": {
>         "expression": "SUM",
>         "parameter": {
>           "type": "column",
>           "value": "KY_SA_CU_FACT.CASE_COUNT"
>         },
>         "returntype": "bigint"
>       }
>     },
>     {
>       "name": "EVENT_COUNT",
>       "function": {
>         "expression": "SUM",
>         "parameter": {
>           "type": "column",
>           "value": "KY_SA_CU_FACT.EVENT_COUNT"
>         },
>         "returntype": "bigint"
>       }
>     }
>   ],
>   "dictionaries": [],
>   "rowkey": {
>     "rowkey_columns": [
>       {
>         "column": "KY_SA_CU_FACT.EVENT_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.CASE_NUMBER",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.ASSET_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.ACCOUNT_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.PRODUCT_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.LOCATION_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column":
> "KY_SA_CU_FACT.SERVICE_DELIVERY_PART_ORDER_LINE_INTERNAL_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.SERVICE_DELIVERY_TASK_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.SERVICE_DELIVERY_PART_ORDER_INTERNAL_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.TASK_TYPE_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.USER_INT_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.CREATED_TIMESTAMP",
>         "encoding": "time",
>         "isShardBy": false
>       },
>       {
>         "column": "KY_SA_CU_FACT.UPDATE_GMT_TIMESTAMP",
>         "encoding": "time",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.ACCOUNT_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.ASSET_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.LOCATION_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.CASE_INTERNAL_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.PRODUCT_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.CASE_NUMBER",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.ASSET_SERIAL_NUMBER",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.ASSET_COUNTRY_TEXT",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.COUNTRY_NAME",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.COVERAGE_RESPONSE_TEXT",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.ORDER_TYPE_CODE",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.ORIGIN_NAME",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.RECORD_NAME",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.RESOLUTION_CODE",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.SERVICE_PORTFOLIO_TEXT",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.STATUS_TEXT",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.MISSION_CRITICAL_FLAG",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.CREATED_TIMESTAMP",
>         "encoding": "time",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.INSERT_GMT_TIMESTAMP",
>         "encoding": "time",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.UPDATE_GMT_TIMESTAMP",
>         "encoding": "time",
>         "isShardBy": false
>       },
>       {
>         "column": "SERVICE_DELIVERY_CASE_DIM.CLOSED_DATE_TIMESTAMP",
>         "encoding": "time",
>         "isShardBy": false
>       },
>       {
>         "column": "EVENT_DIM.EVENT_ID",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "EVENT_DIM.CASE_NUMBER",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "EVENT_DIM.PROBLEM_AREA",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "EVENT_DIM.PROBLEM_DESCRIPTION",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "EVENT_DIM.CASE_TYPE",
>         "encoding": "dict",
>         "isShardBy": false
>       },
>       {
>         "column": "EVENT_DIM.SEVERITY_NAME",
>         "encoding": "dict",
>         "isShardBy": false
>       }
>     ]
>   },
>   "hbase_mapping": {
>     "column_family": [
>       {
>         "name": "F1",
>         "columns": [
>           {
>             "qualifier": "M",
>             "measure_refs": [
>               "TOTAL_COUNT",
>               "CASE_COUNT",
>               "EVENT_COUNT"
>             ]
>           }
>         ]
>       }
>     ]
>   },
>   "aggregation_groups": [
>     {
>       "includes": [
>         "KY_SA_CU_FACT.EVENT_ID",
>         "KY_SA_CU_FACT.CASE_NUMBER",
>         "KY_SA_CU_FACT.ASSET_ID",
>         "KY_SA_CU_FACT.ACCOUNT_ID",
>         "KY_SA_CU_FACT.PRODUCT_ID",
>         "KY_SA_CU_FACT.LOCATION_ID",
>         "KY_SA_CU_FACT.SERVICE_DELIVERY_PART_ORDER_LINE_INTERNAL_ID",
>         "KY_SA_CU_FACT.SERVICE_DELIVERY_TASK_ID",
>         "KY_SA_CU_FACT.SERVICE_DELIVERY_PART_ORDER_INTERNAL_ID",
>         "KY_SA_CU_FACT.TASK_TYPE_ID",
>         "KY_SA_CU_FACT.USER_INT_ID"
>       ],
>       "select_rule": {
>         "hierarchy_dims": [],
>         "mandatory_dims": [],
>         "joint_dims": []
>       }
>     }
>   ],
>   "signature": "hSVaBE8XqLJWMa5OvpeANA==",
>   "notify_list": [],
>   "status_need_notify": [
>     "ERROR",
>     "DISCARDED",
>     "SUCCEED"
>   ],
>   "partition_date_start": 0,
>   "partition_date_end": 3153600000000,
>   "auto_merge_time_ranges": [
>     604800000,
>     2419200000
>   ],
>   "retention_range": 0,
>   "engine_type": 2,
>   "storage_type": 2,
>   "override_kylin_properties": {}
> }
>
> --
> View this message in context: http://apache-kylin.74782.x6.
> nabble.com/Apache-Kylin-2-0v-Error-No-model-found-forrel-
> 993-OLAPTableScan-OLAP-tp8409.html
> Sent from the Apache Kylin mailing list archive at Nabble.com.
>



-- 
Best regards,

Shaofeng Shi 史少锋

Reply via email to