Understood. Can you share an outline of the query you are trying to use? Which values would you change based on the maintained state? What would be the source of the updated state?
On Tue, Feb 6, 2018 at 6:33 AM, Austin Duncan <[email protected]> wrote: > 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 <[email protected]> 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 <[email protected]> >> 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> >
