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

Allow ExecuteSQL to use flow file content as SQL query

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 1.0.0, 0.7.0, 1.0.0-Beta
    • Component/s: None
    • Labels:
      None

      Description

      Currently the SQL SELECT query used by ExecuteSQL is specified by a required processor property. This property does accept Expression Language (EL), so it is possible if the query is in the flow file contents, that an ExtractText processor could be used to put the query in an attribute, then the Select Query property in ExecuteSQL could reference the attribute using Expression Language.

      However that seems like an unnecessary extra step, especially when users have data flows that generate SQL statements, or when their flow accepts files containing SQL statements.

      An improvement to the ExecuteSQL processor could be to make the Select Query property not required, and if it is empty, the contents of the flow file will be used as the query value.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: