Re: Percentile window function in apache drill

2019-08-12 Thread Aman Sinha
Drill currently supports the ranking window functions [1] but not specifically the percentile function. [1] https://drill.apache.org/docs/ranking-window-functions/ On Mon, Aug 12, 2019 at 7:34 AM Ted Dunning wrote: > Currently, the way to do this is with window queries where you sort each > su

Re: Percentile window function in apache drill

2019-08-12 Thread Ted Dunning
Currently, the way to do this is with window queries where you sort each sub-group and grab the pertinent rows as an approximation of the quantiles you want. Another way would be to use an approximate data structure like a t-digest via an aggregating user-defined function (UDF). Last I checked, t