You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Qi Yuan (Jira)" <ji...@apache.org> on 2021/10/14 07:51:00 UTC
[jira] [Updated] (HIVE-11351) Column Found in more than One
Tables/Subqueries
[ https://issues.apache.org/jira/browse/HIVE-11351?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Qi Yuan updated HIVE-11351:
---------------------------
Fix Version/s: 3.1.2
> 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
> Priority: Major
> Fix For: 3.1.2
>
> Attachments: HIVE-11351-branch-1.0.patch, HIVE-11351.2-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
(v8.3.4#803005)