Shot Read in Seq File
Posted: Tue Aug 07, 2007 12:54 am
Hi all, trying to read a fixed with seq file but i am getting a message which says short read encountered. i know one of the problems can be the file not fixed d.. but i dont think its the same case here as i have managed to read the same file in the server edition without any trouble.
i am setting the fixed width property in the col definition = width of the field in the file definition.
File Definition:
field_name field_length Field_type
1 account_id 12 char
2 account_status_cd 1 char
3 credit_card_type_cd 1 char
4 Cc_holder_nm 45 char
5 Cc_holder_ssn 9 char
6 Language_preference cd 1 integer
7 Work phone 10 char
8 Home phone 10 char
9 street address 50 char
10 city nm 25 char
11 state cd 2 char
12 zip cd 5 integer
13 Balance amt 9 integer
14 open dt 8 char
15 expire dt 8 char
16 credit limit amt 9 integer
17 last payment dt 8 char
18 last--payment amt 9 integer
19 annual--percentage rate 6 integer
20 annual fee amt 7 integer
Dummy Data:
699991267250AV Ivan Ge388425101143953563022008435087 41 Eighth Avenue AlexandriaVA10020 01999010720040106 3600019990401 12 12 20 14 847110
863449393669CV Buren Euarchukiati683547240232312662436718056826 995 Second Street ClevelandOH10016 01999050520040423 4400019990502 48 20 20 163505100
743059146348AM Alcus Draband523371327124460956331357733655 771 Varick Street ArlingtonVA10032 01999011620040304 1000019990203 61 13 20 151937000
788397786674AM Manuel Bukhina582202775312333733057697443492 253 Ninth Avenue BerkeleyCA10024 01999052920040530 2000019990102 108 12 20 122533100
572236865104AV Aboelray Esaco300768423161248085726882073687 288 Seventh Avenue ArlingtonTX10012 01999010920040306 2200019990203 101 14 20 112947100
108512631528AM Krysta Ilabouni275469519168968805341678411702 629 Third Avenue ChesapeakeVA10014 01999042720040213 4900019990510 173 13 20 183021100
cheerz !
i am setting the fixed width property in the col definition = width of the field in the file definition.
File Definition:
field_name field_length Field_type
1 account_id 12 char
2 account_status_cd 1 char
3 credit_card_type_cd 1 char
4 Cc_holder_nm 45 char
5 Cc_holder_ssn 9 char
6 Language_preference cd 1 integer
7 Work phone 10 char
8 Home phone 10 char
9 street address 50 char
10 city nm 25 char
11 state cd 2 char
12 zip cd 5 integer
13 Balance amt 9 integer
14 open dt 8 char
15 expire dt 8 char
16 credit limit amt 9 integer
17 last payment dt 8 char
18 last--payment amt 9 integer
19 annual--percentage rate 6 integer
20 annual fee amt 7 integer
Dummy Data:
699991267250AV Ivan Ge388425101143953563022008435087 41 Eighth Avenue AlexandriaVA10020 01999010720040106 3600019990401 12 12 20 14 847110
863449393669CV Buren Euarchukiati683547240232312662436718056826 995 Second Street ClevelandOH10016 01999050520040423 4400019990502 48 20 20 163505100
743059146348AM Alcus Draband523371327124460956331357733655 771 Varick Street ArlingtonVA10032 01999011620040304 1000019990203 61 13 20 151937000
788397786674AM Manuel Bukhina582202775312333733057697443492 253 Ninth Avenue BerkeleyCA10024 01999052920040530 2000019990102 108 12 20 122533100
572236865104AV Aboelray Esaco300768423161248085726882073687 288 Seventh Avenue ArlingtonTX10012 01999010920040306 2200019990203 101 14 20 112947100
108512631528AM Krysta Ilabouni275469519168968805341678411702 629 Third Avenue ChesapeakeVA10014 01999042720040213 4900019990510 173 13 20 183021100
cheerz !