GROUP_BIT_OR

Description

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

Syntax

GROUP_BIT_OR(<expr>)

Parameters

Parameter	Description
<expr>	Supports all INT types

Return Value

Returns an integer value

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);

select * from group_bit;

+-------+
| value |
+-------+
|     3 |
|     1 |
|     2 |
|     4 |
+-------+

mysql> select group_bit_or(value) from group_bit;

+-----------------------+
| group_bit_or(`value`) |
+-----------------------+
|                     7 |
+-----------------------+