odbtools/odbctest/mql/test/subscribe/0.subscribe.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)
**/
;