Hello, community and support!
Is it possible to calculate median value like we can do in postgreSQL (maybe any solutions, plans or timelines for this feature)?
select grp_field, percentile_disc(0.5) within group (order by target_col) as median from table group by grp_field
Dremio (it is necessary to create CTE like this ):
with t1 as ( select grp_col, target_col, (count(*) over (partition by grp_col)) / 2 as median_row_number, (row_number() over (partition by grp_col order by target_col)) as ordered_rows from table ) select * from t1 where median_row_number = ordered_rows
also relates to this PERCENTILE_CONT/DISC support?
Hope for your support