hive实现分页
SELECT
*
FROM
( SELECT row_number() over ( ORDER BY xx ) AS rnum, TABLE.* FROM TABLE ) t
WHERE
rnum BETWEEN 1 AND 10;
hive实现分页
SELECT
*
FROM
( SELECT row_number() over ( ORDER BY xx ) AS rnum, TABLE.* FROM TABLE ) t
WHERE
rnum BETWEEN 1 AND 10;