You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@nifi.apache.org by "Pierre Villard (JIRA)" <ji...@apache.org> on 2017/03/14 13:22:41 UTC

[jira] [Created] (NIFI-3596) GenerateTableFetch - Add attributes to generated flow files to ease SQL query overwrite

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)