And

Supported in: Batch, Faster, Streaming

Returns true if all of the specified conditions are true. Treats nulls as false with ANSI mode off, propagates nulls otherwise.

Expression categories: Boolean

Declared arguments

• Conditions: List of conditions from which the output is calculated.
  List<Expression<Boolean>>

Output type: Boolean

Examples

Example 1: Base case

Argument values:

• Conditions: [left_boolean, right_boolean]

---

Example 2: Null case (ANSI mode on)

Argument values:

• Conditions: [left_boolean, right_boolean]

---

Example 3: Null case (ANSI mode off)

Argument values:

• Conditions: [left_boolean, right_boolean]

---