Handling Import Errors
Scenarios
Handle errors that occurred during data import.
Querying Error Information
Errors that occur when data is imported are divided into data format errors and non-data format errors.
- Data format error
When creating a foreign table, specify LOG INTO error_table_name. Data format errors occurring during the data import will be written into the specified table. You can run the following SQL statement to query error details:
1
SELECT * FROM error_table_name;
Table 1 lists the columns of the error_table_name table.Table 1 Columns of the error_table_name table Column
Type
Description
nodeid
integer
ID of the node where an error is reported
begintime
timestamp with time zone
Time when a data format error is reported
filename
character varying
Name of the source data file where an error about data format occurs
rownum
bigint
Number of the row where an error occurs in a source data file
rawrecord
text
Raw record of the data format error in the source data file
detail
text
Error details
- Non-data format error
A non-data format error leads to the failure of an entire data import task. You can locate and troubleshoot a non-data format error based on the error message displayed during data import.
Handling data import errors
Troubleshoot data import errors based on obtained error information and the description in the following table.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.