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

✨ Tired of the same old Windows Start Menu and Taskbar?

  ✨ Tired of the same old Windows Start Menu and Taskbar? In this video, I’ll show you how to completely customize your Windows experience ...

  • HBase MapReduce Read/Write Example
    Configuration config = HBaseConfiguration.create(); Job job = new Job(config,"ExampleReadWrite"); job.setJarByClass(MyReadWriteJo...
  • 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 :  ...