Hi thanx a lote for the responce,
according to my job, am having a seq file as i said it clearly ..that am reading a xml file . this reads as a single coloumn. and the xml input stage will parse in to diff coloumns.
so am getting this error in the initial stage ..tht is seq stage .that have only one column.
Missing record delimiter "\n", saw EOF instead
Moderators: chulett, rschirm, roy
Change the Char data type to Varchar.
As character Datatype might expect the fixed size character for the defined length. Since you input seems variable length, there is a chance where new line character may come even before the defined length.
As character Datatype might expect the fixed size character for the defined length. Since you input seems variable length, there is a chance where new line character may come even before the defined length.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
I've checked all the threads for an answer but i do not see one. I have the same issue . I had one job which was working with no issues couple of days back now i try to view the data it shows the same error. First thing, i was getting this from another job which i was developing today so i just went to check the old job it started throwing same warning . What could be the reason ?
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 21
- Joined: Sat Sep 08, 2007 12:04 am
- Location: bangalore
-
- Premium Member
- Posts: 87
- Joined: Sat Jul 14, 2007 2:24 pm
I had the same warning ("Missing record delimiter "", saw EOF instead") while reading from HDFS with BDFS stage.
Changing the "Final delimiter =none" or "=end" didn't help.
When I converted the files from DOS format to UNIX format I stopped getting this error (BDFS stage doesn't have the option to choose DOS/Unix format like in seq file).
Changing the "Final delimiter =none" or "=end" didn't help.
When I converted the files from DOS format to UNIX format I stopped getting this error (BDFS stage doesn't have the option to choose DOS/Unix format like in seq file).
I also faced the same issue. Below 2 points made my job successfully finish without any warnings:
1) My file should follow the below format. Instead of Case2, follow Case1:
Case 1
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
|
Case 2
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB|
2) Since my file was of DOS format, I made my format tab settings look like:
Final Delimiter - none
Record Delimiter String - DOS format
Thanks!
1) My file should follow the below format. Instead of Case2, follow Case1:
Case 1
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
|
Case 2
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB
ABCTTTAAAABBB|
2) Since my file was of DOS format, I made my format tab settings look like:
Final Delimiter - none
Record Delimiter String - DOS format
Thanks!
Vaibhav