Parsing of the query from Knime

When ever the DB Table Selector Node parses the query to the database , it appends select * from ahead of the query that we are using . For eg : If we use Select * from table_name , KNIME will read it as select * from (Select * from Table_name)

Is there a way to remove the additional " Select * from " from ahead of the query .

I need to basically execute "Explain select * from table_name " to get the cost of the query .

Hi,
For such a simple case the query optimizer should simplify the query. Have you tried removing it manually and comparing the explain outputs with and without the superfluous select? My guess would be that the cost is the same.
Kind regards
Alexander

2 Likes

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.