|
From: Sandeep G. <gup...@gm...> - 2013-10-16 19:39:26
|
Hi, In an another query that requires the result to be aggregated and ordered by a field (lets say timeo) the query planner currently pulls the results and then performs a sort with hash aggregate. The table at the datanodes are clustered by timeo. I was wondering if it possible for query planner to push down the order by clause at the datanode and then perform sort-merge aggregate at the coordinator. Surely, that would be a better query plan. We have tried enable_sort=off etc. but that doesn't work. Thanks. Sandeep |