<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[satan_9的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/satan_9</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; satan_9]]></copyright><item><title><![CDATA[抖音的直播视频录屏]]></title><link>https://blog.youkuaiyun.com/satan_9/article/details/128456384</link><guid>https://blog.youkuaiyun.com/satan_9/article/details/128456384</guid><author>satan_9</author><pubDate>Tue, 27 Dec 2022 15:15:42 +0800</pubDate><description><![CDATA[【代码】抖音的直播视频录屏。]]></description><category></category></item><item><title><![CDATA[【hive】count() count(if) count(distinct if) sum(if)的区别]]></title><link>https://blog.youkuaiyun.com/satan_9/article/details/120659303</link><guid>https://blog.youkuaiyun.com/satan_9/article/details/120659303</guid><author>satan_9</author><pubDate>Fri, 08 Oct 2021 20:30:24 +0800</pubDate><description><![CDATA[【hive】count() count(if) count(distinct if) sum(if)的区别

表名:user_active_day (用户日活表)

表内容:

user_id(用户id) user_is_new(是否新用户 1:新增用户 0:老用户) location_city(用户所在地区)partition_date(日期分区)

需求:

　　找出20180901至今的xxx地区的用户日活量以及新增用户量

思路:

　　筛选日期分区和地区,统计user_id的数量为用户日...]]></description><category></category></item></channel></rss>