Outdated Version
You are viewing an older version of this section. View current production version.
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 causedLOAD DATAerrors.- 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 |
+------------------+-------+------+--------------------------------------------------------------------------+---------------+-------------+------+------+
