Step 5: Analyzing and Handling Import Errors

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

1. Query error information in the error table.

   1	openGauss=# 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: Installing, Configuring, and Starting GDS on a Data Server 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 row 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.