search

timescale / docs.timescale.com-content

Content pages for TimescaleDB documentation
https://docs.timescale.com
37 stars 51 forks source link

[Update] Clarify gapfill for other grouping columns #473

Open k-rus opened 4 years ago

k-rus commented 4 years ago

If a query contains more grouping columns than just time_bucket_gapfill the gaps on the other grouping values will be filled. It is good to explain how the values are filled and to give an example.

Example, query:

SELECT time_bucket_gapfill('3 hours', time, '2017-01-01 06:00', '2017-01-02 18:00'),
       device,
       first(value, time),
       avg(value)
FROM disttable
GROUP BY 1,2;
solugebefola commented 3 years ago

Following up on this issue. Is it still outstanding?