Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-4522

Add "SQL Statement" property to PutSQL

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.5.0
    • Component/s: Extensions
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                mattyb149 Matt Burgess
                Reporter:
                mattyb149 Matt Burgess
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: