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 <[email protected]> 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 > "லஞ்சம் தவிர்த்து நெஞ்சம் நிமிர்த்து"
