[ 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)