how to calculate median in Hive

Use the following function :


percentile(BIGINT col, p)

and set p to be 0.5


Will calculate median :)