Exporting to the Linux file system

If you export to an NFS mount on the Linux file system, the exporters behave the same way as for any other shared location: all of the exported files are written to the same destination.

If you export to the local Linux file system, each Vertica node writes its portion of the export to its local file system. To define an external table to read the exported data, you must specify each node and path, as in the following example:

=> CREATE EXTERNAL TABLE sales (...)
   AS COPY FROM '/data/sales/*.parquet' ON node01,
                '/data/sales/*.parquet' ON node02,
                '/data/sales/*.parquet' ON node03 PARQUET;

The path on each node is the same path that you specified in the export statement.

If you omit the ON clauses and just specify a path, COPY only loads the data it finds on the initiator node.