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

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 Helpful?

Thanks For Your Feedback!