Pierre Villard created NIFI-3596: ------------------------------------ Summary: GenerateTableFetch - Add attributes to generated flow files to ease SQL query overwrite Key: NIFI-3596 URL: https://issues.apache.org/jira/browse/NIFI-3596 Project: Apache NiFi Issue Type: Improvement Components: Extensions Reporter: Pierre Villard Assignee: Pierre Villard Priority: Trivial
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. -- This message was sent by Atlassian JIRA (v6.3.15#6346)