Bit functions
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, seeAggregate 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, seeAggregate functions. |
BIT_XOR | Performs a bitwise XOR operation on an expression. For more information, seeAggregate functions. |
BIT_COUNT
BIT_COUNT(expression)Description
The input,expression, must be aninteger orBYTES.
Returns the number of bits that are set in the inputexpression.For signed integers, this is the number of bits in two's complement form.
Return Data Type
INT64
Example
SELECTa,BIT_COUNT(a)ASa_bits,FORMAT("%T",b)asb,BIT_COUNT(b)ASb_bitsFROMUNNEST([STRUCT(0ASa,b''ASb),(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')])ASx;/*-------+--------+---------------------------------------------+--------+ | 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 | +-------+--------+---------------------------------------------+--------*/Except as otherwise noted, the content of this page is licensed under theCreative Commons Attribution 4.0 License, and code samples are licensed under theApache 2.0 License. For details, see theGoogle Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2025-12-15 UTC.