You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Navis (JIRA)" <ji...@apache.org> on 2014/09/12 10:11:34 UTC
[jira] [Comment Edited] (HIVE-7733) Ambiguous column reference
error on query
[ https://issues.apache.org/jira/browse/HIVE-7733?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14131246#comment-14131246 ]
Navis edited comment on HIVE-7733 at 9/12/14 8:11 AM:
------------------------------------------------------
[~ashutoshc] The uniqueness of columns name should be mandatory for sub query. testCliDriver_ambiguous_col should be failed under this assumption but it's succeeded in exceptional way (select-star in top-level query). Should we allow this?
was (Author: navis):
[~ashutoshc] The uniqueness of columns name should be mandatory for sub query. testCliDriver_ambiguous_col should be failed in this assumption but it's succeeded in exceptional way (select-star in top-level query). Should we allow this?
> 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, HIVE-7733.3.patch.txt, HIVE-7733.4.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)