4 ms·
Half of this article is the author not knowing SQL. Aggregating by day or week is trivial (and doesn't require subqueries) in any database. It goes on to say "R
by hipadev23 3y ago
Half of this article is the author not knowing SQL. Aggregating by day or week is trivial (and doesn't require subqueries) in any database. It goes on to say "Range queries, a single data point may be aggregated into multiple groups" -- standard SQL window functions meet this criteria too.
I think the only thing somewhat novel here is interpolating for missing values.
- zX41ZdbW 3y agoI doubt it is novel. For example, ClickHouse has the WITH FILL modifier for ORDER BY: https://clickhouse.com/docs/en/sql-reference/statements/select/order-by#order-by-expr-with-fill-modifier https://clickhouse.com/docs/en/sql-reference/statements/sele...
- deleted 3y ago[deleted]
- taylor_lagrange 3y agoWe 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 base on time series data.
- DennisZ_89 3y agoThanks 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 :)