Window Function CUME_DIST()

The following program shows the query for this function −

Query

0: jdbc:drill:zk = local> select name,age,gender,cume_dist() over (order by age) as
   relative_rank from dfs.`/Users/../workspace/Drill-samples/student_list.json`;

Result

name   age gender relative_rank
Adam   12   male      0.7
Amit   12   male      0.7
Bob    12   male      0.7
David  12   male      0.7
Esha   12  female     0.7
Ganga  12  female     0.7
Leena  12  female     0.7
Jack   13   male      1.0
Mary   13  female     1.0
Peter  13  female     1.0

Kickstart Your Career

Get certified by completing the course

Get Started