<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[longduohongchen的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/longduohongchen</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; longduohongchen]]></copyright><item><title><![CDATA[RocketMQ练习]]></title><link>https://blog.youkuaiyun.com/longduohongchen/article/details/127199478</link><guid>https://blog.youkuaiyun.com/longduohongchen/article/details/127199478</guid><author>longduohongchen</author><pubDate>Fri, 07 Oct 2022 21:21:24 +0800</pubDate><description><![CDATA[【代码】RocketMQ练习。]]></description><category></category></item><item><title><![CDATA[查找某目录下的所有文件中哪个文件存在某个数据]]></title><link>https://blog.youkuaiyun.com/longduohongchen/article/details/121677643</link><guid>https://blog.youkuaiyun.com/longduohongchen/article/details/121677643</guid><author>longduohongchen</author><pubDate>Thu, 02 Dec 2021 15:04:14 +0800</pubDate><description><![CDATA[find ./ -name '*' | xargs grep "tmp"


]]></description><category></category></item><item><title><![CDATA[拉链表实现]]></title><link>https://blog.youkuaiyun.com/longduohongchen/article/details/113245825</link><guid>https://blog.youkuaiyun.com/longduohongchen/article/details/113245825</guid><author>longduohongchen</author><pubDate>Wed, 27 Jan 2021 12:31:01 +0800</pubDate><description><![CDATA[每日全量跑批
select 
id,
status,
start_time,
nvl(date_sub(next_time,1),'9999-12-31') as endtime 
from (select id,
status,
updatetime as start_time,
lead(updatetime,1,null) over (partition by id order by updatetime) as next_time 
from order) tmp


]]></description><category></category></item><item><title><![CDATA[补数据逻辑]]></title><link>https://blog.youkuaiyun.com/longduohongchen/article/details/110292989</link><guid>https://blog.youkuaiyun.com/longduohongchen/article/details/110292989</guid><author>longduohongchen</author><pubDate>Mon, 07 Dec 2020 16:08:47 +0800</pubDate><description><![CDATA[1。先分组entid，对日期进行排序   self_rn
2。然后根据entid，（空值，非空值）分组，对时间排序（主要是求出空值分组内的日期排序）字段 为 null_rn
3。根据entid，（self_rn-null_rn排序(空值的情况下),非空赋值负数） 排序得出步长
4。自关联，如果非空，取本身。空值，减步长之后自关联，取关联的值。
with t as (
select entid,
`month`,
val,
self_rn,
row_number() over(partition by ent]]></description><category></category></item><item><title><![CDATA[etl实现上下游依赖的一种脚本]]></title><link>https://blog.youkuaiyun.com/longduohongchen/article/details/110632680</link><guid>https://blog.youkuaiyun.com/longduohongchen/article/details/110632680</guid><author>longduohongchen</author><pubDate>Fri, 04 Dec 2020 12:13:24 +0800</pubDate><description><![CDATA[now=`date +%Y%m%d`
# now=20201205
while true
do
    partitions=$(hive -e "show partitions dm_tag.dwl_pubsentiment_st_day_zp" | grep -v WARN)
    if [[ $partitions == *$now* ]]
    then
        echo "包含"
        last_ddl_all=$(echo `hive -e "desc formatted ]]></description><category></category></item><item><title><![CDATA[Hadoop单机版安装]]></title><link>https://blog.youkuaiyun.com/longduohongchen/article/details/108166386</link><guid>https://blog.youkuaiyun.com/longduohongchen/article/details/108166386</guid><author>longduohongchen</author><pubDate>Sat, 22 Aug 2020 13:11:44 +0800</pubDate><description><![CDATA[Hadoop单机版安装
0.将某个root权限文件夹(/opt)赋权限给某个非root用户(whh)
sudo chown -R whh /opt
必须配置ssh服务,否则不能启动:https://blog.youkuaiyun.com/longduohongchen/article/details/103245149
首先安装JDK
1.将解压jdk-8u181-linux-x64.tar.gz到/opt
tar -zxvf jdk-8u181-linux-x64.tar.gz -C /opt
2.修改文件夹名称
m]]></description><category></category></item><item><title><![CDATA[Sublime Text3安装sql格式化工具]]></title><link>https://blog.youkuaiyun.com/longduohongchen/article/details/107695794</link><guid>https://blog.youkuaiyun.com/longduohongchen/article/details/107695794</guid><author>longduohongchen</author><pubDate>Thu, 30 Jul 2020 18:06:22 +0800</pubDate><description><![CDATA[Sublime Text3安装sql格式化工具:
1.安装Sublime Text3最新版本(默认preferences没有package control这个菜单)
2.在tools里点击install package(或者command palette… 输入ip点击install package)
3.在preferences点击package control输入clz(安装汉语)
4.在preferences点击package control输入SqlBeautifier(安装格式化插件)
5.设置快]]></description><category></category></item><item><title><![CDATA[配置免密登录]]></title><link>https://blog.youkuaiyun.com/longduohongchen/article/details/103245149</link><guid>https://blog.youkuaiyun.com/longduohongchen/article/details/103245149</guid><author>longduohongchen</author><pubDate>Mon, 25 Nov 2019 20:39:16 +0800</pubDate><description><![CDATA[假定两台主机,一台master,一台slaver.需求使用master主机免密登录slaver主机
思路:将master的公钥配置在slaver主机上
1.在master 主机的doc或者命令行生成公私钥对:ssh-keygen -t rsa.在master主机上会生成公私钥文件夹.
2.将生成的公钥文件夹id_rsa.pub,将其改名为authorized_keys放到slaver主机上的/ro...]]></description><category></category></item></channel></rss>