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
Posted by at
Labels:

No comments:

Post a Comment

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

Subscribe to: Post Comments (Atom)

Featured Posts

#Linux Commands Unveiled: #date, #uname, #hostname, #hostid, #arch, #nproc

 #Linux Commands Unveiled: #date, #uname, #hostname, #hostid, #arch, #nproc Linux is an open-source operating system that is loved by millio...

  • Hadoop : Hive
    Hadoop is a batch processing system, and Hadoop jobs tend to have high latency and incur substantial overhead in job submission and sched...
  • Print a triangle using shell script
    Print numbers in order : #!/bin/bash for i in $(seq 0 4) do for j in  $(seq $i -1 0) do     echo -n $j done echo done Will gi...