It seems like there is no native function for that purpose in Presto SQL. Do you know any way to efficiently aggregate a group and return its median?
approx_percentile()
should be a reasonable approach. Assuming a table like mytable(id, val)
, that you want to aggregate by id
:
select id, approx_percentile(val, 0.5) median_val
from mytable
group by id
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With