question Add option clause OPTION(hash join) to QueryDatabaseTable Nifi Processor in Archives of Support Questions (Read Only)

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

younes_kafi — Wed, 27 Jul 2016 21:27:45 GMT

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.

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

mburgess — Thu, 28 Jul 2016 00:31:25 GMT

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?

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

younes_kafi — Thu, 28 Jul 2016 17:11:06 GMT

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.