OR (Lakehouse v1)

Conditional OR operator. Checks whether either condition is true.

Analyze Syntax

or_(<expr1>[, <expr2> ...])

Analyze Examples

or_(
    table.color == 'green',
    table.shape == 'circle',
    table.price >= 1.25
)

SQL Syntax

<expr1> OR <expr2>

SQL Examples

SELECT * FROM table WHERE
    table.color = 'green'
    OR table.shape = 'circle'
    OR table.price >= 1.25;