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)