You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@calcite.apache.org by "Dmitry Sysolyatin (Jira)" <ji...@apache.org> on 2022/11/10 14:41:00 UTC
[jira] [Updated] (CALCITE-5375) Support gapfilling and interpolation
[ 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)