*
(asterisk sign) operator
Applies to: Databricks SQL Databricks Runtime
Returns multiplier
multiplied by multiplicand
.
Arguments
multiplier
: A numeric or INTERVAL expression.multiplicand
: A numeric expression or INTERVAL expression.
You may not specify an INTERVAL for both arguments.
Returns
If both
multiplier
andmultiplicand
are DECIMAL, the result is DECIMAL.If
multiplier
ormultiplicand
is an INTERVAL, the result is of the same type.If both
multiplier
andmultiplicand
are integral numeric types, the result is the larger of the two types.In all other cases the result is a DOUBLE.
If either the multiplier
or the multiplicand
is 0, the operator returns 0.
If the result of the multiplication is outside the bound for the result type an ARITHMETIC_OVERFLOW error is raised.
Use try_multiply to return NULL
on overflow.
Warning
In Databricks Runtime, if spark.sql.ansi.enabled is false
, the result “wraps” if it is out of bounds for integral types, and the result is NULL
for fractional types.