dario-liberman commented on issue #11775: URL: https://github.com/apache/pinot/issues/11775#issuecomment-1759101836
In streaming SQL there are also similar workarounds, for example see flink construct here: https://nightlies.apache.org/flink/flink-docs-master/docs/dev/table/sql/queries/window-agg/ I think this approach is very convenient for working with timeseries data, specially when the windowed aggregation can't be done outside as a simple aggregation of individual data points, such as the case with distinct counts. In traditional SQL, it's not an easy query to write, will try and write back. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@pinot.apache.org For additional commands, e-mail: commits-h...@pinot.apache.org