[jira] [Created] (IMPALA-15125) Calcite Planner: Filter/Values merge failing after upgrade to Calcite 1.42

["Steve Carlin (Jira)" <ji...@apache.org>]

Steve Carlin created IMPALA-15125:
-------------------------------------

             Summary: Calcite Planner: Filter/Values merge failing after upgrade to Calcite 1.42
                 Key: IMPALA-15125
                 URL: https://issues.apache.org/jira/browse/IMPALA-15125
             Project: IMPALA
          Issue Type: Sub-task
            Reporter: Steve Carlin


The following query is failing to simplify a Filters-Value reduction:

  select id, int_col,

      row_number() over (order by string_col desc) as rownum

  from functional.alltypesagg UNION ALL select 1, 2, 3) v 

where rownum <= 20 db: default

The following RelNodes are not being reduced:


    LogicalFilter(condition=[<=(CAST($2):BIGINT, 20)]), id = 58

      LogicalValues(tuples=[[\{ 1, 2, 3 }]]), id = 4

Digging into the code a little bit:
The filter condition in 1.41 contains the constant.  In 1.42, the filter expression initially contains the RexInputRef.  It does get reduced, but the reduction is to a RexCall, "CAST(true):boolean". That's as far as I got debugging, not sure why that isn't reducing.  Also, Calcite is not calling our reducer/simplifier, it is hardcoded into their rule.

Because it's a filter on top of a Values, this will have minimal performance impact, since Values RelNodes will never be big, but this still should be fixed.

 



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org