CLEAR LOAD ERRORS
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
On this page
Removes load errors from the information_
table.LOAD DATA .
when it runs.
Syntax
CLEAR LOAD ERRORS [ HANDLE string ]
Remarks
-
CLEAR LOAD ERRORS
removes all records from theinformation_
table.schema. LOAD_ DATA_ ERRORS -
CLEAR LOAD ERRORS [ HANDLE string ]
removes records from theinformation_
table where theschema. LOAD_ DATA_ ERRORS HANDLE
field matches the string value that you specify. -
This command causes implicit commits.
Refer to COMMIT for more information.
Example
Suppose the INFORMATION_
table contains many records.orders_
:
SELECT load_data_line_number, load_data_line, error_messageFROM INFORMATION_SCHEMA.LOAD_DATA_ERRORSWHERE 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';
Related Topics
Last modified: July 25, 2022