<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[i_mycode的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/i_mycode</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; i_mycode]]></copyright><item><title><![CDATA[hiveSql 百度面试题-连续签到领金币]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/128568389</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/128568389</guid><author>i_mycode</author><pubDate>Fri, 06 Jan 2023 20:05:57 +0800</pubDate><description><![CDATA[用户在文章页可以每天签到，签到按照某种规则可获取金币，需统计每个用户每月获取金币数。有用户签到明细表：
记录用户进入签到页，点击签到按钮后退出log数据。
部分表数据明细如下：领取金币规则：（1）只要用户签到就能获取一枚金币
（2）连续签到第三天和第七天分别可以在每天一枚的基础上额外再获取2枚和6金币
（3）连续签到7天后进行重置，按照规则（1）和（2）进行新一轮领币
（4）用户进入时间和离开时间如果跨天 按照进入时间计算打卡时间上述举例明细中，用户id：1在2022-07-07到2022-07-15号连续]]></description><category></category></item><item><title><![CDATA[hiveSql 京东面试题-有效值问题]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/128535787</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/128535787</guid><author>i_mycode</author><pubDate>Wed, 04 Jan 2023 07:30:00 +0800</pubDate><description><![CDATA[有入库成本表，一个商品每次入库就会产生一条数据，里面包含商品id，入库时间time，以及入库采购的成本。但由于某些某些原因，导致表中某些数据的成本是有丢失的。
现在的逻辑是：当成本丢失时,有两种取成本的方式，现在需要把两种成本都取出来，最后取2次成本的平均值作为本次入库的成本。取数逻辑如下：具体数据如下：

可见截图中商品id为2的商品在2022-12-02号和2022-12-03号的入库成本丢失，按照上述取数逻辑，会生成两个新的字段last_cost、next_cost。其中
last_cost是当前丢失]]></description><category></category></item><item><title><![CDATA[hiveSql 构建连续日期]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/128485946</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/128485946</guid><author>i_mycode</author><pubDate>Thu, 29 Dec 2022 23:15:00 +0800</pubDate><description><![CDATA[有如下数据期望构建如下数据：期望数据是将已有数据补齐2022-12-01到2022-12-07号日期，没有的日期value为0，然后计算每组id内的累加value值。从期望数据角度看，咱们如果有每组id的2022-12-01到2022-12-07的数据，作为主表left join已有数据，再一个sum()over() 就很简单了，关键在于如何构造连续日期。
构造连续日期，且分成多行很容易想到利用repeat()函数，和posexplode()拆分重复的字符串，构建多行带索引的数据。再利用行索引与2022-1]]></description><category></category></item><item><title><![CDATA[hiveSql 重分组聚合问题]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/128475393</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/128475393</guid><author>i_mycode</author><pubDate>Wed, 28 Dec 2022 23:53:07 +0800</pubDate><description><![CDATA[将下图中A表转变为B和C，即A->B  A->C

2）第二种分析思路解法：
此处利用repeat()方法，重复name分组个数，按照空格连接，但是最后会多出一个空格，利用trim()将前后空格去除，再将空格替换为竖线连接name即可
结果：

结果：
喜欢的点赞、关注、收藏吧~ 你的支持是最大的创作动力~~]]></description><category></category></item><item><title><![CDATA[hiveSql 连续区间的起始结束位置]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/128213074</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/128213074</guid><author>i_mycode</author><pubDate>Wed, 07 Dec 2022 00:47:23 +0800</pubDate><description><![CDATA[有登录日志，求每个用户的每次连续登录的起始和结束日期有用户登录日志如下：
表：user_login，userid：用户id，date：登录日期
为了简化说明这里date日期用数字表示。这里需求想要最终结果为：连续时间的起始，结束日期到这里可以先思考下如何用hivesql实现很明显这里是利用重分组思想，将连续的日期分到同一组之后，取组内的最大最小值即可
最后
喜欢的点赞、关注、收藏吧~ 感谢支持~~]]></description><category></category></item><item><title><![CDATA[hiveSql冷门但好用函数 --持续更新]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/128107201</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/128107201</guid><author>i_mycode</author><pubDate>Wed, 30 Nov 2022 19:39:57 +0800</pubDate><description><![CDATA[hiveSql冷门但好用函数 --持续更新]]></description><category></category></item><item><title><![CDATA[hiveSql 相互关注问题]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/128088967</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/128088967</guid><author>i_mycode</author><pubDate>Mon, 28 Nov 2022 23:12:01 +0800</pubDate><description><![CDATA[hiveSql 优化的解决相互关注问题]]></description><category></category></item><item><title><![CDATA[hiveSql 跨N天最大连续统计]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/127901987</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/127901987</guid><author>i_mycode</author><pubDate>Thu, 17 Nov 2022 13:13:44 +0800</pubDate><description><![CDATA[hiveSql 跨N天最大连续统计]]></description><category></category></item><item><title><![CDATA[hiveSql 各时段观看直播人数]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/127843776</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/127843776</guid><author>i_mycode</author><pubDate>Mon, 14 Nov 2022 14:01:24 +0800</pubDate><description><![CDATA[各时段观看直播人数]]></description><category></category></item><item><title><![CDATA[shell学习-运算符]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/125883578</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/125883578</guid><author>i_mycode</author><pubDate>Wed, 20 Jul 2022 01:08:36 +0800</pubDate><description><![CDATA[shell运算符概览]]></description><category></category></item><item><title><![CDATA[hiveSql 计算两段时间范围交集的连续每月天数]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/125834337</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/125834337</guid><author>i_mycode</author><pubDate>Sun, 17 Jul 2022 19:27:18 +0800</pubDate><description><![CDATA[HQL计算两段时间范围交集的连续每月天数]]></description><category></category></item><item><title><![CDATA[shell学习-变量]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/125755072</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/125755072</guid><author>i_mycode</author><pubDate>Wed, 13 Jul 2022 01:00:47 +0800</pubDate><description><![CDATA[shell3种变量]]></description><category></category></item><item><title><![CDATA[linux学习-vim编辑器]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/125247648</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/125247648</guid><author>i_mycode</author><pubDate>Sun, 12 Jun 2022 18:05:46 +0800</pubDate><description><![CDATA[vim3种模式下常用命令及操作一文解读]]></description><category></category></item><item><title><![CDATA[13Python基础-总结(五子棋小游戏)]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/123980510</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/123980510</guid><author>i_mycode</author><pubDate>Wed, 06 Apr 2022 01:00:19 +0800</pubDate><description><![CDATA[据说五子棋有必胜落子法？我不信！用python实现五子棋小游戏！]]></description><category></category></item><item><title><![CDATA[12Python基础-集合Set]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/123939068</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/123939068</guid><author>i_mycode</author><pubDate>Sun, 03 Apr 2022 18:05:36 +0800</pubDate><description><![CDATA[打团了！请求集合？快看看python 中的集合如何理解！]]></description><category></category></item><item><title><![CDATA[hiveSql完成递归计算2.0]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/123839678</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/123839678</guid><author>i_mycode</author><pubDate>Thu, 31 Mar 2022 07:00:00 +0800</pubDate><description><![CDATA[hiveSql实现递归思想，计算数据]]></description><category></category></item><item><title><![CDATA[11Python基础-字典Dict]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/123756152</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/123756152</guid><author>i_mycode</author><pubDate>Sat, 26 Mar 2022 17:27:01 +0800</pubDate><description><![CDATA[在Python中查字典？原来python字典如此简单！]]></description><category></category></item><item><title><![CDATA[10Python基础-元组Tuple]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/123753604</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/123753604</guid><author>i_mycode</author><pubDate>Sat, 26 Mar 2022 13:36:50 +0800</pubDate><description><![CDATA[一起了解特殊的列表 -- 元组 Tuple]]></description><category></category></item><item><title><![CDATA[09Python基础-列表List]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/123625181</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/123625181</guid><author>i_mycode</author><pubDate>Mon, 21 Mar 2022 07:00:00 +0800</pubDate><description><![CDATA[一文掌握python3列表的基础知识与使用，满满干货~]]></description><category></category></item><item><title><![CDATA[08Python基础-函数]]></title><link>https://blog.youkuaiyun.com/i_mycode/article/details/123515674</link><guid>https://blog.youkuaiyun.com/i_mycode/article/details/123515674</guid><author>i_mycode</author><pubDate>Wed, 16 Mar 2022 07:00:00 +0800</pubDate><description><![CDATA[一文掌握python3函数知识点，全是干货没有一滴水~]]></description><category></category></item></channel></rss>