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.