power function

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

Raises expr1 to the power of expr2. This function is a synonym for pow function.

Syntax 

power(expr1, expr2)

Arguments

  • expr1: An expression that evaluates to a numeric.

  • expr2: An expression that evaluates to a numeric.

Returns

A DOUBLE.

Examples 

> SELECT pow(2, 3);
8.0