https://community.cloudera.com/t5/Support-Questions/Hive-problem-with-predicate-pushdown-in-subqueries-and-views/m-p/179405#M141651 <P>Hi <A rel="user" href="https://community.cloudera.com/users/43270/kebous.html" nodeid="43270">@Christian EL HAKIM</A>,</P><P>We also faced a similar issue and this approach helped me to push down subquery even having "WITH" clause. This even works in Hive 1.2.1</P><P><A href="https://stackoverflow.com/questions/13523049/hive-sql-find-the-latest-record" target="_blank">https://stackoverflow.com/questions/13523049/hive-sql-find-the-latest-record</A></P><P>The limitation is that this is</P><P>a) only useful for MAX logic.</P><P>b) We can't have the flexibility of having windowing different ORDERS, .ie. col1 desc, col2 asc, col3 desc etc</P><P>Thanks,</P><P>Sarath</P> Thu, 13 Sep 2018 06:22:55 GMT sarsasid 2018-09-13T06:22:55Z