[jira] [Updated] (HIVE-7733) Ambiguous column reference error on query

["Jason Dere (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-7733?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jason Dere updated HIVE-7733:
-----------------------------

    Affects Version/s: 0.13.0

> 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
>
> {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)