Help Center > > Developer Guide> Tutorial: Using GDS to Import Data from a Remote Server> Step 6: Analyzing and Handling Import Errors

Step 6: Analyzing and Handling Import Errors

Updated at: Jul 15, 2020 GMT+08:00

This section describes how to handle data format errors that occurred during import. If no error information is reported, skip this step.

  1. Query error information in the error table.

    1
    SELECT * FROM product_info_err ;
    

  2. Handle errors if any.

    In this tutorial, there should be no error information in the error table.

    Alternatively, you can change FILL_MISSING_FIELDS and IGNORE_EXTRA_DATA in the foreign table created in Step 4: Creating a Foreign Table in the DWS Database to false, and import the data again. Then query the error table. In this case, you will find the following data format error information:

    • The last column product_comment_content of the second row in the product_info2.csv source data file is lost.
    • The number of columns in the third record in the product_info2.csv source data file is greater than that defined in the foreign table.

    For details about error tables and troubleshooting, see Handling Import Errors.

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