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 [INTO OUTFILE 'file_name']
Remarks
file_name: An optional file containing the input lines that causedLOAD DATAwarnings.- 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
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 |
+-------------------+---------+------+------------------------------------------------------------------------------+---------------+-------------+-----------+------+
