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

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

Jason Dere created HIVE-7733:
--------------------------------

             Summary: Ambiguous column reference error on query
                 Key: HIVE-7733
                 URL: https://issues.apache.org/jira/browse/HIVE-7733
             Project: Hive
          Issue Type: Bug
            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)