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

Warp AI Terminal 🔥 | The Future of Coding? Agentic Dev Environment Explained!

  Warp AI Terminal 🔥 | The Future of Coding? Agentic Dev Environment Explained! What if your terminal could think, assist, and even act li...