Revert the push down limit feature with aggregate on non-partition colum...

...n and order by
Also, the order by has to be sorting by all the grouping keys for pushing down the limit to be ok.