SHOW LOAD ERRORS

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

Syntax

SHOW LOAD ERRORS [INTO OUTFILE 'file_name']

Remarks

  • file_name: An optional output file containing the lines that caused LOAD DATA errors. You can edit this file to correct the errors and run it through LOAD DATA again to complete the load.
  • Normally, specific errors will be reported only if the LOAD DATA command partially runs but some lines are skipped. For this, you need to load data using LOAD DATA ... SKIP ... ERRORS. Without SKIP ... ERRORS the standard behavior is to fail the whole LOAD DATA command so none of the input file rows would be loaded.
  • This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands).

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?