Computes a percentile based on a continuous distribution of the column value
This function computes a percentile based on a continuous distribution of the column value. The result is interpolated
and thus may not be equal to any of the actual values in the column. This information was originally provided via
Microsoft’s Transact-SQL Reference Guide. Note: This function may only be used with
numeric data types in Dremio. Null values in the data set are ignored. However any null values in the command (null
fraction or null
order_by_expression) will throw an exception in Dremio.