[jira] [Commented] (HIVE-8681) CBO: Column names are missing from join expression in Map join with CBO enabled

["Pengcheng Xiong (JIRA)" <ji...@apache.org>]

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

Pengcheng Xiong commented on HIVE-8681:
---------------------------------------

[~jpullokkaran] and [~ashutoshc], could you please take a look? Thanks. [~mmokhtar], could you please apply the patch and try Q75 in TPC-DS? I heard that it is the most complicated query for explain. Thanks again.

> CBO: Column names are missing from join expression in Map join with CBO enabled
> -------------------------------------------------------------------------------
>
>                 Key: HIVE-8681
>                 URL: https://issues.apache.org/jira/browse/HIVE-8681
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>         Attachments: HIVE-8681.1.patch
>
>
> On Hive 14 when CBO is enabled the column names are missing from the join expression. Rather than to use external names "key", "value", some internal names such as "_col0" or "_col1" are used. For map join with more than two tables it is very hard to figure the actual join order. In this patch, I am going to address this issue not only for join but also for all the other operators. And it will also be addressed in not only CLI but also TEZ environment.



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