How 'Additional where Clause' property in Querydatabasetable can be used? i am not able to find correct property name ...it would be helpful if someone can share example. i am using QueryDatabaseTable 1.3.0.

faheem_shoukat — Tue, 03 Apr 2018 17:24:11 GMT

Re: How 'Additional where Clause' property in Querydatabasetable can be used? i am not able to find correct property name ...it would be helpful if someone can share example. i am using QueryDatabaseTable 1.3.0.

Shu_ashu — Sun, 18 Aug 2019 05:33:02 GMT

Additional Where Clause property has been introduces from NiFi 1.4.0+ versions of NiFi, As you are using NiFi 1.3.0 that's the reason why you are not able to find the Additional where clause property in your QuerydatabaseTable processor.

Possible ways to achieve where clause functionality:-

You can upgrade your NiFi instance to newer versions

(or)

Use Execute Sql processor(add where clause in your query), store the state in hive/hbase and pull the state again for incremental run using Execute Sql processor

(or)

Use combination of GenerateTableFetch(supports additional Where clause property) + RemoteProcessorGroup + ExecuteSql processors to achieve where clause property.

NiFi 1.4 Querydatabase table processor configs:-

once you have nifi 1.4 version then click on configure on QueryDatabase table processor you are going to have Additional Where clause property,

Below is the reference link for Jira ticket addressing about additional where clause property.

https://issues.apache.org/jira/browse/NIFI-4257

question Re: How 'Additional where Clause' property in Querydatabasetable can be used? i am not able to find correct property name ...it would be helpful if someone can share example. i am using QueryDatabaseTable 1.3.0. in Archives of Support Questions (Read Only)

How 'Additional where Clause' property in Querydatabasetable can be used? i am not able to find correct property name ...it would be helpful if someone can share example. i am using QueryDatabaseTable 1.3.0.

Re: How 'Additional where Clause' property in Querydatabasetable can be used? i am not able to find correct property name ...it would be helpful if someone can share example. i am using QueryDatabaseTable 1.3.0.