# CLEAR LOAD ERRORS

The `CLEAR LOAD ERRORS` command 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 the `information_schema.LOAD_DATA_ERRORS` table.
* `CLEAR LOAD ERRORS [ HANDLE string ]` removes records from the `information_schema.LOAD_DATA_ERRORS` table where the `HANDLE` field matches the string value that you specify.
* This command causes implicit commits. Refer to [COMMIT](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/commit.md) for more information.

## Example

Suppose the `INFORMATION_SCHEMA.LOAD_DATA_ERRORS` table contains many records. Two of these records have the handle `orders_errors`:

```sql
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;

```

```output

+-----------------------+-----------------------------+--------------------------------------------------------------+
| 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.

```sql
CLEAR LOAD ERRORS HANDLE 'orders_errors';

```

## Related Topics

* [LOAD DATA](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/load-data.md)

***

Modified at: June 11, 2026

Source: [/db/v9.1/reference/sql-reference/data-manipulation-language-dml/clear-load-errors/](https://docs.singlestore.com/db/v9.1/reference/sql-reference/data-manipulation-language-dml/clear-load-errors/)

(An index of the documentation is available at /llms.txt)