Hi, I was trying to do a rownum simulation (the way we do it MySQL) using drill. Trying to get results from the below query, but to no avail so far. Any suggestions from anyone? My intent is to read a part of a table (or a file) based on rownum. SELECT a.*
FROM
(
SELECT @rownum := @rownum + 1 AS rownum, mytable.*
FROM <table name or file name> mytable
) a
where a.rownum >100 and
a.rownum<110;
Thanks,Ganesh
