• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Tutorial: Importing Data from OBS to a Cluster
  5. Step 4: Analyzing and Handling Import Errors

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.

    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.