nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ravisankar Mani <rrav...@gmail.com>
Subject Re: Dynamic property in QueryDatabaseTable
Date Fri, 09 Sep 2016 11:35:25 GMT
Hi Matt,

Sorry for this inconvenience. The dynamic property support from version
1.0.0.  Since, i am using 0.6.0 version.

Regards,
Ravisankar

On Fri, Sep 9, 2016 at 12:56 AM, Ravisankar Mani <rravimr@gmail.com> wrote:

> 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 <mattyb149@apache.org> 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 <rravimr@gmail.com>
>> 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
>>
>
>

Mime
View raw message