查看看hive表格存储位置的命令：
show create table tablename;
通过 row_number()进行分页查询；
select * from (select row_number() over (order by size desc) as rnum, size from table_fileattr20180627)t where rnum >= 11 and rnum<=20;
