??????why cannot use more than 2 elements in SQL IN clause? This problem is threaten my business logic...I cannot use in clause

[????]

maybe you use kylin the wrong way, check your cube design, follow the kylin 
docs instruction, read the document once more.




------------------ ???????? ------------------
??????:                                                                         
                                               "user"                           
                                                         <1091643...@qq.com&gt;;
????????:&nbsp;2021??1??10??(??????) ????11:14
??????:&nbsp;"user"<user@kylin.apache.org&gt;;

????:&nbsp;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,
&nbsp; &nbsp; &nbsp; I'm stuck by this problem more than 3 days, cannot find 
any usefull message by searched everywhere.
&nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp; &nbsp;If use more then 2 elements in IN clause, the query is 
failed. 




any ideas, thanks!!




&nbsp;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&nbsp; [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
&nbsp; &nbsp; &nbsp; &nbsp; FROM
&nbsp; &nbsp; &nbsp; &nbsp; mt_trace_behavior
&nbsp; &nbsp; &nbsp; &nbsp; WHERE
&nbsp; &nbsp; &nbsp; &nbsp; company='helmsman'
&nbsp; &nbsp; &nbsp; &nbsp; 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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM&nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp;mintai_trace_behavior&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE&nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp;company='helmsman'&nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;FROM&nbsp; &nbsp; &nbsp; 
&nbsp; &nbsp;mintai_trace_behavior&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;WHERE&nbsp; 
&nbsp; &nbsp; &nbsp; &nbsp;company='helmsman'&nbsp; &nbsp; &nbsp; &nbsp; 
&nbsp;and staffid in(44, 116,95)) limit 50000"
&nbsp; &nbsp; &nbsp; &nbsp; at 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:479)
&nbsp; &nbsp; &nbsp; &nbsp; at 
org.apache.kylin.rest.service.QueryService.doQueryWithCache(QueryService.java:398)
&nbsp; &nbsp; &nbsp; &nbsp; at 
org.apache.kylin.rest.controller.QueryController.query(QueryController.java:93)