Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
更新しました 2024/09/06
Send us feedback
shiftrightunsigned
Applies to: Databricks SQL Databricks Runtime
Returns a bitwise unsigned right shifted by n bits.
n
shiftrightunsigned(expr, n)
expr: An INTEGER or BIGINT expression.
expr
INTEGER
BIGINT
n: An INTEGER expression specifying the number of bits to shift.
The result type matches expr.
When n is negative the result is 0.
> SELECT shiftrightunsigned(4, 1); 2 > SELECT shiftrightunsigned(-4, 1); 2147483646
shiftleft function
shiftright function