hive sql报错：SQL 错误 [10004] [42000]: Error while compiling statement: FAILED: SemanticException [Error

SQL 错误 [10004] [42000]: Error while compiling statement: FAILED: SemanticException [Error 10004]: Line 64:0 Invalid table alias or column reference ‘T4’: (possible column names are: order_id, order_status, update_time, charge_id, charge_status, station_id, station_name, soc, totalpower, i_a, i_b, i_c, u_a, u_b, u_c, pri_opr_id)

在这里插入图片描述
需要改为：

ORDER BY
a,
b

参考：https://blog.csdn.net/Q48711/article/details/119513480