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.

which condition gets priority while fetching data in querydatabase processor in nifi,value stored in max value columns or additional where clause given?

which condition gets priority while fetching data in querydatabase processor in nifi,value stored in max value columns or additional where clause given?

New Contributor

Hi,@mattclarke,@markpayne am using a "timestamp" column as max value column in querydatabase processor.The processor has some state stored for incremental fetch, now when i give a where clause on the same timestamp column,querydb processor brings duplicate data if the where clause date is smaller than the initial state value.I want to know does both of the conditions work in "and" or "or" and should i always give where condition date greater than the initial state value stored by the processor.