FAILED: SemanticException The abstract syntax tree is null 解决办法

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 即可