<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[k5821的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/k5821</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; k5821]]></copyright><item><title><![CDATA[关于在hive中使用udf函数编写sm4加密遇到的问题总结]]></title><link>https://blog.youkuaiyun.com/k5821/article/details/131571867</link><guid>https://blog.youkuaiyun.com/k5821/article/details/131571867</guid><author>k5821</author><pubDate>Thu, 06 Jul 2023 11:34:49 +0800</pubDate><description><![CDATA[在使用java进行udf函数编写的过程中发现，insert select语句 和select 语句在相同的前提条件下，加密出来的中文结果不一致。但如果是使用insert select 语句去查询加密字段，该加密字段是自己传入进去的，那么代码中的日志又会被打印出来。经过测试以及观察打印的日志后发现，如果使用insert select语句去查询加密字段，那么代码中的日志是不被打印的。经验证后，加密后的数据再进行解密发现中文乱码的问题解决。同时，此种情况下的中文加密后再经解密不存在乱码情况。]]></description><category></category></item><item><title><![CDATA[关于sqoop连接各类型数据库开启SSL加密传输]]></title><link>https://blog.youkuaiyun.com/k5821/article/details/131441071</link><guid>https://blog.youkuaiyun.com/k5821/article/details/131441071</guid><author>k5821</author><pubDate>Wed, 28 Jun 2023 17:12:17 +0800</pubDate><description><![CDATA[【代码】关于sqoop连接各类型数据库开启SSL加密传输。]]></description><category></category></item><item><title><![CDATA[POSTGRESQL替换特殊数据符号]]></title><link>https://blog.youkuaiyun.com/k5821/article/details/125484399</link><guid>https://blog.youkuaiyun.com/k5821/article/details/125484399</guid><author>k5821</author><pubDate>Mon, 27 Jun 2022 15:12:32 +0800</pubDate><description><![CDATA[postgresql 替换特殊符号]]></description><category></category></item><item><title><![CDATA[sqoop导出到mysql和postgre语句模板]]></title><link>https://blog.youkuaiyun.com/k5821/article/details/119640888</link><guid>https://blog.youkuaiyun.com/k5821/article/details/119640888</guid><author>k5821</author><pubDate>Thu, 12 Aug 2021 11:57:49 +0800</pubDate><description><![CDATA[将hive数据导出到MySQL
bin/sqoop export \
--connect "jdbc:mysql://IP:3306/test?useUnicode=true&amp;characterEncoding=utf-8"  \
--username 用户名\
--password '密码' \
--table 表名\
--num-mappers 1 \  ##指定map个数 默认为1
--export-dir 'HDFS路径' \
--input-fields-terminated-by "\t]]></description><category></category></item><item><title><![CDATA[MySQL批量查某个库里每张表的数据量]]></title><link>https://blog.youkuaiyun.com/k5821/article/details/119640707</link><guid>https://blog.youkuaiyun.com/k5821/article/details/119640707</guid><author>k5821</author><pubDate>Thu, 12 Aug 2021 11:46:32 +0800</pubDate><description><![CDATA[SELECT table_name,table_rows FROM information_schema.tables
WHERE TABLE_SCHEMA = ‘表名’ ORDER BY table_rows DESC;

]]></description><category></category></item><item><title><![CDATA[SQL进行特殊符号的替换]]></title><link>https://blog.youkuaiyun.com/k5821/article/details/118524599</link><guid>https://blog.youkuaiyun.com/k5821/article/details/118524599</guid><author>k5821</author><pubDate>Tue, 06 Jul 2021 16:56:32 +0800</pubDate><description><![CDATA[SQL进行特殊符号替换
使用replace语句替换换行符：REPLACE(REPLACE(字段名,CHAR(10),’’) as 字段名
退格键 char(8)
制表符tab char(9)
换行 char(10)
回车 char(13)
单引号 char(39)
双单引号 char(34)

]]></description><category></category></item><item><title><![CDATA[load语句报分区could not be cleaned up]]></title><link>https://blog.youkuaiyun.com/k5821/article/details/116588624</link><guid>https://blog.youkuaiyun.com/k5821/article/details/116588624</guid><author>k5821</author><pubDate>Mon, 10 May 2021 10:23:06 +0800</pubDate><description><![CDATA[##load语句问题
在把一个分区删除后，直接使用load语句去进行overwrite into table 会报错
报错如下：

当我将overwrite into table 改称为 into table之后 报错消失，load成功

]]></description><category></category></item></channel></rss>