I'm looking at how my organisation can integrate KNIME and I'm wondering whether it's possible to process SQL scripts ignoring certain error types.
For example my SQL script contains 'DROP TABLE' statements so that I can overwrite previously created data. If these tables have already been dropped the script fails with a 'Table doesn't exist' error.
In my standard SQL scripting environment I can ignore these errors and so I'm wondering whether KNIME also has a means of doing this?
I've tried to work around this problem using some IF THEN logic in my SQL script but this doesn't appear to work in the KNIME world.
I'm using the "Database SQL Executor" node connected to a Kognitio connection.