bit_reverse
function
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.
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