Home | About | Sematext search-lucene.com search-hadoop.com
 Search Hadoop and all its subprojects:

Switch to Threaded View
Hive >> mail # user >> Re: computing median and percentiles


Copy link to this message
-
Re: computing median and percentiles
the short answer is there is no native hive UDF that solves your unique
case.  That means you have to solve it.
i searched for something like you were looking for myself and found this
general recipe:

http://www.onlinemathlearning.com/median-frequency-table.html

off the top of my head i'm not sure how easy this would be in SQL but i
imagine using ROW_NUMBER() function a clever person could do it. And if not
SQL then perhaps a custom UDF but ultimately you have to do the work and
now you have a potential recipe to follow. :)
On Wed, Mar 19, 2014 at 9:37 PM, Seema Datar <[EMAIL PROTECTED]> wrote: