SHOW LOAD ERRORS

Shows details of rows that threw errors during the LOAD DATA process.

Syntax

SHOW LOAD ERRORS [INTO OUTFILE 'file_name']

Remarks

Output

Column Description
Unix Timestamp The unix timestamp at which the error occurred.
Level The level of severity. For this command, it will be Error. For SHOW LOAD WARNINGS, it will be Warning.
Code The error code.
Message The error message.
Line Contents The contents of the line on which the error occurred.
Line Number The line number on which the error occurred.
Host Host name or IP address of node.
Port The port of the node.

Example

SHOW LOAD ERRORS;
+------------------+-------+------+--------------------------------------------------------------------------+---------------+-------------+------+------+
| Unix Timestamp   | Level | Code | Message                                                                  | Line Contents | Line Number | Host | Port |
+------------------+-------+------+--------------------------------------------------------------------------+---------------+-------------+------+------+
| 1520374932841995 | Error | 1261 | Leaf Error (10.0.2.15:3307): Row 22 doesn't contain data for all columns | NULL          |          -1 | NULL | NULL |
+------------------+-------+------+--------------------------------------------------------------------------+---------------+-------------+------+------+
Was this article useful?