Support Questions
Find answers, ask questions, and share your expertise

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

Contributor

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.

1 ACCEPTED SOLUTION

Accepted Solutions

Super Guru
@Paramesh malla

Try to change the dynamic property as

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

Example i tried below:-

43651-query.png

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

524

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

View solution in original post

3 REPLIES 3

Super Guru
@Paramesh malla

Try to change the dynamic property as

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

Example i tried below:-

43651-query.png

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

524

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

View solution in original post

@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?

Contributor

@Shu, Thanks Shu. That worked.