[
https://issues.apache.org/jira/browse/DRILL-4516?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Sudip Mukherjee updated DRILL-4516:
-----------------------------------
Affects Version/s: 1.4.0
> Transform SUM(1) query to COUNT(1)
> ----------------------------------
>
> Key: DRILL-4516
> URL: https://issues.apache.org/jira/browse/DRILL-4516
> Project: Apache Drill
> Issue Type: Improvement
> Components: Query Planning & Optimization
> Affects Versions: 1.4.0
> Reporter: Sudip Mukherjee
>
> If we connect drill with tableau we see some query requests like , select
> sum(1) tablename.
> This results in pulling all the records out of the underlying datasource and
> aggregate them to get row count.
> The behavior can be optimized if the query gets transformed into a count(1)
> query which is likely to be optimized at the datasource level
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
