Finding rank in hive

Question

I have a set of data

alex, 50
anu, 85
limi, 41
sam, 56

I need to find the rank of the students and store it in another column with the rank eg:-

alex    50 3
anu     85 1
limi    41 4
sam     56 2

I tried with the rank function.

SELECT
  a.name, a.mark,
rank() over (ORDER BY a.mark DESC) as rank
FROM
  list a;

please help me. thanks in advance!!

Will this help? http://stackoverflow.com/questions/18156105/hiveql-and-rank/18159383#18159383 — SSaikia_JtheRocker, Nov 26 '13 at 11:30
select name, mark , rank() over (order by mark) as rank from list; ............ this is not working anything wrong with the query ? — user2728024, Nov 26 '13 at 11:54

score 1 · Answer 1 · answered Nov 26 '13 at 12:20

1

this is not working

First thing you need to do when you ask for help is to learn how to ask for help. "It does not work", "it errors" are not proper ways of asking. You need to specify always what error you get or how exactly it does not work. Does it crash? Does it print 'Hello, World!'? Does it make the speakers beep? We're not clairvoyant.

Now, about Window and Analytic functions in HIVE. They were introduced in HIVE 0.11, see HIVE-896. You can read the specification in the Hive Language Manual, including examples.

Make sure you run on Hive 0.11 to start with.

answered Nov 26 '13 at 12:20

Remus Rusanu

288,378
40
442
569

i am sorry for that. am new to the programming side.. its actually showing a syntax error. FAILED: ParseException line 1:25 missing FROM at '(' near '(' in subquery source line 1:26 cannot recognize input near ')' '(' 'over' in subquery source – user2728024 Nov 26 '13 at 13:52
i have tried the same query with different data.. all are showing the same error.. please help me. – user2728024 Nov 26 '13 at 13:56
Do you know what Hive version are you running? – Remus Rusanu Nov 26 '13 at 14:00
am using hive 0.10 only – user2728024 Nov 27 '13 at 06:00

Finding rank in hive

1 Answers1