Amazon Redshift will no longer support the creation of new Python UDFs starting November 1, 2025. If you would like to use Python UDFs, create the UDFs prior to that date. Existing Python UDFs will continue to function as normal. For more information, see the blog post .

spectrum_query_maxerror

Values (default in bold)

-1, integer

Description

You can specify an integer to indicate the maximum number of errors to accept before canceling the query. A negative value turns off maximum error data handling. The results are logged in SVL_SPECTRUM_SCAN_ERROR.

Example

The following example assumes ORC data that contains surplus characters and characters that are not valid. The column definition for my_string specifies a length of 3 characters. Following is the sample data for this example:

my_string
---------------
abcdef
gh�
ab

The following commands set the maximum number of errors to 1 and perform the query.

set spectrum_query_maxerror to 1;
SELECT my_string FROM orc_data;

The query stops and the results are logged in SVL_SPECTRUM_SCAN_ERROR.