Soumyakanti Das created HIVE-30015:
--------------------------------------
Summary: Multiple identical Projects on top of HiveJdbcConverter
Key: HIVE-30015
URL: https://issues.apache.org/jira/browse/HIVE-30015
Project: Hive
Issue Type: Improvement
Components: Hive
Affects Versions: 4.3.0
Reporter: Soumyakanti Das
Assignee: Soumyakanti Das
Attachments: cbo_jdbc_duplicate_project_repro.q,
cbo_jdbc_duplicate_project_repro.q.out
I have added a repro query, similar to cbo_query14.q, and its output. We see
multiple identical Projects on top of HiveJdbcConverter, for example:
{noformat}
HiveUnion(all=[true])
HiveProject(id=[$0], $f1=[$1])
HiveProject(id=[$0], $f1=[$1])
HiveProject(id=[$0], $f1=[$1])
HiveProject(id=[$0], $f1=[$1])
HiveJdbcConverter(convention=[JDBC.POSTGRES]){noformat}
I think this can be resolved by adding a check in
{{PlanModifierForASTConv.convertOpTree(RelNode rel, RelNode parent)}}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
