execute volatile table within KNIME

KNIME Analytics Platform
1

Hi,

I have successfully created and run a volatile table within the KNIME database reader node. example below:

create volatile table temp_event as
(
SELECT event_date, event_type
FROM event_table
) with data on commit preserve rows;

SELECT * from temp_event;

 

however, when I reset the node and try to re-execute it, i always get an error stated that the Table 'temp_event' already exists. I always need to close the KNIME analytics platform before able to re-create the volatile table.

Is there a way to drop/reset the connection and create a new connection from KNIME to the database (we use teradata)?

2

Hi pkusuma,

You could try to use the "Database Drop Table" node to drop the volatile table, after the Database Reader has executed.

Hope that helps,

Best,

Vincenzo