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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 4.0.0-alpha-1
• Assignee: Jaume M
• Reporter: Zoltan Haindrich
• Created: 26/Jun/18 08:47
• Updated: 17/Nov/22 08:54
• Resolved: 04/Sep/18 15:05

Description

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;

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