Do I have to create a table before I can use copy statement to import a CSV file to that table?
Can I import CSV file at the same time a new table is created?
You can grab the headers of the file and create the table before you run copy cmd. (oldschool)
You can use External table build definition on copy cmd:
CREATE EXTERNAL TABLE ext1 (x integer) AS COPY FROM '/tmp/ext1.dat' DELIMITER ',';
Note : there is need for access on a location for the user who will run the copy command.
See more details here
Both are not as fast/ optimium as the default copy cmd on a existing table.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.