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

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

PutSQL is convenient, but one flow file must be created for each record, which 
is a waste of resources for bigdata applications.

A typical use case would be to do some batch upserts statements on a phoenix 
cluster. We used PutSQL for this, but the overall performance wasn't 
satisfactory.

> 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