[
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)