LOAD_DATA_ERRORS

On this page

This table is where the errors are logged when the LOAD DATA command is used with the ERRORS HANDLE clause.

information_schema.LOAD_DATA_ERRORS Schema

Column Name	Description
`DATABASE_NAME`	The name of the database associated with the error.
`HANDLE`	The string value specified in the `LOAD DATA ... ERRORS HANDLE <string>` statement that caused the error.
`ERROR_UNIX_TIMESTAMP`	The time of the error event in Unix timestamp format.
`ERROR_TYPE`	Specifies what type of error occurred. `Error` is used when `LOAD DATA` returned the error to the client application. `Warning` is used when `LOAD DATA` did not return the error to the client application and instead skipped or ignored the error. Note: If `LOAD DATA ... ERRORS HANDLE` returns a duplicate key error to the client application, the error is not logged to `information_schema.LOAD_DATA_ERRORS`.
`ERROR_CODE`	The error code for the error.
`ERROR_MESSAGE`	The message associated with the error. This value contains contextual information about the error that can be used for debugging purposes, including a stack trace if the error was caused by a transform failure.
`LOAD_DATA_LINE`	The text of a `LOAD DATA` statement that caused a parsing error while attempting to load data into the destination table. Load errors are typically caused by malformed CSV data or attempting to write invalid schema types into a column, such as a `NULL` value into a non-nullable column.
`LOAD_DATA_LINE_NUMBER`	The line number of a `LOAD DATA` statement that caused a parsing error while attempting to load data into the destination table. A `LOAD DATA` statement may consist of many lines, and this value indicates the specific invalid line. This line number can be correlated with the value of `LOAD_DATA_LINE`, which contains the invalid line’s text. This value may be empty or `NULL` if a `LOAD DATA` statement wasn’t associated with the error event.
`HOST`	The hostname or host IP address for the leaf node that processed the erroneous line of the input file.
`PORT`	The port number of the node that processed the erroneous line of the input file.
`PARTITION`	Specifies the partition ID on the leaf node that processed the erroneous line of the input file. This value is NULL if the aggregator processed the line.

Last modified: September 18, 2024

Was this article helpful?