-
Notifications
You must be signed in to change notification settings - Fork 61
Open
Labels
feature-requestAnd area of analysis that could be made easierAnd area of analysis that could be made easier
Description
What problem does the new feature solve?
LTTB is a very useful function that downsamples data. However, it only returns the time
and the value
from the downsampled rows. It would be very useful to have access to the values of other columns from the downsampled rows.
What does the feature do?
perhaps something like
SELECT
grouping_column,
(lttb_data).time,
(lttb_data).value,
(lttb_data).non_grouping_column_value
FROM (
SELECT
grouping_column,
UNNEST(lttb(time, float_value, $<nPoints>)) AS lttb_data
FROM hypertable
GROUP BY grouping_column
)
Implementation challenges
No response
jonatas and cohuebn
Metadata
Metadata
Assignees
Labels
feature-requestAnd area of analysis that could be made easierAnd area of analysis that could be made easier