-- 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 id,prom.time('2024-01-02','2024-01-03') from ( -- 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) -- **/ -- ;