Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

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.

Solved Go to solution
Highlighted

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.

New Contributor
 
1 ACCEPTED SOLUTION

Accepted Solutions

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.

Super Guru

@Faheem Shoukat

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,

64991-qdt.png

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

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

1 REPLY 1

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.

Super Guru

@Faheem Shoukat

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,

64991-qdt.png

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

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