Paul Lin created KYLIN-3206:
-------------------------------
Summary: 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: v2.2.0, v1.6.0
Environment: Kylin 1.6.0
Reporter: Paul Lin
Assignee: liyang
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)
