jiangxz created SQOOP-1860:
------------------------------
Summary: it's faill to export the data in HDFS to realtionship
database(DB2),can anyone help me?
Key: SQOOP-1860
URL: https://issues.apache.org/jira/browse/SQOOP-1860
Project: Sqoop
Issue Type: Test
Reporter: jiangxz
I got a problem when i export the data in HDFS to realtionship database(DB2),it
occurs a error,it can't parse the input data '3560215444544x',what's the
reason?here is my sqoop statements:
sqoop export \
--connect jdbc:db2://10.0.131.95:50000/data15 \
--username db2inst1 \
--password db2inst1 \
--table db2inst1.ci_per_baseinfo_2 \
--columns '
CustNo ,
SrcSys ,
ChName ,
ChPinyin ,
EnName ,
OldName ,
CustSex ,
CustNationality ,
CustCerType ,
CertificateNo ,
EffectiveDate ,
GrantCertificateOrg ,
ChBornDate ,
BornDate ,
Age ,
LiveSituation ,
HouseStiuation ,
Village ,
TrafficTool ,
BuyCarBrand ,
BuyCarDate ,
CuyCarAge ,
YearInspection ,
Nation ,
Native ,
AdministrationArea ,
PoliticalAffiliation ,
MaritalStatus ,
MarriageRegDate ,
HighestEducation ,
HighestDegree ,
GraduateInstitute ,
GraduateDate ,
WorkExperience ,
Liking ,
Taboo ,
Constellation ,
Health ,
Smoke ,
SmokeLike ,
Drink ,
DrinkLike ,
Weight ,
Zodiac ,
Shape ,
Height ,
ContractLikeTime ,
VisitFrequency ,
CustSrc ,
Belief ,
CommunityPosition ,
CustType ,
CustTrade ,
Occupation ,
Position ,
ProfessionalTitle ,
CountryOccupationTiltle ,
StakeAmount ,
StakeCerNo ,
LoanCrdNo ,
CustManager ,
BrtCod ,
References ,
Dtadat
' \
--export-dir /user/hive/warehouse/hive.db/ci_per_baseinfo \
--input-null-non-string '\\N' \
--input-null-string '\\N' \
--input-fields-terminated-by '\001'
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
