sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "jiangxz (JIRA)" <j...@apache.org>
Subject [jira] [Created] (SQOOP-1860) it's faill to export the data in HDFS to realtionship database(DB2),can anyone help me?
Date Tue, 09 Dec 2014 01:30:13 GMT
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)

Mime
View raw message