hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Aihua Xu (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-11351) Column Found in more than One Tables/Subqueries
Date Thu, 07 Apr 2016 14:04:25 GMT

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

Aihua Xu commented on HIVE-11351:
---------------------------------

This does look the same issue as HIVE-13235. This fix would work I guess, but it will break
many valid constant propagation. I'm still working on it.

> Column Found in more than One Tables/Subqueries
> -----------------------------------------------
>
>                 Key: HIVE-11351
>                 URL: https://issues.apache.org/jira/browse/HIVE-11351
>             Project: Hive
>          Issue Type: Bug
>         Environment: HIVE 1.1.0
>            Reporter: MK
>            Assignee: Alina Abramova
>         Attachments: HIVE-11351-branch-1.0.patch
>
>
> when execute a script:
> INSERT overwrite TABLE tmp.tmp_dim_cpttr_categ1
>    SELECT DISTINCT cur.categ_id       AS categ_id,
>                    cur.categ_code     AS categ_code,
>                    cur.categ_name     AS categ_name,
>                    cur.categ_parnt_id AS categ_parnt_id,
>                    par.categ_name     AS categ_parnt_name,
>                    cur.mc_site_id     AS mc_site_id
>    FROM   tmp.tmp_dim_cpttr_categ cur
>    LEFT   OUTER JOIN tmp.tmp_dim_cpttr_categ par
>    ON     cur.categ_parnt_id = par.categ_id;
> error occur :  SemanticException Column categ_name Found in more than One Tables/Subqueries
> when modify the alias categ_name to categ_name_cur, it will be execute successfully.
> INSERT overwrite TABLE tmp.tmp_dim_cpttr_categ1
>    SELECT DISTINCT cur.categ_id       AS categ_id,
>                    cur.categ_code     AS categ_code,
>                    cur.categ_name     AS categ_name_cur,
>                    cur.categ_parnt_id AS categ_parnt_id,
>                    par.categ_name     AS categ_parnt_name,
>                    cur.mc_site_id     AS mc_site_id
>    FROM   tmp.tmp_dim_cpttr_categ cur
>    LEFT   OUTER JOIN tmp.tmp_dim_cpttr_categ par
>    ON     cur.categ_parnt_id = par.categ_id;
>  this happen when we upgrade hive from 0.10 to 1.1.0 .  



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

Mime
View raw message