Hi Matt, Thanks for your reply. I can add the new property like initial.maxvalue.id and set the value(Like 1) using add property option in this processor. But i can see the error message like " 'initial.maxvalue.id' validated against '1' is invalid because 'initial.maxvalue.id' is not a supported property " . May be i have added the dynamic property in wrong way. Can you please help me to resolve the problem?
Thanks, Ravisankar On Thu, Sep 8, 2016 at 8:43 AM, Matt Burgess <[email protected]> wrote: > Ravisankar, > > The dynamic property needs to have a certain name, in general of the > form initial.maxvalue.{max_value_column}. So if you have a max value > column called last_updated, you will want to add a dynamic property > called initial.maxvalue.last_updated, and you set the value to > whatever you want the initial value to be. At that point the processor > will only fetch rows where last_update > the value you specified. > > Regards, > Matt > > On Thu, Sep 8, 2016 at 8:31 AM, Ravisankar Mani <[email protected]> wrote: > > Hi All, > > > > I have used 'QueryDatabaseTable' processor in my workflow(incremental > update > > ETL process), initially , Its working properly once executed the job > without > > setiing max value column(first time only) and then setting the max value > > columns(because the max value doesn't know processor) . But i need to > set > > the max value column initially , in this case , i saw the dynamic > property > > like 'Initial Max Value' in nifi guide. But i don't know how to set the > > property in this processor. > > Can you please help me to resolve the problem? > > > > > > Regards, > > Ravisankar >
