Transform SUM(1) query to COUNT(1)

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