DATA_LOADER_EVENTS
Lists events from all data loaders.
Lists events from all data loaders, including the file path, whether the load succeeded, and how many times it has been retried. You must own or have any privilege (EXECUTE, ALTER, or DROP) on a data loader to see its events in this table.
To prevent unbounded growth, records in this table are purged periodically. You can set the purge frequency for individual data loaders when creating or altering the loader. See CREATE DATA LOADER and ALTER DATA LOADER. The default is 14 days.
| Column Name | Column Type | Description |
|---|---|---|
DATA_LOADER_NAMESPACE |
VARCHAR | For Eon Mode databases, namespace of the data loader that performed this load. |
DATA_LOADER_SCHEMA |
VARCHAR |
Schema for the data loader that performed this load. If the schema belongs to a non-default namespace in an Eon Mode database, the schema name is front-qualified with the name of the schema's namespace. For example, |
DATA_LOADER_NAME |
VARCHAR | Name of the data loader that performed this load. |
TIME_STAMP |
TIMESTAMPTZ | Time when Vertica recorded the event. |
FILE_NAME |
VARCHAR | Path that was loaded (or attempted). |
TRANSACTION_ID |
VARCHAR | Unique identifier for the transaction in which the load occurred. |
LOAD_STATUS |
VARCHAR |
OK if the load succeeded or FAIL if it did not. |
ROWS_LOADED |
INTEGER |
If a single file was loaded, the number of rows. If more than one file was loaded in a single batch, this value is null. For batch loads, FILE_SIZE_BYTES can be helpful in place of row counts. |
FAILURE_REASON |
VARCHAR | If the load failed, an explanatory message. |
RETRY_ATTEMPT |
INTEGER | 0 if this was the first attempt to load the file, otherwise the number of retries including this one. |
FILE_SIZE_BYTES |
INTEGER | File size in bytes when the data loader was executed. |
BATCH_ID |
INTEGER | Identifier, unique within the transaction, for the batch this file was part of. If a file was loaded individually, this value is null. |