[jira] [Created] (CALCITE-5375) Support gapfilling and interpolation

["Dmitry Sysolyatin (Jira)" <ji...@apache.org>]

Dmitry Sysolyatin created CALCITE-5375:
------------------------------------------

             Summary: Support gapfilling and interpolation
                 Key: CALCITE-5375
                 URL: https://issues.apache.org/jira/browse/CALCITE-5375
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: Dmitry Sysolyatin


A lot of modern timeseries databases support gap filling and interpolation. 
For example:
 * Clickhouse has "ORDER BY WITH FILL [INTERPOLATE]" operator
 * Timescaledb has time_bucket_gapfill [2] and interpolate [3] functions
 * Vertica has TIMESERIES clause [4]

It would be good if calcite also supports gapfilling and interpolation. Most probably the best syntax for that is Vertica's TIMESERIES Clause [4].



[1] [https://docs.timescale.com/api/latest/hyperfunctions/gapfilling-interpolation/interpolate/]
[2] [https://docs.timescale.com/api/latest/hyperfunctions/gapfilling-interpolation/time_bucket_gapfill/]
[3] [https://docs.timescale.com/api/latest/hyperfunctions/gapfilling-interpolation/interpolate/]
[4] [https://www.vertica.com/docs/11.1.x/HTML/Content/Authoring/SQLReferenceManual/Statements/SELECT/TIMESERIESClause.htm]



--
This message was sent by Atlassian Jira
(v8.20.10#820010)