How can we run DB QUERY node without LIMIT Clause?

[SnigdhaBiswas]

Hi
I am trying to run a database query and I don’t want the limit clause to be added by default instead I want to use the TOP clause. How can I do this on knime?

[goodvirus]

Hi, could you share the node you are using and the code? Because when I use it, its not automatically limited.

Best regards,

Paul

[SnigdhaBiswas]

This is the node which I am trying to use -DB Query — NodePit

[goodvirus]

Hi, I can use TOP just fine:

Could you share your workflow and the error message?

[SnigdhaBiswas]

This is the parsed query . It adds the limit clause in the backend and I don’t want that

[mlauber71]

@SnigdhaBiswas the DB Query creates a VIEW. If you want the data you will have to use the:

DB Reader

You can also execute ‘pure’ SQL commands that would then send commands to the database directly:

Example how to use H2 database to create table with upload and from scratch –...

[L4-BD] exercise 1 odyssey

@Thiemo.Kellner my suggestion would be to toy around with this workflow to see various functions and how they would work: [image] The ‘brown’ database connections are indeed a combination of SQL VIEWS that are put together without optimization (that would be the job of the database). I would assume this is because they are meant to function across a large number of databases and the combinations could be quite extensive (think: Hive, Impala, Big Data). So like with every database the user w…

[goodvirus]

I think the Limit is only added in the Preview, have you tried it outside of the configuration window?

[SnigdhaBiswas]

Yes, got it now.
Thanks