The following examples illustrate each of the fill schemes. All the examples use the same initial query (see Table and Data Definition for Time Series Aggregates Examples), which is missing values for timebuckets 1, 3, 6, 7, 8. The missing timebuckets are shown in the table, although by default (without a FILL clause), they are omitted.
SELECT $TD_TIMECODE_RANGE, $TD_GROUP_BY_TIME, BUOYID, AVG(TEMPERATURE) FROM OCEAN_BUOYS WHERE TD_TIMECODE BETWEEN TIMESTAMP '2014-01-06 09:45:00' AND TIMESTAMP '2014-01-06 11:45:00' AND BUOYID=44 GROUP BY TIME (MINUTES(15) AND BUOYID) ORDER BY 2,3;
TIMECODE_RANGE | GROUP BY TIME(MINUTES(15)) | BUOYID | AVG(TEMPERATURE) |
---|---|---|---|
('2014-01-06 09:45:00.000000+00:00', '2014-01-06 10:00:00.000000+00:00') | 1 | 44 | MISSING! |
('2014-01-06 10:00:00.000000+00:00', '2014-01-06 10:15:00.000000+00:00') | 2 | 44 | 49 |
('2014-01-06 10:15:00.000000+00:00', '2014-01-06 10:30:00.000000+00:00') | 3 | 44 | MISSING! |
('2014-01-06 10:30:00.000000+00:00', '2014-01-06 10:45:00.000000+00:00') | 4 | 44 | 43 |
('2014-01-06 10:45:00.000000+00:00', '2014-01-06 11:00:00.000000+00:00') | 5 | 44 | 43 |
('2014-01-06 11:00:00.000000+00:00', '2014-01-06 11:15:00.000000+00:00') | 6 | 44 | MISSING! |
('2014-01-06 11:15:00.000000+00:00', '2014-01-06 11:30:00.000000+00:00') | 7 | 44 | MISSING! |
('2014-01-06 11:30:00.000000+00:00', '2014-01-06 11:45:00.000000+00:00') | 8 | 44 | MISSING! |