Help Center> Data Warehouse Service> Best Practices> Tutorial: Importing Data from OBS to a Cluster> Step 4: Analyzing and Handling Import Errors
View PDF

Step 4: Analyzing and Handling Import Errors

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

  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 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.