listdatabasetables -> querydatabasetable

[Selvam Raman <se...@gmail.com>]

Hi,

i could not able to use listdatabasetables with querydatabasetable. is
there any reason why querydatabasetable is not supporting table name as
expression true.

In my database i have some table which contains billions of rows. when i am
execution listdatabasetables followed by executesql most of the time i am
facing jvm heap issue (current ram size 2gb).(the ideal solution would be
now increasing RAM size).

Can you please share me your thoughts.

-- 
Selvam Raman
"லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"

Re: listdatabasetables -> querydatabasetable

[Matt Burgess <ma...@apache.org>]

Selvam,

For the first version of QueryDatabaseTable and GenerateTableFetch,
the idea was to just allow this for a single table, as it simplifies
the logic and behavior of the processor.  Having said that, I think
what you propose is a useful extension, and I have written up a Jira
[1] to cover it.

There will need to be some discussion around the behavior of the
processors when they do and don't have incoming flow files to process,
I have started the discussion in the Description of the Jira and very
much welcome your thoughts and suggestions.

Regards,
Matt

[1] https://issues.apache.org/jira/browse/NIFI-2881

On Mon, Oct 10, 2016 at 1:48 AM, Selvam Raman <se...@gmail.com> wrote:
> Hi,
>
> i could not able to use listdatabasetables with querydatabasetable. is there
> any reason why querydatabasetable is not supporting table name as expression
> true.
>
> In my database i have some table which contains billions of rows. when i am
> execution listdatabasetables followed by executesql most of the time i am
> facing jvm heap issue (current ram size 2gb).(the ideal solution would be
> now increasing RAM size).
>
> Can you please share me your thoughts.
>
> --
> Selvam Raman
> "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"