Users, in some cases, would like to export the data in Palo to other systems for further analysis.

Palo currently supports the following ways to export data:

1. Export

   EXPORT command mainly exports the contents of the whole table (or specified section) to remote storage, such as BOS.

   This method currently supports only the full export of specified tables or sections rather than the mapping, filtering or converting of exported results. The export format is CSV.

   Refer to the document for details: Full data export.

2. SELECT OUTFILE

   SELECT OUTFILE command exports user's SQL query results to remote storage (BOS) or local directory.

   This method can acquire expected results through flexible SQL syntax with lower efficiency than Export method due to the limitation of single thread output of the final result, though.

   Refer to the document for details: Export query result set.

3. Export to external table

   Users can, through INSERT command, export data query results to external tables.

   Refer to the document for details: Export data to external table.