You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Tom Zeng (JIRA)" <ji...@apache.org> on 2018/10/18 22:59:00 UTC
[jira] [Commented] (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:comment-tabpanel&focusedCommentId=16656003#comment-16656003 ]
Tom Zeng commented on HIVE-11351:
---------------------------------
Hi, any update on this?
> 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
> 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
(v7.6.3#76005)