Matt Burgess created NIFI-4522:
----------------------------------

             Summary: Add "SQL Statement" property to PutSQL
                 Key: NIFI-4522
                 URL: https://issues.apache.org/jira/browse/NIFI-4522
             Project: Apache NiFi
          Issue Type: Improvement
          Components: Extensions
            Reporter: Matt Burgess


Currently the PutSQL processor expects the SQL statement to be executed to be 
in the contents of the incoming flow file(s). However there is a use case from 
a Simple Event Processing perspective; when you have a flowfile whose contents 
you want to keep, but because that flow file came through (presumably with some 
attributes of interest), you want to issue a SQL statement (perhaps to update 
an external DB with some status/metrics info).

Adding a non-required, expression-language-supported, default-empty property 
called SQL Statement would allow both use cases; it preserves existing behavior 
by default, but provides the ability to issue an external command while 
retaining the current flow file contents.



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)

Reply via email to