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.
