i am trying to transfer a CSV file to my data lab in Teradata. the file has 6 million rows. i have been getting an error saying unexpected Token. any idea how to fix the issue?
Unexpected token error comes when processing the input file, row by row, and finding unexpected column data. It can be that the File Option delimiters or line separator are set wrong or the data is bad, possibly the string delimiter?
Thanks. I know it's not the string delimiter. the file is huge and can't even open it in a text editor. any suggestion on how to check the file for errors?
Did you created the target table before loading or are you table creating while loading.check the file layouts?