Data export

You can export data from Vertica, which you might do for the following reasons:

• To instead use the data in external tables; see Working with external data.

• To share data with other clients or consumers in an ecosystem.

• To copy data to another Vertica cluster.

Vertica provides two ways to export data. With the data exporters, you can export the results of a SELECT query to files in Parquet, ORC, or delimited format. You can use partitioning in the export, which can decrease output file size and improve performance when reading the data in external tables. For more information, see File export.

Vertica also provides a way to move data directly between Vertica clusters, without having to export from one and load in the other. You can perform the operation as either an import from another database or an export to another database; aside from the direction of data travel, these two operations are quivalent. For more information, see Database export and import.