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.
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.
