dear users, I'm stuck by this problem more than 3 days, cannot find any usefull message by searched everywhere. If use more then 2 elements in IN clause, the query is failed.
any ideas, thanks!! Timeout visiting cube! Check why coprocessor exception is not sent back? In coprocessor Self-termination is checked every 100 scanned rows, the configured timeout(54000) cannot support this many scans 2021-01-10 02:57:01,956 INFO [Query 9a917c3f-9083-eea2-fd3c-716bbc8ccb87-50836] service.QueryService:384 : ==========================[QUERY]=============================== Query Id: 9a917c3f-9083-eea2-fd3c-716bbc8ccb87 SQL: select COUNT(*) frequency, COUNT(DISTINCT sponsor) visitor FROM mt_trace_behavior WHERE company='helmsman' and staffid in(44, 116,95) User: ADMIN Success: false Duration: 540.119 Project: mintai_trace_2 Realization Names: [CUBE[name=mt_cube]] Cuboid Ids: [384] Total scan count: 0 Total scan bytes: 0 Result row count: 0 Accept Partial: true Is Partial Result: false Hit Exception Cache: false Storage cache used: false Is Query Push-Down: false Is Prepare: false Trace URL: null Message: Timeout visiting cube! Check why coprocessor exception is not sent back? In coprocessor Self-termination is checked every 100 scanned rows, the configured timeout(54000) cannot support this many scans? while executing SQL: "select * from (select COUNT(*) frequency, COUNT(DISTINCT sponsor) visitor FROM mintai_trace_behavior WHERE company='helmsman' and staffid in(44, 116,95)) limit 50000" ==========================[QUERY]=============================== 2021-01-10 02:57:01,957 ERROR [http-bio-7070-exec-21] controller.BasicController:63 : org.apache.kylin.rest.exception.InternalErrorException: Timeout visiting cube! Check why coprocessor exception is not sent back? In coprocessor Self-termination is checked every 100 scanned rows, the configured timeout(54000) cannot support this many scans? while executing SQL: "select * from (select COUNT(*) frequency, COUNT(DISTINCT sponsor) visitor FROM mintai_trace_behavior WHERE company='helmsman' and staffid in(44, 116,95)) limit 50000" at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:479) at org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:398) at org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)
