Semanticexception Column xx Found in more than one tables/subqueries

Execute HIVEQL times wrong:

Semanticexception Column xx Found in more than one tables/subqueries

There are two tables in hive that have the same field name, which is reported when the two tables are associated.

650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/6F/2E/wKiom1WTxLXQIvhZAAEdNs4Yeus194.jpg "title=" Semanticexception Hive "style=" float:left; "alt=" wkiom1wtxlxqivhzaaedns4yeus194.jpg "/>

Alias the repeating field of one of the tables and then make the associated query

Select City.city, Hotel.hotel, Hotel.hotelname,

(SELECT City as hcity , Hotel, hotelname from hotel) Hotel

where city.city = hotel.hcity

Semanticexception Column xx Found in more than one tables/subqueries