You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

SHOW LOAD WARNINGS

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

Syntax

SHOW LOAD WARNINGS

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

memsql> SHOW LOAD WARNINGS;
+------------------+---------+------+-----------------------------------------------+---------------+-------------+------------+------+
| Unix Timestamp   | Level   | Code | Message                                       | Line Contents | Line Number | Host       | Port |     
+------------------+---------+------+-----------------------------------------------+---------------+-------------+------------+------+
| 1489779887204071 | Warning | 1263 | NULL supplied to NOT NULL column 'a' at row 1 | \N	1       | 1           | 127.0.0.1  | 3306 |
+------------------+---------+-----+------------------------------------------------+---------------+-------------+------------+------+
1 row in set (0.00 sec)