Wire up DERIVATIVE aggregate

[pauldix]

If the query is like this:

SELECT DERIVATIVE(value)
FROM cpu
WHERE time > now() - 4h

It will compute the rate of change between each data point.

If the query is like this:

SELECT DERIVATIVE(MEAN(value))
FROM cpu
WHERE time > now() - 4h
GROUP BY time(5m)

It will take the rate of change of the mean of 5 minute buckets of time.

[CMGS]

so where is derivative?

[regit]

+1 or is there another way to access to derivative/speed on data ?

[anandmani-lab49]

I am using rc25 and I don't see the derivative function. Get the following error:
ERROR: {"results":[{"error":"function not found: "DERIVATIVE""}]}
Here is my query:
SELECT DERIVATIVE(value) FROM "my.series" WHERE time > now() - 15m GROUP BY time(10s) ORDER BY asc
Any ideas please?

[otoolep]

@anandmani-lab49 -- keep an eye on this ticket. Once the functions are implemented, this ticket will be closed.