hive数据的导入
使用sqoop导入oracle数据到HDFS中
import –connect jdbc:oracle:thin:@192.168.56.101:1521:orcl –username scote –password tiger –table emp –columns ‘empno,ename,job,sal,deptno’ -m 1 –target-dir ‘/sqoop/emp’
使用sqoop导入oracle数据到hive中(没有指定表名)
import –hive-import jdbc:oracle:thin:@192.168.56.101:1521:orcl –username scote –password tiger –table emp -m 1 –columns ‘empno,ename,job,sal,deptno’
使用sqoop导入oracle数据到hive中(指定表名,如果emp1不存在会自动创建)
import –hive-import jdbc:oracle:thin:@192.168.56.101:1521:orcl –username scote –password tiger –table emp -m 1 –columns ‘empno,ename,job,sal,deptno’ –hive-table emp1
使用sqoop导入oracle数据到hive中,并使用where条件
import –hive-import jdbc:oracle:thin:@192.168.56.101:1521:orcl –username scote –password tiger –table emp -m 1 –columns ‘empno,ename,job,sal,deptno’ –hive-table emp2 –where ‘deptno=10’
使用sqoop导入oracle数据到hive中,并使用查询语句
import –hive-import jdbc:oracle:thin:@192.168.56.101:1521:orcl –username scote –password tiger -m 1 –query ‘select * from emp where sal<2000 and $CONDITIONS’ –target-dir ‘/sqoop/emp5’ –hive-table emp5
hive数据的导出
- 使用sqoop将hive中的数据导出到oracle中(oracle表要先创建并且列要相同)
export –connect jdbc:oracle:thin:@192.168.56.101:1521:orcl –username scote –password tiger -m 1 –table myemp –export-dir ……
- 使用sqoop将hive中的数据导出到oracle中(oracle表要先创建并且列要相同)
Hive常用数据导入导出总结
最新推荐文章于 2024-07-27 11:00:39 发布