ql/src/test/queries/clientpositive/order2.q

--! qt:dataset:src
set hive.mapred.mode=nonstrict;
set hive.optimize.ppd=true;

SELECT subq.key, subq.value FROM 
(SELECT x.* FROM SRC x ORDER BY key limit 10) subq
where subq.key < 10;