kinit -kt /var/lib/hue/hue.keytab hue
sqoop import
-D mapred.job.queue.name=root.etl.ld
-D org.apache.sqoop.splitter.allow_text_splitter=true
--connect jdbc:oracle:thin:@$1:$2:$3
--username $4
--password $5
--query "SELECt
C_IDEN,
C_IDEN_RELA,
C_SEC_CODE,
C_SEC_CODE_TAG,
N_TD_AMOUNT,
C_TD_TYPE,
D_UPDATE_INFO
FROM V45HRXT.T_D_AC_TRADE_ZYW
WHERe $CONDITIONS"
--target-dir /user/hive/warehouse/ld.db/fa45_t_d_ac_trade_zyw
--split-by C_IDEN
--fields-terminated-by ' 01'
--delete-target-dir
--hive-drop-import-delims
--mapreduce-job-name sqoop_fa45_t_d_ac_trade_zyw
--num-mappers 1
--null-string '\N'
--null-non-string '\N'
--as-textfile
