I am having an issue when I connect DBeaver to Vertica 7.0.1. This issue did not exist with the previous version 6.1.3.
In our instance this simple temp table statement does not work, the table is created but the :
CREATE TEMPORARY TABLE TestTempTable (OrderId int);
INSERT INTO TestTempTable(OrderId) values (8933);
SELECT * FROM TestTempTable;
DROP TABLE TestTempTable;
This same script works fine in vSQL in Vertica. I am not sure how to proceed in using DBeaver, can someone please advise?