You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by Bhanu Prakash Sunkesula <bp...@gmail.com> on 2017/07/11 14:12:09 UTC
Apache Kylin - 2.0v - Error -- No model found
forrel#993:OLAPTableScan.OLAP
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.
Re: Apache Kylin - 2.0v - Error -- No model found forrel#993:OLAPTableScan.OLAP
Posted by ShaoFeng Shi <sh...@apache.org>.
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 <bp...@gmail.com>
:
> 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 史少锋