Re:Unlock Complex Time Series Analysis in SQL with Range Que...
by zX41ZdbW on Wednesday December 27, 2023 @04:26AM
(#38780414)
I doubt it is novel. For example, ClickHouse has the WITH FILL modifier for ORDER BY: https://clickhouse.com/docs/en/sql-reference/statements/sele...
Re:Unlock Complex Time Series Analysis in SQL with Range Que...
by DennisZ_89 on Friday December 29, 2023 @03:15AM
(#38802740)
Thanks for your reply, I don‘t mean that the original SQL cannot do this kind of query, but using standard SQL to do such a query will be very complicated and inconsistent with user intuition.
What we have done is to provide an extended syntax of SQL so that users can more intuitively describe the query logic of aggregation based on time series data. But always open to discussions and feedback :)
I think the only thing somewhat novel here is interpolating for missing values.