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

Related functions

• bit_get function
• getbit function
• ~ (tilde sign) operator