Sqoop import/export from/to Oracle

a:Sqoop import-export from-to Oracle

Sqoop import/export from/to Oracle 

file structure

1212    John     Smith     Accountant
1213    Brian    Pitt      Economist
\\N     \\N      \\N       \\N
.....
.....
8823    Oliver   Hoff      Programmer

option.par

--connect
jdbc:oracle:thin:@//10.0.0.24:1521/test
--username
username1
--password
password1
--table
EMPLOYEE_REPORTING.EMPLOYEE
--fields-terminated-by 
\t
--class-name
com.example.reporting.Employee
--verbose
--split-by
ID
--where
ID <= 100000
--target-dir
/user/ambari_qa/reporting/input
-m
8

sqoop-export-cmd

sqoop export \
--connect jdbc:oracle:thin:@//10.0.0.24:1521/test \
--username username1 \
--password password1 \
--table EMPLOYEE_REPORTING.EMP_RECORD \
--export-dir /apps/hive/warehouse/emp_record \
--input-fields-terminated-by "\t" \
--input-lines-terminated-by "\n" \
--verbose \
-m 8 \
 --input-null-string '\\N' \
 --input-null-non-string '\\N'

sqoop-import-cmd

sqoop import --connect jdbc:oracle:thin:@//10.0.0.24:1521/test \
--username username1 \
--password password1 \
--table EMPLOYEE_REPORTING.EMPLOYEE --fields-terminated-by \t
--class-name com.example.reporting.Employee \
--verbose --split-by ID \
--where 'ID <= 100000' \
--target-dir /user/ambari_qa/reporting/input -m 8