Add option clause OPTION(hash join) to QueryDatabaseTable Nifi Processor

[#1]

Hello,

Is there a way to add an option clause like 'OPTION(hash join)' while performing an incremental import using QueryDatabaseTable Nifi Processor ?

The goal of this is to optimize the query that will be executed in sql server by Nifi.

Thanks in advance.

[#2 · Accepted solution]

It is certainly worth considering the addition of various clauses to be added to the QueryDatabaseTable (and soon, the GenerateTableFetch) processors. We will also have to consider whether the various drivers (Oracle, MySQL, Postgres, etc.) support such notation (or some variant), and how to handle the clauses if the database type does not support them. Do you mind filing a Jira case for this improvement?

[#3]

Hi Matt,

Thank you for your reply, I have created a jira for that : https://issues.apache.org/jira/browse/NIFI-2416

Please tell me if you have any recommendation about it.