Having a column with type array, it aggregates all the results for that column by running the provided aggregation functions for each vertical slice of the array elements.
Having a column with type array, it aggregates all the results for that column by running the provided aggregation functions for each vertical slice of the array elements. Therefore, for the query result: \array_col| |[x1, y1, z1, u1] |[x2, y2, z2] |[x3, y3, z3]
if you run sumForEach(array_col) you will get an array result with the following entries: [sum(x1,x3,x3), sum(y1,y2,y3), sum(z1, z2, z3), sum(u1)]
This function will push back the timestamp represented by tableColumn to the start of this interval, this happens deterministically.
This function will push back the timestamp represented by tableColumn to the start of this interval, this happens deterministically.
Meaning that as long as the duration is the same, your groups will be in the same from/to timestamps
This is useful for aggregating results by periods of time (group by month, 2 months, days, etc.)