sqoop export报错Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

sqoop export报错Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]

sqoop export报错如下：
Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Timestamp.java:204)
at GSCLIENTPERSON.__loadFromFields(GSCLIENTPERSON.java:893)
Caused by: java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd hh:mm:ss[.fffffffff]
at java.sql.Timestamp.valueOf(Timestamp.java:237)
at GSCLIENTPERSON.__loadFromFields(GSCLIENTPERSON.java:991)


从hdfs导出数据到oracle数据库
排查步骤如下：
1.字段错位问题
hdfs数据与oracle字段顺序是否匹配
2.脚本null值如何处理
--input-null-string '' \
--input-null-non-string '' \
3.是否存在脏数据
select CLIENTCODE,BIRTHDATE from GSCLIENTPERSON where BIRTHDATE like '%10007%';
clientcode     birthdate
I0000131117     10007-06-07 00:00:00

oracle建表语句：
birthdate date