[ 
https://issues.apache.org/jira/browse/HIVE-12543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15127143#comment-15127143
 ] 

Ashutosh Chauhan commented on HIVE-12543:
-----------------------------------------

I think join merging needs to happen for such cases, as it could be substantial 
perf regression wherever its applicable.
For constant propagation, I think existing plan is better than new one, since 
atleast one operator is not doing additional column processing at run time. But 
it may be ok to tackle this later.
For DPP, this could add quite a bit latency, this needs to be looked into.

So, I think join merging & DPP needs to be looked immediately, its ok to do it 
in follow-up. Constant propagation would be good to have as well, but can be 
deferred for later.

> Disable Hive ConstantPropagate optimizer when CBO has optimized the plan
> ------------------------------------------------------------------------
>
>                 Key: HIVE-12543
>                 URL: https://issues.apache.org/jira/browse/HIVE-12543
>             Project: Hive
>          Issue Type: Sub-task
>          Components: CBO, Logical Optimizer
>    Affects Versions: 2.0.0
>            Reporter: Jesus Camacho Rodriguez
>            Assignee: Jesus Camacho Rodriguez
>         Attachments: HIVE-12543.01.patch, HIVE-12543.02.patch, 
> HIVE-12543.03.patch, HIVE-12543.04.patch, HIVE-12543.05.patch, 
> HIVE-12543.patch
>
>




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to