Skip to main content

GROUP_BIT_AND

Description

Performs a bitwise AND operation on all values in a single integer column or expression.

Syntax

GROUP_BIT_AND(<expr>)

Parameters

ParameterDescription
<expr>Supports types: TinyInt, SmallInt, Integer, BigInt, LargeInt.

Return Value

Returns an integer value of the same type as . If all values are NULL, returns NULL. NULL values are not involved in the bitwise operation.

Example

-- setup
create table group_bit(
value int
) distributed by hash(value) buckets 1
properties ("replication_num"="1");

insert into group_bit values
(3),
(1),
(2),
(4),
(NULL);
select group_bit_and(value) from group_bit;
+----------------------+
| group_bit_and(value) |
+----------------------+
| 0 |
+----------------------+
select group_bit_and(value) from group_bit where value is null;
+----------------------+
| group_bit_and(value) |
+----------------------+
| NULL |
+----------------------+