1.定义预警类
Data
public class WarnLogParams implements Serializable {/*** 系统编码*/private String systemCode;/*** 模块名称*/private String moduleName;/*** 哪些级别的日志需要告警,如果不配置,则取告警收集器日志级别(ERROR,WARN,INFO)*/p…
SQL :
SELECT COUNT(1), tid, sap_do, batch, skucode,batch
FROM lt
WHERE IFNULL(sap_do, ) !
AND created_time > 1722441600
GROUP BY tid, sap_do, skucode
HAVING COUNT(1) > 1
AND batch IS NULL; 查询结果为空;实际数据库存在batc…