WITH FILL for HogQL

[usualdesigner]

Is your feature request related to a problem?

yes

Please describe.
I want to make a time-series request via HogQL. Is it possible to use WITH FILL for gap filling?

[mariusandra]

Thanks for the request! I've marked it down in our big todo list. We'll definitely implement it, but I can't promise exactly when.

Docs on the feature: https://clickhouse.com/docs/en/sql-reference/statements/select/order-by#order-by-expr-with-fill-modifier

[usualdesigner]

Thanks, @mariusandra !

[isAdrisal]

Hey @mariusandra, this appears marked as completed but I'm not able to get it to work in HogQL. I get a "no viable alernative" error.

Is this query expected to work (as per the linked clickhouse docs)? My use case is for filling date columns to create time series reports. (eg. with fill step interval 1 week).

select value, 'original' as source
from (
    select
        number as value
    from numbers(10)
    where number % 2 = 0
)
order by value with fill from 0 to 10 step 1