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

["ASF subversion and git services (Jira)" <ji...@apache.org>]

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

ASF subversion and git services commented on KYLIN-4180:
--------------------------------------------------------

Commit 9d6671a024046c121f9f02ff8e9bb51012a12da5 in kylin's branch refs/heads/master from Temple Zhou
[ https://gitbox.apache.org/repos/asf?p=kylin.git;h=9d6671a ]

KYLIN-4180 Prevent abnormal CPU usage by limiting flat filters length


> 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
>             Fix For: v3.0.0-beta, v2.6.5
>
>
> strong textThe 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)