we have Oracle query with table name alias in join query as below
Source Name : Oracle
Actual Query :
select * from db1.employee as emp join
db2.department as dep on emp.empno = dep.empno.
Dremio translated this query to as below
select * from db1.employee employee join
db2.department department on employee.empno = department.empno.
above query is not taking actual query alias. issue comes when db2 Oracle Schema has table name “employee” then its throw ambiguity error at source.
Does Dremio support Table Alias ? please help on this,