SHOW LOAD WARNINGS

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

Syntax

SHOW LOAD WARNINGS [INTO OUTFILE 'file_name']

Remarks

Output

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

Example

SHOW LOAD WARNINGS;
+-------------------+---------+------+------------------------------------------------------------------------------+---------------+-------------+-----------+------+
| Unix Timestamp    | Level   | Code | Message                                                                      | Line Contents | Line Number | Host      | Port |
+-------------------+---------+------+------------------------------------------------------------------------------+---------------+-------------+-----------+------+
| 1532291800.720735 | Warning | 1262 | Row 1346 was truncated; it contained more data than there were input columns | test      func|        1346 | 10.0.2.15 | 3308 |
+-------------------+---------+------+------------------------------------------------------------------------------+---------------+-------------+-----------+------+
Was this article useful?