Created on 05-09-2019 03:48 PM - edited 08-17-2019 03:32 PM
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.
Thanks in advance.
Created 05-11-2019 03:17 AM
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.