Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
Databricks SQL Databricks Runtime 15.4 and above
Returns expr bitwise unsigned right shifted by n bits. This operator is a synonym for shiftrightunsigned function.
Syntax
expr >>> n
Arguments
expr: AnINTEGERorBIGINTexpression.n: AnINTEGERexpression specifying the number of bits to shift.
Returns
The result type matches expr.
The effective shift distance is n modulo 32 for an INTEGER expr and modulo 64 for a BIGINT expr.
Examples
> SELECT 4 >>> 1;
2
> SELECT -4 >>> 1;
2147483646
> SELECT 1 >>> -1;
0