Impala currently doesn't have percentile functions. Work on those is tracked in IMPALA-3602 and contributions are always welcome. You might be able to get what you need using analytic functions, e.g. NTILE: https://www.cloudera.com/documentation/enterprise/latest/topics/impala_analytic_functions.html#ntile
On Tue, Aug 29, 2017 at 8:39 AM, Gayathri Devi <[email protected]> wrote: > Hi, > > I have a table on hbase i want to query on impala to calculate 95 th and 99 > th percentile? any built in function available or user defined function? >
