Pushdown the limit if possible(group by partition column); Fix the queri...

...es that should not push down limit
I did not realize that we would push down the order by AND keep a copy of the order by at the coordinator.
We are smarter than I thought. This change is ok to merge.