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.

PutDataBaseRecord does not insert any record when one of them already exists in the database

PutDataBaseRecord does not insert any record when one of them already exists in the database

Explorer

Hi everybody, please help!

I'm working in NIFI with PutDataBaseRecord to insert the data of a csv file to a database table. Everything goes well in the first execution because there is no data in the table. Then I modify the file so it contains new records and existing ones. PutDataBaseRecord fails because of existing records (primary key constraint) but it doesn´t insert the new records.

Is there any way to configure the processor to instruct it to insert the new records and ignore the ones that failed?

I attached pictures how my processor is configured.

108558-flow.jpg

108566-putdatabaserecord.jpg

Thanks in advance.

1 REPLY 1
Highlighted

Re: PutDataBaseRecord does not insert any record when one of them already exists in the database

The above was originally posted in the Community Help track. On Sat May 11 03:14 UTC 2019, the HCC moderation staff moved it to the Data Ingestion & Streaming track. The Community Help track is appropriate for questions about using the HCC site itself.

Bill Brooks, Community Manager
Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Don't have an account?
Coming from Hortonworks? Activate your account here