Hi @Christian EL HAKIM, 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 https://stackoverflow.com/questions/13523049/hive-sql-find-the-latest-record The limitation is that this is a) only useful for MAX logic. b) We can't have the flexibility of having windowing different ORDERS, .ie. col1 desc, col2 asc, col3 desc etc Thanks, Sarath ... View more

Hi @Ryan Tomczik 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 https://stackoverflow.com/questions/13523049/hive-sql-find-the-latest-record The limitation is that this is a) only useful for MAX logic. b) We can't have the flexibility of having windowing different ORDERS, .ie. col1 desc, col2 asc, col3 desc etc Thanks, Sarath ... View more