Sudip Mukherjee created DRILL-4516:
--------------------------------------
Summary: 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
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)
