当前位置: 代码迷 >> 综合 >> SemanticException [Error 10004]: Line 1:30 Invalid table alias or column reference ‘customers_state‘
  详细解决方案

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

热度:68   发布时间:2023-11-22 07:03:34.0

项目场景:

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

解决方案:

在这里插入图片描述

  相关解决方案