To specify a default handling for values within queries, see the documentation.

The FILL keyword expects a single fillOption strategy which will be applied to each aggregate column. The following restrictions apply:

Examples

Consider an example table named prices which has no records during the entire third hour ():

The returned results look like this:

As there are missing values, an average aggregate cannot be calculated for the missing hour:

Based on this example, a FILL strategy can be employed which fills with the previous value using PREV:

This query returns the following results where the fourth row is created by using the FILL keyword:

The results of this query look like the following:

This query demonstrates using a constant value as a fillOption. If a constant value is used as a fillOption, a value must be specified for each aggregate column:

The results of this query look like the following:

This query demonstrates using NULL as a :