Queries throw error while using ceil(), floor() and round() function.
For Example:
the query:
select ceil(fieldKey) from rt.meas group by tag order by time desc limit 1
throws error:
ERR: undefined function ceil()
Please help
Queries throw error while using ceil(), floor() and round() function.
For Example:
the query:
select ceil(fieldKey) from rt.meas group by tag order by time desc limit 1
throws error:
ERR: undefined function ceil()
Please help
Not sure about the error, but you cannot use whose functions directly with a “group by” since those functions do not aggregate data.
A valid syntax should be ie: (Docs here)
SELECT CEIL( MEAN(fieldKey) ) from rt.meas GROUP BY tag ORDER BY time DESC LIMIT 1
This topic was automatically closed 60 minutes after the last reply. New replies are no longer allowed.