CLEAR LOAD ERRORS
Removes load errors from the information_schema.LOAD_DATA_ERRORS
table. These errors are populated by LOAD DATA ... ERRORS HANDLE <string>
when it runs.
Syntax
CLEAR LOAD ERRORS [ HANDLE string ]
Remarks
CLEAR LOAD ERRORS
removes all records from theinformation_schema.LOAD_DATA_ERRORS
table.CLEAR LOAD ERRORS [ HANDLE string ]
removes records from theinformation_schema.LOAD_DATA_ERRORS
table where theHANDLE
field matches the string value that you specify.This command causes implicit commits. See COMMIT for more information.
Example
Suppose the INFORMATION_SCHEMA.LOAD_DATA_ERRORS
table contains many records. Two of these records have the handle orders_errors
:
SELECT load_data_line_number, load_data_line, error_message FROM INFORMATION_SCHEMA.LOAD_DATA_ERRORS WHERE handle = 'orders_errors' ORDER BY load_data_line_number; **** +-----------------------+-----------------------------+--------------------------------------------------------------+ | load_data_line_number | load_data_line | error_message | +-----------------------+-----------------------------+--------------------------------------------------------------+ | 2 | 2,138,Pears,{"order-date"} | Invalid JSON value for column 'order_properties' | | 4 | 4,307,Oranges,\N | NULL supplied to NOT NULL column 'order_properties' at row 4 | +-----------------------+-----------------------------+--------------------------------------------------------------+
To remove the two records, run the following command.
CLEAR LOAD ERRORS HANDLE 'orders_errors';