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

GenerateTableFetch - Add attributes to generated flow files to ease SQL query overwrite

    Details

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

      Description

      The GenerateTableFetch processor will generate a SQL query based on the provided parameters but, if the specific DB adapter is not available, it might be necessary to overwrite the SQL query in the ExecuteSQL processor. To do that it would be nice to have each part of the query as attributes to take advantage of expression language.

      Current workaround (when using GenerateTableFetch against a DB2 database for example) is to have an intermediary ExtractText processor and have a regex extracting each part of the generated query.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                pvillard Pierre Villard
                Reporter:
                pvillard Pierre Villard
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: