<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[m0_50243264的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/m0_50243264</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; m0_50243264]]></copyright><item><title><![CDATA[Excel时间格式转换Hive实战技巧]]></title><link>https://blog.youkuaiyun.com/m0_50243264/article/details/149535831</link><guid>https://blog.youkuaiyun.com/m0_50243264/article/details/149535831</guid><author>m0_50243264</author><pubDate>Tue, 22 Jul 2025 15:13:05 +0800</pubDate><description><![CDATA[Hive时间类型数据在导出为CSV时会被转为Excel格式（斜杠连接符、去除前导零），再导入Hive时无法自动识别为日期类型。解决方法是通过HQL函数将连接符替换为横杠，并利用date_format函数统一格式：select date_format(translate('2025/6/2','/','-'),'yyyy-MM-dd')。该方法比补零方案效率更高，能快速将转换后的字符串转为Hive可识别的标准日期格式。]]></description><category></category></item><item><title><![CDATA[hivejoin过程中热点数据倾斜的一种解决方案]]></title><link>https://blog.youkuaiyun.com/m0_50243264/article/details/139142253</link><guid>https://blog.youkuaiyun.com/m0_50243264/article/details/139142253</guid><author>m0_50243264</author><pubDate>Thu, 23 May 2024 11:29:32 +0800</pubDate><description><![CDATA[大表join小表，默认使用mapjoin。数据倾斜调整map和reduce数量。]]></description><category></category></item><item><title><![CDATA[在liunx中执行hql文件并传参]]></title><link>https://blog.youkuaiyun.com/m0_50243264/article/details/130381838</link><guid>https://blog.youkuaiyun.com/m0_50243264/article/details/130381838</guid><author>m0_50243264</author><pubDate>Wed, 26 Apr 2023 14:44:43 +0800</pubDate><description><![CDATA[hive执行hql文件并传参，遍历执行区域时间范围内的hql文件。]]></description><category></category></item></channel></rss>