配置单元联合所有操作失败:semanticexception

hgc7kmma  于 2021-05-27  发布在  Hadoop
关注(0)|答案(0)|浏览(426)

我的配置单元查询在配置单元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 在两个表之间,第一个表仅包含作为字符串的列名,另一个表包含与这些列名相关的实际数据。

暂无答案!

目前还没有任何答案,快来回答吧!

相关问题