<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[WYF209594的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/WYF209594</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; WYF209594]]></copyright><item><title><![CDATA[【数据倾斜】热点数据打散实践]]></title><link>https://blog.youkuaiyun.com/WYF209594/article/details/134588677</link><guid>https://blog.youkuaiyun.com/WYF209594/article/details/134588677</guid><author>WYF209594</author><pubDate>Fri, 24 Nov 2023 00:16:15 +0800</pubDate><description><![CDATA[本文阐述了一种离线数据处理中，数据倾斜打散热点key的思路，供大家参考。]]></description><category></category></item><item><title><![CDATA[MacOS hadoop-2.10.0 + hive-2.3.7 + mysql-5.7.30 hive测试环境搭建]]></title><link>https://blog.youkuaiyun.com/WYF209594/article/details/108684409</link><guid>https://blog.youkuaiyun.com/WYF209594/article/details/108684409</guid><author>WYF209594</author><pubDate>Mon, 01 Feb 2021 17:40:55 +0800</pubDate><description><![CDATA[记录一下本地的hive测试环境安装过程
1. 下载所需安装包，选择编译好的二进制类型即可
hive
hadoop
mysql
jdk
2. 移动到本机的任意目录下，我选择的是 /opt/local/ 下面，解压并重命名文件夹

3. 配置Hadoop

修改配置文件

core-site.xml
&lt;configuration&gt;
    &lt;!-- 指定 HDFS 中 NameNode 的地址 --&gt;
    &lt;property&gt;
        &lt;name&gt;fs]]></description><category></category></item><item><title><![CDATA[获取今日和昨日环比的小技巧]]></title><link>https://blog.youkuaiyun.com/WYF209594/article/details/108084583</link><guid>https://blog.youkuaiyun.com/WYF209594/article/details/108084583</guid><author>WYF209594</author><pubDate>Tue, 18 Aug 2020 18:55:09 +0800</pubDate><description><![CDATA[大致的情况是这样的，有一张记录了每日交易量的一张表，如下所示：
with main as (
select '2020-08-01' as date_str,30   as amt 
union all 
select '2020-08-02' as date_str,500  as amt 
union all 
select '2020-08-04' as date_str,700  as amt 
union all 
select '2020-08-05' as date_str,1000 as a]]></description><category></category></item><item><title><![CDATA[从用户登录日志表获取连续N天登陆的用户]]></title><link>https://blog.youkuaiyun.com/WYF209594/article/details/107020978</link><guid>https://blog.youkuaiyun.com/WYF209594/article/details/107020978</guid><author>WYF209594</author><pubDate>Mon, 29 Jun 2020 19:19:00 +0800</pubDate><description><![CDATA[具体问题如下：
有一张用户登陆日志表，我们姑且称之为 user_login_table ，示例内容如下




user_id
login_date




A
2020-06-01


A
2020-06-02


A
2020-06-03


A
2020-06-04


A
2020-06-05


A
2020-06-07


A
2020-06-08


A
2020-06-09


A
2020-06-10


A
2020-06-11


A
2020-06-12


A
2020-06-13]]></description><category></category></item><item><title><![CDATA[MacOS10.14下安装MySQL5.7.29过程详细记录]]></title><link>https://blog.youkuaiyun.com/WYF209594/article/details/105807430</link><guid>https://blog.youkuaiyun.com/WYF209594/article/details/105807430</guid><author>WYF209594</author><pubDate>Tue, 28 Apr 2020 11:04:24 +0800</pubDate><description><![CDATA[俗话说：好记性不如烂笔头，记下来安装过程，节省后续的安装时间
第一步：下载MySQL安装包，tar.gz格式的
附地址：mysql官方下载地址
记得点选下图红框中的链接来下载历史版本

第二步：解压安装包
解压并移动到 /usr/local/Cellar/mysql/ 目录下
tar -zxvf mysql-5.7.29-macos10.14-x86_64.tar.gz
mv mysql-5.7....]]></description><category></category></item></channel></rss>