Example:
Code: Select all
COPY some_table FROM '/path/to/data/ClickStreamData_201?/*' DIRECT...
PS. Thanks to vertica-forums user sKwa for this handy tip!
Moderator: NorbertKrupa
Code: Select all
COPY some_table FROM '/path/to/data/ClickStreamData_201?/*' DIRECT...
Code: Select all
test_db=> \! mkdir -p /tmp/vertica
test_db=> \! echo -e "one\ntwo\nthree" > /tmp/vertica/data_01.txt
test_db=> \! echo -e "one\ntwo\nthree" > /tmp/vertica/data_02.txt
test_db=> \! echo -e "one\ntwo\nthree" > /tmp/vertica/data_03.txt
test_db=> \! echo -e "one\ntwo\nthree" > /tmp/vertica/data_04.txt
Code: Select all
test_db=> \! ls /tmp/vertica
data_01.txt data_02.txt data_03.txt data_04.txt
test_db=> \! cat /tmp/vertica/data_01.txt
one
two
three
Code: Select all
test_db=> create table tbl (var varchar(5));
CREATE TABLE
test_db=> copy tbl from '/tmp/vertica/data_0?.txt';
Rows Loaded
-------------
12
(1 row)
test_db=> copy tbl from '/tmp/vertica/data*';
Rows Loaded
-------------
12
(1 row)