Below is the schema for the athena table
I wish to calculate median for 'parameter_value' group by standard_lab_parameter_name & units. For this I followed link : https://docs.aws.amazon.com/redshift/latest/dg/r_MEDIAN.html But on running the query
select median(parameter_value) from table_name group by standard_lab_parameter_name, units
It throws error
SYNTAX_ERROR: line 1:8: Function median not registered
Any help? Or if some alternative query would be great