[
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: (was: 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
> 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)
