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

Pengcheng Xiong commented on HIVE-8435:
---------------------------------------

Initially I expect this patch can help me solve the external/internal name 
problem for groupby index when CBO is turned on. However, it seems that it does 
not work for a simple query even without index. :)

A query to show that it does not work:

select key, count(key) 
from src
group by key;
set hive.cbo.enable=true;
select key, count(key)
from src
group by key;

> Add identity project remover optimization
> -----------------------------------------
>
>                 Key: HIVE-8435
>                 URL: https://issues.apache.org/jira/browse/HIVE-8435
>             Project: Hive
>          Issue Type: New Feature
>          Components: Logical Optimizer
>    Affects Versions: 0.9.0, 0.10.0, 0.11.0, 0.12.0, 0.13.0
>            Reporter: Ashutosh Chauhan
>            Assignee: Sergey Shelukhin
>         Attachments: HIVE-8435.02.patch, HIVE-8435.03.patch, 
> HIVE-8435.03.patch, HIVE-8435.04.patch, HIVE-8435.05.patch, 
> HIVE-8435.05.patch, HIVE-8435.06.patch, HIVE-8435.1.patch, HIVE-8435.patch
>
>
> In some cases there is an identity project in plan which is useless. Better 
> to optimize it away to avoid evaluating it without any benefit at runtime.



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

Reply via email to