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