HIVE操作命令
测试文件:
链接:https://pan.baidu.com/s/1mSFvrenlKxfDK7pa3hsTpA
提取码:kbek
01.找出最高领导人(KING)(emp)所在位置(loc)
select l.loc_name from emp e
> join dept d
> on e.deptno=d.deptno
> join location l
> on d.loc=l.loc
> where job="PRESIDENT";
02.获取emp工资前三名。工资包括sal,comm
select sal+nvl(comm,0) s from emp order by s asc limit 3;
03.对每个部门的最高工资进行排序
select * from (select max(sal+nvl(comm,0)) s from emp group by deptno) a order by s desc;