Teradata JDBC Fastloadcsv fails csv containing double quotes

Database
Highlighted
Enthusiast

Teradata JDBC Fastloadcsv fails csv containing double quotes

 
Hi,

 

I'm trying to figure out how to load a csv file using FASTLOADCSV option. The program works perfectly if my csv does not have double quotes around data values. The moment i get a csv file that contains double quotes around data values, the java code fails with all records going into the error table.

 

So a sample csv file with a record like this loads fine: A,B,C,D,E,F,G but a sample csv file with record like this fails: “A”,”B”,”C”,”D”,”E”,”F”,”G”

 

if i would be writing a fastload script using fastload unix utility, I can solve this issue with the statement: SET RECORD VARTEXT DELIMITER ',' QUOTE YES '"'; as mentioned in this post: https://community.teradata.com/t5/Database/fast-load-quotes-field/m-p/45783

 

But I don't know how to achieve this using Teradata JDBC in Java. 

 

Any assistance is greatly appreciated. 

 

Thank you

Suhail

1 REPLY
Teradata Employee

Re: Teradata JDBC Fastloadcsv fails csv containing double quotes

Hi Suhail,

We exchanged emails privately about this topic, but I'm responding here for the benefit of other folks who may run across this post.

 

JDBC FastLoad CSV does not currently support quoted field values. Our recommendation is to use a field separator that does not occur in any data value.