Skip to main content
Version: 0.0.1

BIT_OR

Categories: Bitwise, Aggregate

BIT_OR

Returns the bitwise OR of non-NULL input values.

Syntax​

BIT_OR(expression int) → int​

  • expression: An expression that evaluates to a data type that can be cast as an integer.

Examples

{{< codeheader "BIT_OR example" >}}

SELECT BIT_OR(passenger_count)
  FROM Samples."samples.dremio.com"."NYC-taxi-trips"

-- EXPR$0
-- 255

{{< codeheader "BIT_OR example" >}}

SELECT total_amount, 
  BIT_OR(passenger_count)
FROM Samples."samples.dremio.com"."NYC-taxi-trips"
GROUP BY total_amount

-- total_amount, EXPR$1
-- 29.0, 7
-- 5.5, 15

Usage Notes​

If no rows match, returns a value with all bits set to 0. NULL values have no effect on the result unless all results are NULL, which is treated as no match.