shiftrightunsigned function

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

Returns a bitwise unsigned right shifted by n bits.

Syntax 

shiftrightunsigned(expr, n)

Arguments

  • expr: An INTEGER or BIGINT expression.

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

Returns

The result type matches expr.

When n is negative the result is 0.

Examples 

> SELECT shiftrightunsigned(4, 1);
 2
> SELECT shiftrightunsigned(-4, 1);
 2147483646