Exporting Data

You might want to export data from Vertica, either to share it with other Hadoop-based applications or to move lower-priority data from ROS to less-expensive storage. You can use the EXPORT TO PARQUET statement to export a table (or part of one) as Parquet data.

You can export data to HDFS, S3, or the local 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. If you need to access the data in Vertica again, you can create external tables from the exported data.

After exporting data, you can define external tables to read that data in Vertica. See Working with External Data.