[
https://issues.apache.org/jira/browse/HIVE-7733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14299469#comment-14299469
]
Yongzhi Chen commented on HIVE-7733:
------------------------------------
[~navis], I just create a new jira related to the issue, do you want to look at
it?
HIVE-9528
> Ambiguous column reference error on query
> -----------------------------------------
>
> Key: HIVE-7733
> URL: https://issues.apache.org/jira/browse/HIVE-7733
> Project: Hive
> Issue Type: Bug
> Affects Versions: 0.13.0
> Reporter: Jason Dere
> Assignee: Navis
> Fix For: 0.14.0
>
> Attachments: HIVE-7733.1.patch.txt, HIVE-7733.2.patch.txt,
> HIVE-7733.3.patch.txt, HIVE-7733.4.patch.txt, HIVE-7733.5.patch.txt,
> HIVE-7733.6.patch.txt, HIVE-7733.7.patch.txt
>
>
> {noformat}
> CREATE TABLE agg1
> (
> col0 INT,
> col1 STRING,
> col2 DOUBLE
> );
> explain SELECT single_use_subq11.a1 AS a1,
> single_use_subq11.a2 AS a2
> FROM (SELECT Sum(agg1.col2) AS a1
> FROM agg1
> GROUP BY agg1.col0) single_use_subq12
> JOIN (SELECT alias.a2 AS a0,
> alias.a1 AS a1,
> alias.a1 AS a2
> FROM (SELECT agg1.col1 AS a0,
> '42' AS a1,
> agg1.col0 AS a2
> FROM agg1
> UNION ALL
> SELECT agg1.col1 AS a0,
> '41' AS a1,
> agg1.col0 AS a2
> FROM agg1) alias
> GROUP BY alias.a2,
> alias.a1) single_use_subq11
> ON ( single_use_subq11.a0 = single_use_subq11.a0 );
> {noformat}
> Gets the following error:
> FAILED: SemanticException [Error 10007]: Ambiguous column reference a2
> Looks like this query had been working in 0.12 but starting failing with this
> error in 0.13
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
