-Re: Review Request 22752: HIVE-7063: Optimize for the Top N within a Group use case
yes we can push lead. have added a comment explaining this.
for rank, drank, lead we only need to consider rows before current row, so window doesn't matter. Also for rank/drank window is not allowed.
Yes this is not an issue because today limit doesn't get pushed past PTF. If we do push past limit then as you pointed out it would still get applied in a manner similar to a rank predicate.
This is an automatically generated e-mail. To reply, visit:
On June 18, 2014, 8:40 p.m., Harish Butani wrote: