question Re: How to set "Initial Max Value" for QueryDatabaseTable processor? in Archives of Support Questions (Read Only)

How to set "Initial Max Value" for QueryDatabaseTable processor?

pmalla — Mon, 20 Nov 2017 23:22:29 GMT

Hi Team,

I am new to Nifi. I just wanted to fetch all rows (3645000) from a SQL table. For this i wanted to provide initial value to the processor.

I have given this as below. but it is not taking. Can you please give me some example on it.

Initial Max Value = initial.3600000.{max_value_column}

Thanks in Advance.

Re: How to set "Initial Max Value" for QueryDatabaseTable processor?

Shu_ashu — Sun, 18 Aug 2019 04:44:20 GMT

@Paramesh malla

Try to change the dynamic property as

initial.maxvalue.<max-value-column-name> = 3600000

Example i tried below:-

In this processor i am giving initial value as 524 and my maximum value column name is dmacode.

Dynamic property i have added

Property name

initial.maxvalue.dmacode

Value

When we run the processor again it will fetch only the records after 524.

Re: How to set "Initial Max Value" for QueryDatabaseTable processor?

pmalla — Thu, 23 Nov 2017 19:26:42 GMT

@Shu, Thanks Shu. That worked.

Re: How to set "Initial Max Value" for QueryDatabaseTable processor?

srijitachaturve — Wed, 20 Mar 2019 13:45:07 GMT

@Shu will this work even if we have some state alraedy stored withing the processor? for eg: i have a timestamp (2019-03-17 02:00:00:0) stored in the state of my processor now i want the processor to start fetching data after 2019-03-20, will this property help in such scenario?