nifi-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Bruce Lowther <>
Subject Re: QueryDatabaseTable - getting all records from a table
Date Wed, 13 Sep 2017 12:44:34 GMT
Have you looked at ExecuteSQL?

If you want all results, this might be a better processor...

On Wed, Sep 13, 2017 at 05:02 Uwe Geercken <> wrote:

> Hello,
> I have spent some time working with the QueryDatabaseTable. My Flow is
> very simple - I query Oracle and output to Avro files.
> I want to retrieve all records from the Oracle Table containing 307714
> records. I had a look at the Oracle table and looked for the lowest
> auto-generated id (AUTOID). The table also has a LAST_CHANGE_TIME column
> containg a timestamp.
> First I started to use LAST_CHANGE_TIME as the maximum-value column in the
> processor. But this does not retrieve all records.
> Next I used AUTIID and LAST_CHANGE_TIME, but with the same result.
> Next I set the property "initial.maxvalue.AUTOID". The Nifi documentation
> for the processor specifies: "Initial Max Value" = "Specifies an initial
> max value for max value columns. Properties should be added in the format
> `initial.maxvalue.{max_value_column}`. But this does not work either.
> Then I tried to do the same with the LAST_CHANGE_TIME column. Defined in
> Oracle as a Date. I put "initial.maxvalue.LAST_CHANGE_TIME" to "2016-08-25
> 23:07:14:00.000 GMT" but I get an error "timezone region not found". I have
> to spend more time on trying to fix this - maybe an environment setting or
> maybe the driver...
> I just don't get it why not all records are retrieved. Can somebody help?
> Rgds,
> Uwe
Sent while mobile...some restriction may apply.

View raw message