| (pipe sign) operator

Applies to: Databricks SQL Databricks Runtime

Returns the bitwise OR of expr1 and expr2.

Syntax

expr1 | expr2

Arguments

• expr1: An integral numeric type expression.
• expr2: An integral numeric type expression.

Returns

The result type matches the widest type of expr1 and expr2.

Examples

> SELECT 3 | 5;
 7

Related functions

• & (ampersand sign) operator
• ~ (tilde sign) operator
• ^ (caret sign) operator
• bit_count function