hive分页

SELECT
	*
FROM
	(
		SELECT
			row_number () over (ORDER BY class_sort_number) AS rnum,
			c.*
		FROM
			ods_common_class c
		WHERE
			DAY = '2018-08-22'
		AND school_id = '13400'
	) t
WHERE
	rnum > 1 AND rnum < 10;