[ https://issues.apache.org/jira/browse/KYLIN-4180?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Temple Zhou reopened KYLIN-4180: -------------------------------- The fix solution can be better. > 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)