sqoop语句为
sqoop export \
--connect jdbc:oracle:thin:@(description=(address=(protocol=tcp)(port=1521)(host=172.18.50.5))(connect_data=(service_name=rac))) \
--username dsp \
--password rac \
--table DSP.S_F_TKFTIS_ORDER_HIS \
--export-dir /user/hive2/warehouse/dml.db/dml_s_f_tkftis_order_his \
--columns L_SERIALNO,C_FLAG,C_ACCOTYPE,C_ACCO,C_TYPE,L_SERVICEID,C_MODE,D_DATE,C_ISACCO,C_FROM,C_USERCODE,D_SERVICEEND,D_SERVICESTART \
--input-fields-terminated-by '\001' \
--input-null-string '\N' \
--input-null-non-string '\N'
目标表结构
create table S_F_TKFTIS_ORDER_HIS
(
l_serialno VARCHAR2(40),
c_flag CHAR(1),
c_accotype CHAR(1),
c_acco VARCHAR2(40),
c_type CHAR(1),
l_serviceid VARCHAR2(40),
c_mode CHAR(1),
d_date VARCHAR2(40),
c_isacco CHAR(1),
c_from CHAR(1),
c_usercode VARCHAR2(16),
d_serviceend VARCHAR2(40),
d_servicestart VARCHAR2(40)
)
tablespace DSP_DATA
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64K
next 1M
minextents 1
maxextents unlimited
);
如果我把oracle目标表字段都改为varchar则可以正常导入,如果字段类型有date则不成功,求大神帮忙看看什么原因。