nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Austin Duncan <adun...@pyaanalytics.com>
Subject Re: Stateful
Date Tue, 06 Feb 2018 14:33:19 GMT
I am not sure if thats what i need. My query is pretty robust and i am not
sure if it will be able to be implemented in that

On Tue, Feb 6, 2018 at 9:30 AM, James Wing <jvwing@gmail.com> wrote:

> Austin,
>
> Have you tried QueryDatabaseTable?  For some databases and table schema,
> it provides a shortcut to querying for the recently changed records, as
> long as you have a "maximum value column" to use.
>
> https://nifi.apache.org/docs/nifi-docs/components/org.
> apache.nifi/nifi-standard-nar/1.5.0/org.apache.nifi.processors.standard.
> QueryDatabaseTable/index.html
>
> Thanks,
>
> James
>
> On Tue, Feb 6, 2018 at 6:12 AM, Austin Duncan <aduncan@pyaanalytics.com>
> wrote:
>
>> All,
>> I am trying to do a flow that queries a postgres database every hour. I
>> am trying to use the stateful settings in the updateAttribute processor so
>> that I only pull new files that have been uploaded within that hour. I am
>> having trouble figuring out how to implement it. Can anyone help me out?
>> Thanks,
>> Austin
>>
>> --
>> ‚ÄčAustin Duncan
>> *Developer*
>> PYA Analytics
>> 2220 Sutherland Avenue
>> <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
>> Knoxville, TN 37919
>> <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
>> 423-260-4172
>>
>> <https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
>> <%28865%29%20684-2828>
>>
>
>


-- 
‚ÄčAustin Duncan
*Developer*
PYA Analytics
2220 Sutherland Avenue
<https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
Knoxville, TN 37919
<https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
423-260-4172
<https://maps.google.com/?q=2220+Sutherland+AvenueKnoxville,+TN+37919+865&entry=gmail&source=g>
<%28865%29%20684-2828>

Mime
View raw message