[
https://issues.apache.org/jira/browse/CALCITE-5375?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Dmitry Sysolyatin updated CALCITE-5375:
---------------------------------------
Description:
A lot of modern timeseries databases support gap filling and interpolation.
For example:
* Clickhouse has "ORDER BY WITH FILL [INTERPOLATE]" [1] 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://clickhouse.com/docs/en/sql-reference/statements/select/order-by/#order-by-expr-with-fill-modifier
[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]
was:
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]
> 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
> Priority: Major
>
> A lot of modern timeseries databases support gap filling and interpolation.
> For example:
> * Clickhouse has "ORDER BY WITH FILL [INTERPOLATE]" [1] 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://clickhouse.com/docs/en/sql-reference/statements/select/order-by/#order-by-expr-with-fill-modifier
> [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)
