I m trying to read a huge CSV file. Got following error. Any help how to fix this.
Please suggest what settings i need to change.
##E IIS-DSEE-TOIX-00158 23:00:10(000) <Sequential_File_Read,0> Error reading on import.
>##E IIS-DSEE-TFRS-00061 23:00:10(001) <Sequential_File_Read,0> Consumed more than 100,000 bytes looking for record delimiter; aborting
>##E IIS-DSEE-TOIX-00179 23:00:10(002) <Sequential_File_Read,0> Import error at record 0.
>##E IIS-DSEE-TFOR-00089 23:00:10(003) <Sequential_File_Read,0> The runLocally() of the operator failed.
ERROR Reading source csv file
Moderators: chulett, rschirm, roy
Same answer but it could be specific to a portion of the file, as in the file is corrupted. Or perhaps whatever you are doing to create the smaller file adds the appropriate delimiter. There's no way for us to know.
We can't see your file and you haven't shared any of the settings you are using, so not much anyone can do but guess.
We can't see your file and you haven't shared any of the settings you are using, so not much anyone can do but guess.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers