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)