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)
