SemanticException Column xx Found in more than One Tables/Subqueries
Execution of hiveql Times error:
SemanticException Column xx Found in more than One Tables/Subqueries
There are two tables in Hive that have the same field name. This error will be reported when the two tables are associated.
Add an alias to the duplicate field of one of the tables, and then make an associated query
Select city.city, hotel.hotel, hotel.hotelname from city city
(select city as hcity, hotel, hotelname from hotel) hotel
Where city.city = hotel.hcity