[
https://issues.apache.org/jira/browse/HIVE-28488?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Seonggon Namgung updated HIVE-28488:
------------------------------------
Attachment: 1.MergeAdjacentUnionDistinct.pdf
> Merge adjacent union distinct
> -----------------------------
>
> Key: HIVE-28488
> URL: https://issues.apache.org/jira/browse/HIVE-28488
> Project: Hive
> Issue Type: New Feature
> Reporter: Seonggon Namgung
> Assignee: Seonggon Namgung
> Priority: Major
> Labels: pull-request-available
> Attachments: 1.MergeAdjacentUnionDistinct.pdf,
> 1.MergeAdjacentUnionDistinct.pptx
>
>
> Current Hive compiles
> "SELECT * FROM TBL1 UNION SELECT * FROM TBL2 UNION SELECT * FROM TBL3"
> to
> {code:java}
> TS - GBY - RS
> TS - GBY - RS - GBY - RS
> TS - GBY - RS - GBY {code}
> This can be optimized as follows:
> {code:java}
> TS - GBY - RS
> TS - GBY - RS
> TS - GBY - RS - GBY {code}
> Please check out the attached slides for detailed explanation and feel free
> to ask any questions or share suggestions. Also, it would be glad if one can
> share about better location of this optimization (e.g. SemanticAnalyzer,
> Calcite, etc.).
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
