Support Questions

Find answers, ask questions, and share your expertise
Announcements
Celebrating as our community reaches 100,000 members! Thank you!

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

avatar
Explorer

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.

1 ACCEPTED SOLUTION

avatar
Master Guru

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?

View solution in original post

2 REPLIES 2

avatar
Master Guru

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?

avatar
Explorer

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.