- 在使用hive 需要配置元数据存储在mysql中,来解决不能多连接的问题
数据库的名称
1)不能含有" . "
2)不要以数字开始 - mysql中SQL语句与hive存在不同
比如经典员工部门问题:求部门薪资前几的人员信息
在MySQL中:
select dept.dname ,emp1.job ,emp1.sal
from db_hive.tb_dept dept join db_hive.tb_emp emp1
on dept.deptno=emp1.deptno
where(
select count(emp2.sal) as c_sal
from db_hive.tb_emp emp2
where
emp2.sal>emp1.sal and emp2.deptno=emp1.deptno and emp2.job =emp1.job
)<n
order by emp1.deptno,emp1.sal desc
在hive中就会报错:
FAILED: ParseException line 4:6 cannot recognize input near ‘select’ ‘count’ ‘(’ in expression specification