Copy from CSV sfile

Lim · November 2016

Hi,

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?

Thank you.

Adrian_Oprea_1 · November 2016

You can grab the headers of the file and create the table before you run copy cmd. (oldschool)

Or

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.

We're Moving!