raise_error function

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime

Throws an exception with expr as the message.

Syntax

raise_error(expr)

Arguments

  • expr: A STRING expression.

Returns

The NULL type.

The function raises a runtime error with expr as the error message.

Applies to: check marked yes Databricks SQL check marked yes Databricks Runtime 14.2 and later

The returned error class is USER_RAISED_EXCEPTION and the SQLSTATE is P0001.

See Handling error conditions for details on handling error conditions.

Examples

> SELECT raise_error('custom error message');
 [USER_RAISED_EXCEPTION] custom error message SQLSTATE: P0001