sqlldr userid=apsq/apsq control=d:/people_imp/20161010153035.ctl log=d:/people_imp/FP_PKRKMD.log
OPTIONS (skip=1,rows=128)
LOAD DATA
characterset ZHS16GBK
INFILE "/home/hadoop/people_bank/database/FP_PKRKMD20161009.csv"
truncate
INTO TABLE FP_PKRKMD_IMP
Fields terminated by ','
Optionally enclosed by '"'
trailing nullcols
(
SJBM,
MSHENG,
MSHI,
MXIAN,
MXIANG,
MCUN,
HZXM,
HBH "SUBSTR(:HBH,2,LENGTH(:HBH))",
YHZGX,
PKHSX,
TPZT,
HZZJHM "SUBSTR(:HZZJHM,2,LENGTH(:HZZJHM))",
CYXM,
CYZJHM "SUBSTR(:CYZJHM,2,LENGTH(:CYZJHM))",
ETL_DT "EXTRACT(YEAR FROM SYSDATE)"
)
insert --为缺省方式,在数据装载开始时要求表为空
append --在表中追加新记录
replace --删除旧记录(用 delete from table 语句),替换成新装载的记录
truncate --删除旧记录(用 truncate table 语句),替换成新装载的记录
java+Oracle Sqlload 大数据
最新推荐文章于 2021-04-10 21:18:13 发布