flink表:user
目标:根据age把用户分为少年、青年、中年、老年
实现sql
select id uesr_id
,case when age <= 18 then '少年'
when age >= 19 and age <= 30 then '青年'
when age >= 31 and age <= 50 then '中年'
when age >= 51 then '老年' end age_level
from user
现象:
age_level这个字段整体为空,排除了age为空的情况
将flink sql改为
select id uesr_id
,case when age <= 18 then '少年'
when age >= 19 and age <= 30 then '青年'
when age >= 31 and age <= 50 then '中年'
else '老年' end age_level
from user
flink sql case when语句要
case when then
else
end
flink case when 语句
最新推荐文章于 2023-07-18 17:53:17 发布