Exporting Data to Files
You might want to export data from Vertica, either to share it with other applications or to move lower-priority data from ROS to less-expensive storage. You can use the EXPORT TO (format) statements to export a table or other query results to certain file formats. Vertica supports export to Parquet (EXPORT TO PARQUET), ORC (EXPORT TO ORC), and delimited (EXPORT TO DELIMITED) formats.
You can export data to HDFS, S3, Google Cloud Storage (GCS), Azure Blob Storage, or the Linux file system. You can export ROS data or data that is readable through external tables. After exporting ROS data, you can drop affected ROS partitions to reclaim storage space.
Be careful to avoid concurrent exports to the same output destination. Doing so is an error on any file system and can produce incorrect results.
You cannot export data from an external table that contains external, non-native data types. See Complex Types.
After exporting data, you can define external tables to read that data in Vertica. Parquet and ORC are columnar formats that Vertica can take advantage of in query optimization, so consider using one of those formats for external tables. See Working with External Data.