NiFi - Error with PutDatabaseRecord while upsert with one column

Viewed 515

I'm trying to insert or update table based on a unique key. But PutDatabaseRecord processor is throwing error: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression

However no error is thrown with multiple columns. This error is only with one column

Simple User table with id(PK) and name columns.

Here is my PutDatabaseRecord config:

PutDatabaseRecord config image

Here is my JSONTreereader: JSONTreereader config image

Please help me with this issue

0 Answers
Related