odbtools/odbctest/mql/basic/24bucket_promdb/1094.subquery.aggr.mql

-- SELECT id,prom.time('2024-01-01 09:09:09.090', '2024-01-03 19:19:19.191').find(name='test1').unit('sum','1d') FROM /test/bucketpromdb where id='bucketpromdb:wecisen1'
-- /**
-- output()
-- matchcount(id, "bucketpromdb:wecisen1", "prom.1.2", 2880, 1)
-- **/
-- ;




-- select count(id),prom.avg().max().sum().count().min() from (
-- SELECT id,prom.time('2024-01-02 00:00:00', '2024-01-10 00:00:00').find(name='test1').unit('sum','1d') FROM /test/bucketpromdb
-- ) group by prom
-- /**
-- timeout(60m)
-- output()
-- todomatch(id, 3, prom, null)
-- match(count, 3)
-- match(count, 1, "prom.0.2", 2880, "prom.0.8", 23040, "prom.0.11", 8)
-- **/
-- ;


-- select id.count(),prom from (
-- SELECT id,prom.time('2024-01-02 00:00:00', '2024-01-10 00:00:00').find(name='test1').unit('sum','1d') FROM /test/bucketpromdb
-- ) group by prom
-- /**
-- timeout(60m)
-- output()
-- todomatch(id, 3, prom, null)
-- match(id, 3)
-- match(id, 1, "prom.0.2", 2880, "prom.7.2", 2880)
-- **/
-- ;




-- select count(id),prom.avg().max().sum().count().min() from (
-- SELECT id,prom.time('2024-01-02 00:00:00', '2024-01-10 00:00:00').find(name='test1').unit('sum','1d') FROM /test/bucketpromdb
-- ) group by prom
-- /**
-- timeout(60m)
-- output()
-- todomatch(id, 3, prom, null)
-- match(count, 3)
-- match(count, 1, "prom.0.2", 2880, "prom.0.8", 23040, "prom.0.11", 8)
-- **/
-- ;




-- select id.count(),prom.count() from (
-- SELECT id,prom.time('2024-01-02 00:00:00', '2024-01-10 00:00:00').find(name='test1').unit('sum','1d') FROM /test/bucketpromdb
-- ) group by prom
-- /**
-- timeout(60m)
-- output()
-- match(id, 3, "prom.0.2", 0)
-- match(id, 1, "prom.0.2", 8)
-- **/
-- ;