[ https://issues.apache.org/jira/browse/KYLIN-2212?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15689369#comment-15689369 ]
zhengdong commented on KYLIN-2212: ---------------------------------- Trying to push the 'not' operator into children filters to help to get correct range filter. Could you please help to review the patch, liyang? > 'NOT' operator in filter on derived column may get incorrect result > -------------------------------------------------------------------- > > Key: KYLIN-2212 > URL: https://issues.apache.org/jira/browse/KYLIN-2212 > Project: Kylin > Issue Type: Bug > Affects Versions: v1.5.3, v1.5.4.1 > Reporter: zhengdong > Assignee: zhengdong > Attachments: > 0001-KYLIN-2212-NOT-operator-in-filter-on-derived-column-.patch > > > when a compare filter on derived column specified in where clause, it will be > translated into a filter on PK, and further converted to a range filter on PK > ( GT the min, LT the max) if the PK values' s size larger than the > threshold. > However, this loose filter may filter more records out than needed when > decorated with 'NOT' operator -- This message was sent by Atlassian JIRA (v6.3.4#6332)