我的配置单元查询在配置单元0.13中运行正常,但当我切换到配置单元2.3时,开始出现以下错误:
FAILED: SemanticException 5:980 Schema of both sides of union should match:
Column ln_id is of type string on first table and type int on second table.
Error encountered near token 'hourly_temp_for_prod'
org.apache.hadoop.hive.ql.parse.SemanticException: 5:980 Schema of both sides of union should match:
Column ln_id is of type string on first table and type int on second table.
Error encountered near token 'hourly_temp_for_prod'
我的查询正在尝试使用 UNION ALL
在两个表之间,第一个表仅包含作为字符串的列名,另一个表包含与这些列名相关的实际数据。
暂无答案!
目前还没有任何答案,快来回答吧!