raise_error function

Applies to: Databricks SQL 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: Databricks SQL Databricks Runtime 14.2 and above

The returned error condition 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

Related functions

• assert_true function
• Handling error conditions