odbtools/odbctest/mql/basic/10pubsub/1.sub.mql

-- 订阅MQL语句 --
-- /**
-- subscribe({
--     "topic": "mql",
--     "request": {
--         "mql1": {
--             "mql": "
-- select count(*),min(vtime) as minvtime,max(vtime),sum(vtime),avg(vtime),day,node,status
--  from /cache/alerts_status
--  where status>=100 and status <=300 and node!='node:node:192.168.0.11'
--  group by day
-- ",
--             "interval": "3s",
--         },
--         "mql2": {
--             "mql": "
-- select count(*),min(vtime) as minvtime,max(vtime),sum(vtime),avg(vtime),day,node,status
--  from /cache/alerts_status
--  where status>=100 and status <=300 and node=='node:node:192.168.0.11'
--  group by day
-- ",
--             "interval": "3s",
--         },
--         "mql3": {
--             "mql": "
-- select count(*),min(vtime) as minvtime,max(vtime),sum(vtime),avg(vtime),day,node,status
--  from /cache/alerts_status
--  where status<100
--  group by day
-- ",
--             "interval": "5s",
--         },
--         "mql4": {
--             "mql": "
-- select count(*),min(vtime) as minvtime,max(vtime),sum(vtime),avg(vtime),day,node,status
--  from /cache/alerts_status
--  where status>300
--  group by day
-- ",
--             "interval": "2s",
--         },
--     },
-- })
-- sleep(100000d)
-- **/
;