[jira] [Created] (HIVE-19993) Using a table alias which also appears as a column name is not possible

["Zoltan Haindrich (JIRA)" <ji...@apache.org>]

Zoltan Haindrich created HIVE-19993:
---------------------------------------

             Summary: Using a table alias which also appears as a column name is not possible
                 Key: HIVE-19993
                 URL: https://issues.apache.org/jira/browse/HIVE-19993
             Project: Hive
          Issue Type: Bug
            Reporter: Zoltan Haindrich


{code}
drop table if exists tableA;
drop table if exists tableB;

create table tableA (a integer,z integer);
create table tableB (a integer,b integer,z integer);

select a.z, b.b 
from tableB as b JOIN 
tableA as a
on a.a=b.b;
{code}

{code}
Error: Error while compiling statement: FAILED: SemanticException Column a Found in more than One Tables/Subqueries (state=42000,code=40000)
{code}



--
This message was sent by Atlassian JIRA
(v7.6.3#76005)