数仓
augie_ly
冰冻三尺非一日之寒
展开
-
FlinkCDC作业处理慢追不上binlog产生的速度,导致binlog被清理的解决方案
Caused by: java.lang.IllegalStateException: The connector is trying to read binlog starting at Struct{version=1.6.4.Final,connector=mysql,name=mysql_binlog_source,ts_ms=1668149633760,db=,server_id=0,file=mysql-bin.003889,pos=116719908,row=0}, but this is n原创 2023-02-14 15:49:21 · 3661 阅读 · 0 评论 -
Cause: java.sql.SQLException: No operations allowed after statement closed.
Cause: java.sql.SQLException: No operations allowed after statement closed.原创 2023-02-08 16:29:12 · 1478 阅读 · 0 评论 -
数仓分析需要了解的5大SQL分析函数
基本语法analytic_function_name([argument_list])OVER ([PARTITION BY partition_expression,…][ORDER BY sort_expression, … [ASC|DESC]])analytic_function_name: 函数名称 — 比如 RANK(), SUM(), FIRST()等等 partition_expression: 分区列 sort_expression: 排序列案例数据准备原创 2020-11-26 19:56:19 · 722 阅读 · 0 评论