Nota
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tidħol jew tibdel id-direttorji.
L-aċċess għal din il-paġna jeħtieġ l-awtorizzazzjoni. Tista’ tipprova tibdel id-direttorji.
Applies to:
Databricks SQL
Databricks Runtime
Returns the value obtained by reversing the order of the bits in the two's complement binary representation of the specified integral value.
Syntax
bit_reverse(expr)
Arguments
expr: An expression that evaluates to an integral numeric.
Returns
The result type matches the argument type.
Examples
> SELECT bit_reverse(64Y);
2
> SELECT bit_reverse(64L);
144115188075855872
> SELECT bit_reverse(-1);
-1
> SELECT bit_reverse(-2);
2147483647