[
https://issues.apache.org/jira/browse/IMPALA-15125?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin reassigned IMPALA-15125:
-------------------------------------
Assignee: Steve Carlin
> 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
> Assignee: Steve Carlin
> Priority: Major
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
