如下兩種的表達效果是一樣
方法一：
select
tm ,
count(tm) as times
from
(
select
case
when single_times = '1' then 'one_time'
when single_times = '2' then 'two_time'
when single_times = '3' then 'three_time'
when single_times = '4' then 'four_time'
when single_times = '5' then 'five_time'
else 'more_five' end as tm
from
(select count(userid) single_times from test where dt = '2020-10-12' group by userid ) t
) t
group by tm ；
方法二：文章來源：http://www.zghlxwxcb.cn/news/detail-410695.html
select
tm ,
count(tm) as times
from
(
select
case?single_times
when '1' then 'one_time'
when '2' then 'two_time'
when '3' then 'three_time'
when '4' then 'four_time'
when &#文章來源地址http://www.zghlxwxcb.cn/news/detail-410695.html
到了這里，關于hive中case when的兩種使用方法的文章就介紹完了。如果您還想了解更多內容，請在右上角搜索TOY模板網以前的文章或繼續(xù)瀏覽下面的相關文章，希望大家以后多多支持TOY模板網！
