case when条件包含like异常

[fanglie...@zhongan.com]

hi，各位大佬，社区版的kylin case when里面包含like条件好像有点问题。
比如这样(CASE WHEN kylin_sales.lstg_format_name like '%Auction%' THEN 'Auction'  
ELSE '其他' END)
select  distinct  (CASE WHEN kylin_sales.lstg_format_name like '%Auction%' THEN 
'Auction'  ELSE '其他' END) as zidingyiziduan,count(1)  from 
vehicle_sentry.kylin_sales as kylin_sales INNER JOIN 
vehicle_sentry.kylin_cal_dt as kylin_cal_dt on kylin_sales.part_dt = 
kylin_cal_dt.cal_dt group by zidingyiziduan  limit 1000;  这个查出来的结果是

换成(CASE WHEN kylin_sales.lstg_format_name = 'Auction' THEN 'Auction'  ELSE '其他' 
END)后 ，查出来的结果是



fanglie...@zhongan.com