- Subscribe to RSS Feed
- Mark Question as New
- Mark Question as Read
- Float this Question for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
How to set "Initial Max Value" for QueryDatabaseTable processor?
- Labels:
-
Apache NiFi
Created 11-20-2017 03:22 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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.
Created on 11-20-2017 04:16 PM - edited 08-17-2019 09:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
524
When we run the processor again it will fetch only the records after 524.
Created on 11-20-2017 04:16 PM - edited 08-17-2019 09:44 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
524
When we run the processor again it will fetch only the records after 524.
Created 03-20-2019 06:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@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?
Created 11-23-2017 11:26 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
@Shu, Thanks Shu. That worked.
