- Code: Select all
COPY some_table FROM '/path/to/data/ClickStreamData_201?/*' DIRECT...
When would this be useful? For example, you have many tables storing history including folders for the years 2010, 2011, 2012, etc. Each "year" folder contains tables for each month. You can load in separate streams each year or month and they will load in serial - one after other.
PS. Thanks to vertica-forums user sKwa for this handy tip!