[ 
https://issues.apache.org/jira/browse/HIVE-30190?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Denys Kuzmenko updated HIVE-30190:
----------------------------------
    Description: 
Repro: on an Iceberg table, SELECT a.id, b.id FROM t a JOIN t b ON a.v = b.v 
WHERE a.id < b.id, in both execution
modes.
{code}
Cannot find ExprNodeEvaluator for the exprNodeDesc = RS[7]
  at ExprNodeEvaluatorFactory.get(69) <- FilterOperator.initializeOp(65)
{code}
- The plan keeps predicate: (v is not null and ... and (v) IN (RS[7])).
- With hive.tez.dynamic.partition.pruning=false the predicate is gone and the 
query works.
- A STRUCT<a:INT> key fails the same way.

> Iceberg: join on a struct or VARIANT key fails when dynamic partition pruning 
> leaves IN (RS[n]) in the filter
> -------------------------------------------------------------------------------------------------------------
>
>                 Key: HIVE-30190
>                 URL: https://issues.apache.org/jira/browse/HIVE-30190
>             Project: Hive
>          Issue Type: Sub-task
>            Reporter: Denys Kuzmenko
>            Priority: Major
>
> Repro: on an Iceberg table, SELECT a.id, b.id FROM t a JOIN t b ON a.v = b.v 
> WHERE a.id < b.id, in both execution
> modes.
> {code}
> Cannot find ExprNodeEvaluator for the exprNodeDesc = RS[7]
>   at ExprNodeEvaluatorFactory.get(69) <- FilterOperator.initializeOp(65)
> {code}
> - The plan keeps predicate: (v is not null and ... and (v) IN (RS[7])).
> - With hive.tez.dynamic.partition.pruning=false the predicate is gone and the 
> query works.
> - A STRUCT<a:INT> key fails the same way.



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

Reply via email to