THROW_ERROR
Returns a user-defined error message.
In a multi-node cluster, race conditions might cause the order of error messages to differ.
Syntax
THROW_ERROR ( message )
Parameters
message |
The VARCHAR string to to return. |
Examples
Return an error message when a CASE statement is met:
=> CREATE TABLE pitcher_err (some_text varchar); CREATE TABLE => COPY pitcher_err FROM STDIN; Enter data to be copied followed by a newline. End with a backslash and a period on a line by itself. >> big foo value >> bigger foo other value >> bar another foo value >> \. => SELECT (CASE WHEN true THEN THROW_ERROR('Failure!!!') ELSE some_text END) FROM pitcher_err; ERROR 7137: USER GENERATED ERROR: Failure!!!
Return an error message when a CASE statement using REGEXP_LIKE is met:
=> SELECT (CASE WHEN REGEXP_LIKE(some_text, 'other') THEN THROW_ERROR('Failure at "' || some_text || '"') END) FROM pitcher_err; ERROR 4566: USER GENERATED ERROR: Failure at "bar another foo value"