[
https://issues.apache.org/jira/browse/HIVE-7733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Navis reassigned HIVE-7733:
---------------------------
Assignee: Navis
> 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
> Attachments: HIVE-7733.1.patch.txt, HIVE-7733.2.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.2#6252)
