HIVE 常用操作

查看看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;