[ https://issues.apache.org/jira/browse/KYLIN-3206?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Billy Liu reassigned KYLIN-3206: -------------------------------- Assignee: Paul Lin (was: liyang) > Consider SQL expression aggregation when applying limit push down > ----------------------------------------------------------------- > > Key: KYLIN-3206 > URL: https://issues.apache.org/jira/browse/KYLIN-3206 > Project: Kylin > Issue Type: Bug > Components: Query Engine > Affects Versions: v1.6.0, v2.2.0 > Environment: Kylin 1.6.0 > Reporter: Paul Lin > Assignee: Paul Lin > Priority: Major > > SQLs like "select floor(user_level /10), sum(money) group by floor(user_level > /10) limit 10" should not trigger storage limit push down, because the > expressions like "floor(user_level /10)" are sort of post aggregations. > Otherwise Kylin would do aggregations based on partial records, producing > inaccurate results. > -- This message was sent by Atlassian JIRA (v7.6.3#76005)