Help Center > > Developer Guide> Data Export> Exporting Data to OBS in Parallel> Exporting Data

Exporting Data

Updated at: Mar 13, 2020 GMT+08:00

Procedure

  1. Export data.

    1
    INSERT INTO [Foreign table name] SELECT * FROM [Source table name];
    
    • Only a single internal table can be exported at a time. Multi-table join is not supported during export. Results of the aggregation, sort, subquery, and limit operations on a single table also cannot be exported.

Examples

  • Example 1: Export data from table product_info_output to a data file through the product_info_output_ext foreign table.
    1
    DWSINSERT INTO product_info_output_ext SELECT * FROM product_info_output;
    
    If information similar to the following is displayed, the data has been exported.
    INSERT 0 10
  • Example 2: Export part of the data to a data file by specifying the filter condition WHERE product_price>500.
    1
    INSERT INTO product_info_output_ext SELECT * FROM product_info_output WHERE product_price>500;
    

Data of a special type, such as RAW, is exported as a binary file, which cannot be recognized by the import tool. You need to use the RAWTOHEX() function to convert it to the hexadecimal format before export.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel