Module unwrap_cast

Module unwrap_cast 

Source
Expand description

Unwrap casts in binary comparisons for physical expressions

This module provides optimization for physical expressions similar to the logical optimizer’s unwrap_cast module. It attempts to remove casts from comparisons to literals by applying the casts to the literals if possible.

The optimization improves performance by:

  1. Reducing runtime cast operations on column data
  2. Enabling better predicate pushdown opportunities
  3. Optimizing filter expressions in physical plans

§Example

Physical expression: cast(column as INT64) > INT64(10) Optimized to: column > INT32(10) (assuming column is INT32)