SQS_LISTENER_ERROR_HISTORY
Lists errors and rejections in reading from SQS.
Lists errors and rejections that occur when reading from SQS, such as malformed SQS messages and authorization problems. These errors occur when Vertica reads from SQS as part of automatic data load.
The DATA_LOADER_EVENTS table records errors that occur during the load (COPY) step but does not include pre-load errors from SQS.
Column Name | Column Type | Description |
---|---|---|
REPORT_TIME |
TIMESTAMPTZ | Time when Vertica recorded the error or rejection. |
NODE_NAME |
VARCHAR | Name of the node where the error occurred. |
ERROR_SOURCE |
VARCHAR | Component that produced the error, such as "SQSTrigger" or "SQSListener". |
MESSAGE |
VARCHAR | More details about the error. |
QUEUE_URL |
VARCHAR | SQS queue. |