[
https://issues.apache.org/jira/browse/HIVE-26660?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17787207#comment-17787207
]
Krisztian Kasa commented on HIVE-26660:
---------------------------------------
[~glapark]
1. Could you please describe how HIVE-26986 solve this issue. Having
unnecessary RS operators in the plan shouldn't cause wrong results only
unnecessary shuffle during runtime hence performance degradation.
2. please provide simple repro steps (ddl, some test data and a simple query)
of the issue mentioned in the description.
3. if the issue somehow relates to SharedWorkOptimizer, OperatorGraph and/or
ParallelEdgeFixer please try running the query with
{code:java}
set hive.optimize.shared.work.parallel.edge.support=false;
{code}
and see if the issue persist.
> TPC-DS query 71 returns wrong results
> -------------------------------------
>
> Key: HIVE-26660
> URL: https://issues.apache.org/jira/browse/HIVE-26660
> Project: Hive
> Issue Type: Sub-task
> Reporter: Sungwoo Park
> Priority: Major
>
> TPC-DS query 71 returns wrong results when tested with 100GB dataset. The
> query fails with an error:
>
> Caused by: org.apache.hadoop.hive.common.NoDynamicValuesException: Value does
> not exist in registry: RS_39_item_i_item_sk_min
> at
> org.apache.hadoop.hive.ql.exec.tez.DynamicValueRegistryTez.getValue(DynamicValueRegistryTez.java:77)
> at
> org.apache.hadoop.hive.ql.plan.DynamicValue.getValue(DynamicValue.java:128)
> at
> org.apache.hadoop.hive.ql.exec.vector.expressions.gen.FilterLongColumnBetweenDynamicValue.evaluate(FilterLongColumnBetweenDynamicValue.java:88)
> at
> org.apache.hadoop.hive.ql.exec.vector.expressions.FilterExprAndExpr.evaluate(FilterExprAndExpr.java:42)
> at
> org.apache.hadoop.hive.ql.exec.vector.VectorFilterOperator.process(VectorFilterOperator.java:125)
> at
> org.apache.hadoop.hive.ql.exec.Operator.vectorForward(Operator.java:919)
> at
> org.apache.hadoop.hive.ql.exec.TableScanOperator.process(TableScanOperator.java:171)
> at
> org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.deliverVectorizedRowBatch(VectorMapOperator.java:809)
> at
> org.apache.hadoop.hive.ql.exec.vector.VectorMapOperator.process(VectorMapOperator.java:842)
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
