GoogleSQL for BigQuery supports the following bit functions.
Function list
| Name | Summary |
|---|---|
BIT_AND | Performs a bitwise AND operation on an expression. For more information, see Aggregate functions. |
BIT_COUNT | Gets the number of bits that are set in an input expression. |
BIT_OR | Performs a bitwise OR operation on an expression. For more information, see Aggregate functions. |
BIT_XOR | Performs a bitwise XOR operation on an expression. For more information, see Aggregate functions. |
BIT_COUNT
BIT_COUNT(expression) Description
The input, expression, must be an integer or BYTES.
Returns the number of bits that are set in the input expression. For signed integers, this is the number of bits in two's complement form.
Return Data Type
INT64
Example
SELECT a, BIT_COUNT(a) AS a_bits, FORMAT("%T", b) as b, BIT_COUNT(b) AS b_bits FROM UNNEST([ STRUCT(0 AS a, b'' AS b), (0, b'\x00'), (5, b'\x05'), (8, b'\x00\x08'), (0xFFFF, b'\xFF\xFF'), (-2, b'\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFE'), (-1, b'\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF'), (NULL, b'\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF\xFF') ]) AS x; /*-------+--------+---------------------------------------------+--------* | a | a_bits | b | b_bits | +-------+--------+---------------------------------------------+--------+ | 0 | 0 | b"" | 0 | | 0 | 0 | b"\x00" | 0 | | 5 | 2 | b"\x05" | 2 | | 8 | 1 | b"\x00\x08" | 1 | | 65535 | 16 | b"\xff\xff" | 16 | | -2 | 63 | b"\xff\xff\xff\xff\xff\xff\xff\xfe" | 63 | | -1 | 64 | b"\xff\xff\xff\xff\xff\xff\xff\xff" | 64 | | NULL | NULL | b"\xff\xff\xff\xff\xff\xff\xff\xff\xff\xff" | 80 | *-------+--------+---------------------------------------------+--------*/