nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andrew Grande <apere...@gmail.com>
Subject Re: Postgres table as Cached Lookup Service
Date Sat, 10 Aug 2019 18:29:50 GMT
Matt, the 1.9.2 docs don't list anything like that. Are you sure? Is it
something coming out in the next, unreleased version? A more than welcome
addition :)

Silly me was searching for everything jdbc, of course, on the page.

Andrew

On Sat, Aug 10, 2019, 11:08 AM Matt Burgess <mattyb149@gmail.com> wrote:

> There is, sorry I’m AFK ATM but there’s a SimpleDatabaseLookup and a
> DatabaseRecordLookup (or something similarly named) :)
>
> Sent from my iPhone
>
> On Aug 10, 2019, at 1:31 PM, Andrew Grande <aperepel@gmail.com> wrote:
>
> Maybe this would help?
> https://github.com/mrcsparker/nifi-sqllookup-services-bundle/blob/master/README.md
>
> I wish there was a standard bundled jdbc lookup record implementation.
>
> Andrew
>
> On Fri, Aug 9, 2019, 11:56 PM Craig Knell <craig.knell@gmail.com> wrote:
>
>> Hi Folks
>>
>> Cached Postgres Lookup Service
>> whats the best way to create a postgres lookup service within nifi.
>>
>> I have an incoming ff with content in JSON.
>> What i want to do is use the field
>> =  "ID" : 12344
>>  field to lookup a postgres table and ADD in a new json field
>> =  "NAME" : lookupvalue
>> back into the ff content in json format.
>>
>> I would ideally like the lookup processor to get/refresh the cached data
>> daily.
>>
>> Avro Records
>> It looks like the Rcord processing should work with the Cache,
>> I however get a little lost with using Record processors and AVRO
>> 1. are avro schema's case sensitive?
>> 2. how do i convert from incoming JSON ff with  uppercase fields to an
>> out going ff in lowercase fields ?
>> 3. i performed a validateRecord processor using lowercase avro schema
>> against the incoming ff with uppercase fields and it returned 3 of the
>> 10 fields, in lowercase, with null values, not sure what this means.
>>
>> Thanks
>>
>> Craig
>>
>

Mime
View raw message