You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@hive.apache.org by "Pengcheng Xiong (JIRA)" <ji...@apache.org> on 2015/09/28 00:25:04 UTC

[jira] [Resolved] (HIVE-11744) Correct table alias in auto_join17.q.out and etc

     [ https://issues.apache.org/jira/browse/HIVE-11744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Pengcheng Xiong resolved HIVE-11744.
------------------------------------
    Resolution: Fixed

> Correct table alias in auto_join17.q.out and etc
> ------------------------------------------------
>
>                 Key: HIVE-11744
>                 URL: https://issues.apache.org/jira/browse/HIVE-11744
>             Project: Hive
>          Issue Type: Improvement
>            Reporter: Pengcheng Xiong
>            Assignee: Pengcheng Xiong
>            Priority: Minor
>
> auto_join17.q include a self-join
> {code}
> explain
> FROM src src1 JOIN src src2 ON (src1.key = src2.key)
> INSERT OVERWRITE TABLE dest1 SELECT src1.*, src2.*
> {code}
> in the output, we have both of the join branch to be
> {code}
> TableScan
>             alias: src1
> {code}
> it is better if we have src1 and src2.



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