查看是否开启事件
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}…
开发环境 VS Code版本:1.93.0 (Windows) Ubuntu版本:20.04 使用VS Code 插件remote-ssh远程访问Ubuntu服务器中的代码,若Ubuntu无法联网,在连接的时候会报错:
Could not establish connection to "xxxx": F…