You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hive.apache.org by "Ashutosh Chauhan (JIRA)" <ji...@apache.org> on 2016/04/07 03:15:25 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=15229468#comment-15229468 ]
Ashutosh Chauhan commented on HIVE-11351:
-----------------------------------------
This might have same issue as HIVE-13235 cc: [~aihuaxu]
> 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)