Re: Median in Hive

2012-04-18 Thread sonia gehlot
Great, Thanks Roberto. On Wed, Apr 18, 2012 at 3:42 PM, Roberto Sanabria wrote: > Sure, use this function: > > percentile(BIGINT col, p) > > and set p to be 0.5 > > Cheers, > R > > On Wed, Apr 18, 2012 at 3:32 PM, sonia gehlot wrote: > >> Hi Guys, >>

Re: Median in Hive

2012-04-18 Thread Roberto Sanabria
Sure, use this function: percentile(BIGINT col, p) and set p to be 0.5 Cheers, R On Wed, Apr 18, 2012 at 3:32 PM, sonia gehlot wrote: > Hi Guys, > > Any idea, how to calculate median in Hive? Do we have any inbuilt function > for it? > > Thanks for any help. > > Sonia >