impala-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Lars Volker ...@cloudera.com>
Subject Re: percentile function in impala
Date Tue, 29 Aug 2017 18:17:11 GMT
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 <gayathrimtechcse@gmail.com>
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?
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message