Help Center > > Developer Guide> Tutorial: Importing Data from OBS to a Cluster> Step 4: Analyzing and Handling Import Errors

Step 4: Analyzing and Handling Import Errors

Updated at: May 15, 2019 GMT+08:00

This section describes how to handle the data format errors that occurred during data import.

  1. Query error information in the error table.

    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 2: Creating a Foreign Table 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 record 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 for 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