Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive, mail # dev - Review Request 22752: HIVE-7063: Optimize for the Top N within a Group use case


Copy link to this message
-
Re: Review Request 22752: HIVE-7063: Optimize for the Top N within a Group use case
Harish Butani 2014-06-30, 01:41

done

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.

done

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.
- Harish
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/22752/#review46935
On June 18, 2014, 8:40 p.m., Harish Butani wrote: