Does CnosDB support nested subqueries with aggregate functions or any equivalent solution?

Question

Currently, I cannot do this in CnosQL:

SELECT mean(max("speed")) FROM "wind" GROUP BY time(1m)

I would like to count the average value of the maximum speed per minute over a period of time.

What else have you tried? Can you use a subquery? – tconbeer Jun 01 '22 at 16:25 — tconbeer, Jun 01 '22 at 16:25

score 1 · Answer 1 · answered Jun 28 '22 at 15:24

1

Apparently, CnosDB supports nested subqueries with aggregate functions. You can try with

SELECT MEAN("max") FROM (SELECT MAX("speed") FROM "wind" GROUP BY time(1m) )

You use the wrong syntax of nested subqueries with aggregate functions.

The right syntax is:

SELECT_clause FROM ( SELECT_clause FROM ( SELECT_statement ) [...] ) [...]

Maybe you can try this again.

answered Jun 28 '22 at 15:24

xmh

score 0 · Answer 2 · edited May 31 '22 at 11:55

0

I think that it supports. However, your query seems problematic for adding "" for the measurement name. TRY：

SELECT mean(max("speed")) FROM wind GROUP BY time(1m)

edited May 31 '22 at 11:55

Sagar Darekar

answered May 31 '22 at 03:55

lux0106

2 Answers2