backup database archivelog all delete input; 当前日志不会切换及备份 RMAN archivelog backup
Yesterday I encountered a problem with a RMAN backup. There were no backups of archivelogs, only datafile backups and archivelogs. So I investigated the issue and f…
文章目录 1. GROUP BY 分组简介示例1) 不使用聚合函数的 GROUP BY2) 使用 SUM() 函数的 GROUP BY3) 结合 JOIN 子句的 GROUP BY4) 使用 COUNT() 函数的 GROUP BY5) 多列 GROUP BY6) 使用日期列的 GROUP BY 2. HAVING 子句简介HAVING 对比 WHEREPostgreSQL HAVING 子句示例1) 使…
查看是否开启事件
SELECT event_scheduler;
SHOW VARIABLES LIKE %event_scheduler%; 开启或关闭事件
SET GLOBAL event_scheduler 1;
SET GLOBAL event_scheduler on; SET GLOBAL event_scheduler 0;
SET GLOBAL event_scheduler off;
创建事件sql
CREATE EVENT IF…
针对的问题:将数仓表中存储的json数组,展开多行后进行分析计算。
--HiveSQL
with tmp_score_table as
(select 202401 as part_id,2024级1班 as part_name,[{"stu_id":"20240101","score_1":99,"score_2":78}…