hive-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alina Abramova (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-11351) Column Found in more than One Tables/Subqueries
Date Fri, 20 Jan 2017 12:21:27 GMT

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

Alina Abramova updated HIVE-11351:
----------------------------------
    Affects Version/s: 1.2.1
               Status: In Progress  (was: Patch Available)

> 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
>    Affects Versions: 1.2.1
>         Environment: HIVE 1.1.0
>            Reporter: MK
>            Assignee: Alina Abramova
>         Attachments: HIVE-11351.2-branch-1.0.patch, 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