HiveSQL-if函数

最新推荐文章于 2023-12-14 17:07:44 发布

qq_35970254

最新推荐文章于 2023-12-14 17:07:44 发布

阅读量1.9k

点赞数

分类专栏： Hive

本文链接：https://blog.csdn.net/qq_35970254/article/details/52760656

版权

Hive 专栏收录该内容

3 篇文章 0 订阅

订阅专栏

if函数

select a.partitiontime,if (0<price/100<=20,'0-20',if(20<price/100<=50,'20-50' ,

                                                     if(50<price/100<=100,'50-100' ,if(100<price/100<=200,'100-200' , '200+'))))
                                                     ,a.from_source,if (a.platform in('android','iPad','iPhone'),'app','qita'), count(distinct a.user_id) from aaa a
where a.partitiontime>='20161005' and a.partitiontime<='20161007'
group by a.partitiontime,if (0<price/100<=20,'0-20',if(20<price/100<=50,'20-50' ,
                                                     if(50<price/100<=100,'50-100' ,if(100<price/100<=200,'100-200' , '200+'))))
                                                     ,a.from_source,if (a.platform in('android','iPad','iPhone'),'app','qita')