| 1234567891011 |
- -- bucket filter 作为条件
- -- select xid,xprom,zid,zprom.time('2024-01-02','2024-01-04').find(name='mtz').max().min().avg().sum().count().groupby("name") from (
- -- match (x:mtx) -[:mtx_mtz]-> (z:mtz)
- -- return x.id as xid, z.id as zid, x.xprom as xprom, z.zprom as zprom
- -- ) where zid="mtz:z5" and xprom.time('2024-01-02','2024-01-04').find(name='mtz').max().assert($1=240.24)
- -- /**
- -- output()
- -- match("xprom.0.2",240.24,"zprom.0.3",143.143,"zprom.0.6",48.48,"zprom.0.9",95.95381249999997~95.9538125,"zprom.0.12",9211.565999999997~9211.566,"zprom.0.15",96)
- -- **/
- -- ;
|
