Re: Implementation of ORDER BY WITH FILL [INTERPOLATE]

Julian, Good point, I didn't think about it. I have created jira ticket - https://issues.apache.org/jira/browse/CALCITE-5375 On Tue, Nov 8, 2022 at 10:02 PM Julian Hyde wrote: > Dmitry, > > Can you please log a bug for the proposed ‘ORDER BY WITH FILL’ syntax. > Link it to

Re: Implementation of ORDER BY WITH FILL [INTERPOLATE]

Dmitry, Can you please log a bug for the proposed ‘ORDER BY WITH FILL’ syntax. Link it to https://issues.apache.org/jira/browse/CALCITE-2640 , which is the only outstanding issue for time series support. Julian > On Nov 8, 2022, at 10:00

Re: Implementation of ORDER BY WITH FILL [INTERPOLATE]

I think of this topic in 3 areas: 1. how to extend SQL for interpolation; 2. how to represent interpolation in relational algebra; 3. how to implement the relational operator. Your question was mostly about 3. I think you could add a ‘fill’ or ‘interpolate’ relational operator that assumes a

Implementation of ORDER BY WITH FILL [INTERPOLATE]

Hi! I want to implement ORDER BY WITH FILL [1] functionality. It is similar to time_bucket_gapfill and interpolate functions from timescaledb [2]. I didn't find a way to do it with existing functionality. I have an idea to introduce a PostOrder RelNode and implement EnumerablePostOrder or extend