Get the App
SLTechnology News&Howtos  ›  Internet Technology  › 

SemanticException Column xx Found in more than One Tables/Subqueries

Shulou Source: shulou.com Published: 2022-06-03 03:21:18 11月16日 Update

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

Tags: Field association two alias name time Times error will report query Apple Docker Huawei Linux macOS MariaDB Microsoft MySQL NVidia OPPO Reno Xiaomi MySQL MariaDB Docker Linux