[jira] [Commented] (KYLIN-4180) Prevent abnormal CPU usage by limiting flat filters length

["ASF GitHub Bot (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/KYLIN-4180?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16938404#comment-16938404 ] 

ASF GitHub Bot commented on KYLIN-4180:
---------------------------------------

TempleZhou commented on pull request #861: KYLIN-4180 Prevent abnormal CPU usage by limiting flat filters length
URL: https://github.com/apache/kylin/pull/861
 
 
   
 
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


> Prevent abnormal CPU usage by limiting flat filters length
> ----------------------------------------------------------
>
>                 Key: KYLIN-4180
>                 URL: https://issues.apache.org/jira/browse/KYLIN-4180
>             Project: Kylin
>          Issue Type: Improvement
>          Components: Metadata
>    Affects Versions: v2.4.0, v2.5.0, v2.6.0
>            Reporter: Temple Zhou
>            Assignee: Temple Zhou
>            Priority: Major
>
> The following SQL will lead to the list  returned by org.apache.kylin.metadata.filter.TupleFilter#cartesianProduct become very large, and the process to producing the List will use lots of CPU.
> {code:sql}
> select * from temp.test_filter
> where ((a >= 0 and a <= 1)
> or    (a >= 1 and a <= 2)
> or    (a >= 2 and a <= 3)
> ...
> or    (a >= 300 and a <= 301)
> ) and ((b >= 0 and b <= 1)
> or    (b >= 1 and b <= 2)
> or    (b >= 2 and b <= 3)
> ...
> or    (b >= 300 and b <= 301)
> )
> {code}



--
This message was sent by Atlassian Jira
(v8.3.4#803005)