sqoop操作之HIVE导出到ORACLE

create table dept(
deptno int,
dname string,
loc string
)
row format delimited fields terminated by '	' lines terminated by '
' 
stored as textfile;

sqoop import --connect jdbc:oracle:thin:@192.168.1.107:1521:ORCL 
--username SCOTT --password tiger 
--table DEPT  
--hive-overwrite --hive-import  --hive-table dept 
--fields-terminated-by '	' --lines-terminated-by '
' 
-m 3;

insert overwrite directory '/user/hadoop/DEPT_HIVE_EXPORT' select * from dept;

create table DEPT_DEMO as select * from DEPT where 1=2;

sqoop export --connect jdbc:oracle:thin:@192.168.1.107:1521:ORCL 
--username SCOTT --password tiger 
--table DEPT_DEMO  
--export-dir /user/hadoop/DEPT_HIVE_EXPORT 
--fields-terminated-by ' 01'  
-m 2;