hive中执行sql报错:FAILED: SemanticException The abstract syntax tree is null
执行sql为:
set hive.cli.print.header=true;
with t as(
select 1 id,'k1' key,123 value
union all
select 1 id,'k2' key,124 value
union all
select 2 ,'k1' key,234 value
)
select id,
max(case when key='k1' then value else 0 end) k1,
sum(case when key='k2' then value else 0 end) k2
from t
group by id;
排查为union all 前后的select语句中字段必须有相同的字段名,将select 2 ,'k1' key,234 value 改为select 2 id ,'k1' key,234 value 即可