oracle sqoop hdfs 示例

sqoop export \
--connect jdbc:oracle:thin:@121.36.164.xxx:1521:HELOWIN \
--username test1 \
--password test1 \
--fields-terminated-by '\t' \
--table TEST1.STUDENT \
--export-dir /user/hive/warehouse/oracle_test_ddfd.db/student \
--input-fields-terminated-by '\t' \
--update-mode allowinsert \
--update-key STUID \
--mapreduce-job-name 'export-test' \
--input-null-string '\\N' \
--input-null-non-string '\\N' \
-m 1

sqoop import \
--connect jdbc:oracle:thin:@121.36.164.xxx:1521:helowin \
--username test \
--password test \
--fields-terminated-by '\t' \
--query "select STUID ,STUNAME ,GENDER ,AGE ,JOINDATE ,CLASSID ,ADDRESS from TEST1.STUDENT where \$CONDITIONS " \
--target-dir "/user/hive/warehouse/oracle_test_ddfd.db/student_temp/" \
--delete-target-dir \
--split-by STUID \
--null-string '\\N' \
--null-non-string '\\N' \
--hive-drop-import-delims  \
--mapreduce-job-name 'oracle-test' \
-m 16

load data inpath '/user/hive/warehouse/oracle_test_ddfd.db/student_temp/part*' overwrite into table oracle_test_ddfd.student