<?xml version="1.0" encoding="utf-8" ?><rss version="2.0"><channel><title><![CDATA[guoguopython的博客]]></title><description><![CDATA[]]></description><link>https://blog.youkuaiyun.com/guoguopython</link><language>zh-cn</language><generator>https://blog.youkuaiyun.com/</generator><copyright><![CDATA[Copyright &copy; guoguopython]]></copyright><item><title><![CDATA[vue显示pdf]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/140130487</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/140130487</guid><author>guoguopython</author><pubDate>Tue, 02 Jul 2024 16:34:17 +0800</pubDate><description><![CDATA[记录一个vue前端展示pdf的代码，原文：https://www.yisu.com/jc/773865.html。]]></description><category></category></item><item><title><![CDATA[EXCEL设置选择数据高亮显示]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/139789912</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/139789912</guid><author>guoguopython</author><pubDate>Wed, 19 Jun 2024 09:15:59 +0800</pubDate><description><![CDATA[选中。]]></description><category></category></item><item><title><![CDATA[小数银行家算法问题，char(0)问题]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/139053695</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/139053695</guid><author>guoguopython</author><pubDate>Fri, 14 Jun 2024 14:43:28 +0800</pubDate><description><![CDATA[问题介绍：表1是数据来源表，表2是输出表，在select查询数据时，有两列没有数据。而原表是有数据的.用shell脚本执行这个存储过程->写道csv后这两列没数据.第一个建临时表语句这个位置为 ’‘ 空，所以再进行insert，即使有数据，也插不进去，已经被char（0）固定.别建表，因为字段会被写“死”.原因：字符串四舍五入会采用银行家算法.’12.5‘会向偶数舍，13.5会像奇数进.此博客为本人在项目测试中遇到的问题和解决办法，为此记录一下.2.‘’ 写成CAST(‘’ AS CHAR(20))]]></description><category></category></item><item><title><![CDATA[办公快捷键]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/139520423</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/139520423</guid><author>guoguopython</author><pubDate>Fri, 14 Jun 2024 14:41:23 +0800</pubDate><description><![CDATA[要求将所有sheet页，光标跳到最左上角。按Ctrl+HOME ，Ctrl+PageUp/Ctrl+PageDown翻页。]]></description><category></category></item><item><title><![CDATA[vscode项目拉取推送]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/139087807</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/139087807</guid><author>guoguopython</author><pubDate>Fri, 14 Jun 2024 14:39:35 +0800</pubDate><description><![CDATA[选中需要提交的文件，点+号。添加注释コメント変更。]]></description><category></category></item><item><title><![CDATA[mysql-update问题#22007Truncated incorrect DOUBLE value: ‘N‘]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/139680890</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/139680890</guid><author>guoguopython</author><pubDate>Fri, 14 Jun 2024 14:37:51 +0800</pubDate><description><![CDATA[#22007Truncated incorrect DOUBLE value: 'N']]></description><category></category></item><item><title><![CDATA[java抽象类继承]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/139171523</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/139171523</guid><author>guoguopython</author><pubDate>Fri, 24 May 2024 13:17:59 +0800</pubDate><description><![CDATA[java抽象]]></description><category></category></item><item><title><![CDATA[java继承]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/139169779</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/139169779</guid><author>guoguopython</author><pubDate>Fri, 24 May 2024 12:05:27 +0800</pubDate><description><![CDATA[java继承联系]]></description><category></category></item><item><title><![CDATA[shell脚本处理文件]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/139135608</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/139135608</guid><author>guoguopython</author><pubDate>Thu, 23 May 2024 17:26:48 +0800</pubDate><description><![CDATA[添加新员工项目]]></description><category></category></item><item><title><![CDATA[Mysql与Oracle语法差异]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/138277178</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/138277178</guid><author>guoguopython</author><pubDate>Sun, 28 Apr 2024 14:43:21 +0800</pubDate><description><![CDATA[差异
mysql
oracle




时间类型
DateTime
Date


varchar
varchar(n)
varchar2(n)


varchar
decimal(5,1)
Number(5,1)


length
char_length(str)
length(str)


substr(str,start,length)
start要从1开始
start从0或1均可


时间转字符串
date_format(now(),‘%Y-%m-%d’)
to_char(sysdate,‘Y]]></description><category></category></item><item><title><![CDATA[sql 常见语法]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/138276386</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/138276386</guid><author>guoguopython</author><pubDate>Sun, 28 Apr 2024 14:14:11 +0800</pubDate><description><![CDATA[decimal(10,2)中的“2”表示小数部分的位数，如果插入的值未指定小数部分或者小数部分不足两位则会自动补到2位小数，若插入的值小数部分超过了2为则会发生截断，截取前2位小数。WITH语句是一种在SQL中常用的语法，用于创建临时表或视图，以便在后续的查询中使用。“10”指的是整数部分加小数部分的总长度，也即插入的数字整数部分不能超过“10-2”位，否则不能成功插入，会报超出范围的错误。CAST(expr AS type) 是将某种数据类型的表达式显式转换为另一种数据类型。]]></description><category></category></item><item><title><![CDATA[sql开窗函数]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/138274739</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/138274739</guid><author>guoguopython</author><pubDate>Sun, 28 Apr 2024 13:17:26 +0800</pubDate><description><![CDATA[③ dense_rank() – 相同结果排名相同，后续排名顺延，返回结果为 1、2、2、3。② rank() – 相同结果排名相同，后续排名不连续，返回结果为 1、2、2、4。① row_number() – 相同值排名顺延，返回结果1、2、3、4。② count() – 分组求总数。③ min() – 分组求最小值。④ max() – 分组求最大值。⑤ avg() --分组求均值。1）同时具有分组和排序的功能。① sum() – 分组求和。2）不减少原表的行数。]]></description><category></category></item><item><title><![CDATA[大数据集群启动各种命令]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/123381900</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/123381900</guid><author>guoguopython</author><pubDate>Fri, 26 Apr 2024 15:25:00 +0800</pubDate><description><![CDATA[提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

文章目录组件对应进程jps一、zookeeper二、hdfs三、kafka（先启动zk）四、flink2.读入数据总结

组件对应进程jps




组件
进程名




zookeeper











flink
TaskManagerRunner










一、zookeeper
启动：
单机启动：
cd /opt/dtc/software/zooleeper/bin
./zkServer.sh start
查看状.]]></description><category></category></item><item><title><![CDATA[Hive数仓]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/138216524</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/138216524</guid><author>guoguopython</author><pubDate>Fri, 26 Apr 2024 14:49:53 +0800</pubDate><description><![CDATA[内部表数据存储的位置是hive.metastore.warehouse.dir，如果创建内部表时没有指定location，就会在/user/hive/warehouse/下新建一个表目录。数据仓库源头系统的数据表通常会原封不动的存储一份，这称为ODS层，是后续数据仓库加工数据的来源。如果我们创建一个外部表，在删除表之后，只有与表相关的元数据被删除，而不会删除表的内容。特点：在内部表被删除后，表的元数据和表数据都从HDFS中完全删除。内部表，也叫托管表，是Hive在创建表时的默认表。]]></description><category></category></item><item><title><![CDATA[LINUX命令之sed]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/138210980</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/138210980</guid><author>guoguopython</author><pubDate>Fri, 26 Apr 2024 10:50:55 +0800</pubDate><description><![CDATA[现学转载]]></description><category></category></item><item><title><![CDATA[Navicat 连接MySQL数据库出现错误：2059]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/124489242</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/124489242</guid><author>guoguopython</author><pubDate>Fri, 29 Apr 2022 10:06:57 +0800</pubDate><description><![CDATA[Navicat 连接MySQL数据库出现错误：2059 - authentication plugin 'caching_sha2_password'的解决方法]]></description><category></category></item><item><title><![CDATA[使用python-pyhdfs连接hdfs时报错]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/123938946</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/123938946</guid><author>guoguopython</author><pubDate>Sun, 03 Apr 2022 16:02:26 +0800</pubDate><description><![CDATA[ConnectionError: HTTPConnectionPool(host='a', port=50075): Max retries exceeded with url: /webhdfs/v1/logs/pv?op=OPEN&user.name=root&namenoderpcaddress=hdfscluster&offset=0 (Caused by 
NewConnectionError('<urllib3.connection.HTTPConnection object at 0x0000]]></description><category></category></item><item><title><![CDATA[hive静态分区和动态分区]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/123732040</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/123732040</guid><author>guoguopython</author><pubDate>Fri, 25 Mar 2022 11:54:55 +0800</pubDate><description><![CDATA[hive静态分区和动态分区]]></description><category></category></item><item><title><![CDATA[idea+java连接mysql数据库]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/123520234</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/123520234</guid><author>guoguopython</author><pubDate>Wed, 16 Mar 2022 10:56:42 +0800</pubDate><description><![CDATA[idea+java连接mysql数据库]]></description><category></category></item><item><title><![CDATA[Flink消费Kafka数据指定offset的五种模式]]></title><link>https://blog.youkuaiyun.com/guoguopython/article/details/123495827</link><guid>https://blog.youkuaiyun.com/guoguopython/article/details/123495827</guid><author>guoguopython</author><pubDate>Tue, 15 Mar 2022 10:21:18 +0800</pubDate><description><![CDATA[Flink消费Kafka数据指定offset的五种模式]]></description><category></category></item></channel></rss>