Shulou(Shulou.com)06/03 Report--

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

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.