Hi , impala dev!

  Can you help me to implement approx_percentile.

Impala UDAF:
https://github.com/cloudera/impala-udf-samples

Like:
https://impala.apache.org/docs/build/html/topics/impala_appx_median.html

SQL Like:
select approx_percentile(c1, 0.1) from test_table;

Python Like:
import numpy as np

a = np.array([1,2,3,4,5,6,7,8,9,10])

print(np.median(a))
print(np.percentile(a,10))
print(np.percentile(a,20))
print(np.percentile(a,30))
print(np.percentile(a,40))
print(np.percentile(a,50))
print(np.percentile(a,60))
print(np.percentile(a,70))
print(np.percentile(a,80))
print(np.percentile(a,90))

Thank you very much.

Reply via email to