WebHosting

Thursday, April 19, 2012

how to calculate median in Hive

Use the following function which is built in 


percentile(BIGINT col, p)

and set p to be 0.5



and will calculate the median




credit : roberto@stumbleupon.com

No comments:

Post a Comment

Thank you for Commenting Will reply soon ......

Featured Posts

How to Enable and Configure Remote Desktop (RDP) on Ubuntu 24.04.4 LTS

Remote Desktop Protocol (RDP) support in Ubuntu has become considerably easier with the GNOME Remote Desktop stack included in modern Ubuntu...