hive 多表查询,转化为一个mapreduce的作业
hive>desc dept;
deptno double
dname string
loc string
hive>desc emp;
empno double
ename string
job string
mgr double
hiredate string
sal double
comm double
deptno double
hive>desc salgrade;
grade double
losal double 工资下限
hisal double
hive>desc dept;
deptno double
dname string
loc string
hive>desc emp;
empno double
ename string
job string
mgr double
hiredate string
sal double
comm double
deptno double
hive>desc salgrade;
grade double
losal double 工资下限
hisal double