shiftright function

Applies to: Databricks SQL Databricks Runtime

Returns a bitwise signed right shifted by n bits.

shiftright(expr, n)

• expr: An INTEGER or BIGINT expression.
• n: An INTEGER expression specifying the number of bits to shift.

The result type matches expr.

When expr is negative (that is, the highest order bit is set) the result remains negative because the highest order bit is sticky. When n is negative the result is 0.

> SELECT shiftright(4, 1);
 2
> SELECT shiftright(-4, 1);
 -2

• shiftleft function
• shiftrightunsigned function