Example: FILL Clause is Omitted - Advanced SQL Engine - Teradata Database

If there are timebuckets in the source data with missing values and the FILL clause is omitted, the timebuckets with missing values are omitted from the result set.

The example shows the results of a query when the FILL clause is omitted and there is missing data in the source table:

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;

Result: