You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@kylin.apache.org by 刘波 <10...@qq.com> on 2021/01/10 03:14:52 UTC
why cannot use more than 2 elements in SQL IN clause? This problem is threaten my business logic...I cannot use in clause
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)
回复：why cannot use more than 2 elements in SQL IN clause? This problem is threaten my business logic...I cannot use in clause
Posted by 刘波 <10...@qq.com>.
maybe you use kylin the wrong way, check your cube design, follow the kylin docs instruction, read the document once more.
------------------ 原始邮件 ------------------
发件人: "user" <1091643978@qq.com>;
发送时间: 2021年1月10日(星期天) 中午11:14
收件人: "user"<user@kylin.apache.org>;
主题: why cannot use more than 2 elements in SQL IN clause? This problem is threaten my business logic...I cannot use in clause
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)