Running sql functions

KNIME Analytics Platform
1

I have been using DB QUERY READER to run Postgres functions in a workflow ( by the way is there a better way?)
the wrong part is, I am not receiving same results doing it in KNIME than directly in Postgres despite it runs fine to the end…Like not all records get processed.

Is it limited in anyway?
Is it working with some cache that falsely show different results?
Thanks in advance

2

If you use the preview its automatically limited. But when you execute the workflow it should show the same results.

If this not solves the issue, can you post the workflow?

3 Likes