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?