[ 
https://issues.apache.org/jira/browse/NIFI-7748?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17308936#comment-17308936
 ] 

DEOM Damien commented on NIFI-7748:
-----------------------------------

Hi

Good to hear that UPSERT statement was added !

I nevertheless find that the record writer option would cover useful cases like:
 

INSERT INTO table (...) VALUES (...) ON DUPLICATE KEY UPDATE ...

> PutDatabaseRecord: Add an optional record writer: FreeFormRecordWriter 
> -----------------------------------------------------------------------
>
>                 Key: NIFI-7748
>                 URL: https://issues.apache.org/jira/browse/NIFI-7748
>             Project: Apache NiFi
>          Issue Type: Improvement
>            Reporter: DEOM Damien
>            Priority: Major
>
> The PutDatabaseRecord processor should allow the user to create custom 
> queries more easily.
> The FreeFormRecordWriter is very convenient, and could be added as an option 
> (as a replacement for the very obscure 'SQL' statement.type)



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

Reply via email to