dario-liberman commented on issue #11775:
URL: https://github.com/apache/pinot/issues/11775#issuecomment-1759412122
A traditional SQL query with an example distinct count as aggregation could
look something along these lines:
`
SELECT
DATETIMECONVERT(t1.timestamp, <<granularity-params>>) AS window_start,
DATETIMECONVERT(t1.timestamp, <<granularity-params>>) + INTERVAL
<<window-size>> AS window_end,
COUNT(DISTINCT t2.value) AS aggregation_example
FROM time_series_data t1
JOIN time_series_data t2
ON t2.timestamp BETWEEN window_start AND window_end
GROUP BY window_start
ORDER BY window_start;
`
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
