bit_reverse function

Applies to: check marked yes Databricks SQL check marked yes 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