![](https://img-blog.csdnimg.cn/20201014180756754.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
数仓
BinaryJack
这个作者很懒,什么都没留下…
展开
-
hivesql与业务解决思路
查看每个城市每天完成订单数,取消订单数,下单订单数,下单用户数 select city_id, sum(case when order_status=5 then 1 else 0 end) as cnt_ord_succ_d, sum(case when order_status=3 then 1 else 0 end) as cnt_ord_cacel_d, sum(1) as cnt_ord_d, count(distinct CUST_ID) as cnt_ord_user /原创 2020-12-30 11:06:51 · 238 阅读 · 0 评论 -
数仓实习遇到的问题
sql with用法 https://blog.csdn.net/qq_36617521/article/details/55256382 https://blog.csdn.net/weixin_41600552/article/details/82958942 convert() https://www.runoob.com/sql/func-convert.html cube和rollup,grouping https://www.cnblogs.com/zzhangyuhang/p/9原创 2020-12-28 18:11:27 · 249 阅读 · 0 评论