Hive SQL踩坑记录-NULL判断、字符串拼接、执行报错:Expression not in GROUP BY key
记录在使用Hive SQL 过程中的错误信息【Hive SQL踩坑记录】对于NULL判断select last_visit_day, case when last_visit_day is NULL then datediff('2021-06-01', '2021-05-01') else COALESCE(datediff(stat_dt, last_visit_day), 0) end as consecutive_days_without_access from