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.