Outdated Version
You are viewing an older version of this section. View current production version.
SHOW LOAD WARNINGS
Shows details of rows that threw warnings during the LOAD DATA process.
Syntax
SHOW LOAD WARNINGS
Remarks
- 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 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)
