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.