Vertica - Remove command execution

48 Views Asked by At

I have a query sequence in Vertica below:

drop table [table_name]; 
create [table_name] as select ...;  
drop table [table_name];
create [table_name] as select ...;  
select ...;  

My resulting file looks like

DROP TABLE  
CREATE TABLE
DROP TABLE
CREATE TABLE
column1 | column2 | column3 |  

Does Vertica have a configuration parameter that can eliminate the 'DROP' and 'CREATE' table and retains only the SELECT output?

0

There are 0 best solutions below