Gini coefficient in hive by group
I have a table with three columns group
, person
, score
I would like to calculate the Gini coefficient for score
per group. So that I can measure the inequality of persons based on score
What is the most efficient way to do this?