SemanticException [Error 10004]: Line 1:30 Invalid table alias or column reference ‘customers_state‘

项目场景：

hive sql 语句 执行报错

问题描述：

SemanticException [Error 10004]: Line 1:30 Invalid table alias or column reference ‘customers_state’: (possible column names are: customer_id, customer_fname, customer_lname, customer_email, customer_password, customer_street, customer_city, customer_state, customer_zipcode)

---

原因分析：

打错了 列名 customer

解决方案：