-----------------------------------------------------------
This is an automatically generated e-mail. To reply, visit:
https://reviews.apache.org/r/25059/
-----------------------------------------------------------
(Updated Sept. 12, 2014, 1:26 a.m.)
Review request for hive.
Bugs: HIVE-7733
https://issues.apache.org/jira/browse/HIVE-7733
Repository: hive-git
Description
-------
{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
Diffs (updated)
-----
ql/src/java/org/apache/hadoop/hive/ql/parse/RowResolver.java 2e58b80
ql/src/java/org/apache/hadoop/hive/ql/parse/SemanticAnalyzer.java 496f6a6
ql/src/test/queries/clientpositive/complex_alias.q PRE-CREATION
ql/src/test/results/clientnegative/ambiguous_col.q.out 237c21f
ql/src/test/results/clientnegative/ambiguous_col0.q.out 237c21f
ql/src/test/results/clientnegative/ambiguous_col1.q.out 237c21f
ql/src/test/results/clientnegative/ambiguous_col2.q.out 237c21f
ql/src/test/results/clientpositive/ambiguous_col.q.out e8760f1
ql/src/test/results/clientpositive/complex_alias.q.out PRE-CREATION
Diff: https://reviews.apache.org/r/25059/diff/
Testing
-------
Thanks,
Navis Ryu
