In a measurement I have typicaly between 10 and 50 fields.

(A device sending telemetry data like temperature, speed, downtime,…)

After 2 weeks I want to downsample the data to a large aggregate, e.g. 12h. In order to loose not that much information I take the mean, median, min, max, sum, count to the target measurement such that Iam able to calcuclate the e.g. sum over a larger time span…

CREATE CONTINUOUS QUERY …

RESAMPLE EVERY 30m

BEGIN

SELECT mean(*), sum(*), median(*),… INTO …

END

Is there any limitation in number of fields. Because in the approach above I will have much more fields in the second measurement as in the first one.