Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

NIFI- CSV and Put Database Record - Invalid character between encapsulated token and delimiter

NIFI- CSV and Put Database Record - Invalid character between encapsulated token and delimiter

Hi,

I was able to load most of the data with putdatabase record. But few of the files fail with data exception as invalid character between the quote and delimiter.


|"COMPANION\SMALL ANIMAL RESIDEN"|"COMPANION\"


My assumption is \ is causing error. Is there any easy way to handle that in CSVReader inside PutDatabase processor? or do I need to do something else.


My quote character is " in csv reade r

My escape character is \


My assumption is since escape character is same as value present inside the column value, error is thrown. May I know how to resolve this?



Thanks,

Khaja

1 REPLY 1
Highlighted

Re: NIFI- CSV and Put Database Record - Invalid character between encapsulated token and delimiter

New Contributor

Hi,

I am also facing the same issue. If you found the solution could you please share ?

Thanks!

 

Don't have an account?
Coming from Hortonworks? Activate your account here