sqoop数据迁移脚本（导入，导出 mysql,oracle等）

1.oracle导入到hive脚本

/home/sqoop/sqoop-1.4.7.bin__hadoop-2.6.0/bin/sqoop  import

--username admin

--password '123XXX'

--connect jdbc:oracle:thin:@192.168.12X.1X:1521/数据库名

--fields-terminated-by '\001'

--null-non-string '\\N'

--null-string '\\N'

--delete-target-dir

--target-dir /hdfs/tmp/data/tablename

--hive-drop-import-delims

--query "select id,name,age from LL_test where 1=1 AND \$CONDITIONS"

--split-by id -m 1;

2.hive导出数据到mysql

/home/sqoop/sqoop-1.4.7.bin__hadoop-2.6.0/bin/sqoop  export

-Dorg.apache.sqoop.export.text.dump_date_on_error=true

--username admin

--password '123XXX'

--connect jdbc:mysql://192.168.12X.1X:3306/数据库名

--input-fields-terminated-by '\001'

--null-non-string '\\N'

--null-string '\\N'

--input-null-non-string '\\N'

--table LL_test

--export-dir /hdfs/tmp/data/tab