Simple SELECT * FROM issues :-(

KNIME Analytics Platform
1

This is my first query:     SELECT * FROM v_lst_names

and then the warning below:

 

WARN Database Reader java.sql.SQLException: Malformed SQL Statement: Syntax error near: FROM

Statement: SELECT * FROM (SELECT * FROM v_lst_names) table_23151937 WHERE 1 = 0

 

 

2

Which database are you using? It looks like it does not support nested queries which KNIME needs in order to get the table structure.