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

-- select count(id), id.count() from /test/bucketpromdb
-- /**
-- timeout(60m)
-- output()
-- **/
-- ;


-- select id.count(),prom.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()
-- match(id, 3, "prom.0.2", 0)
-- match(id, 1, "prom.0.2", 8)
-- **/
-- ;



-- select id,prom
-- FROM (
-- SELECT * FROM /test/bucketpromdb
-- )
-- /**
-- timeout(60m)
-- output()
-- **/
-- ;






-- 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
-- /**
-- timeout(60m)
-- output()
-- **/
-- ;


select id,prom.avg() from(
    SELECT id,prom.time('2024-01-02 00:00:00', '2024-01-10 00:00:00').avg().groupby('name')
    FROM /test/bucketpromdb
    WHERE  prom.time('2024-01-03 00:00:00', '2024-01-08 00:00:00').avg().groupby('name').assert($1>0)
)
/**
timeout(60m)
output()
**/
;