pig-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Allan Avendaño (JIRA) <j...@apache.org>
Subject [jira] [Commented] (PIG-2353) RANK function like in SQL
Date Tue, 22 May 2012 11:02:41 GMT

    [ https://issues.apache.org/jira/browse/PIG-2353?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13280877#comment-13280877

Allan Avendaño commented on PIG-2353:

Hi to everybody,

I am working on this functionality for GSOC 2012, with Gianmarco as my mentor. 
I had been working on syntax, and now is recognized this syntax, recommended by Gianmarco:

RANK <relation> ( BY <column> (ASC|DES)? )?

I was also looking for some other functionality that can be incorporated, and on SQL Server,
Oracle and Postgresql [1][2][3], it is also possible to specify a "partition" (ranking over
a specific group) at the same rank operation. Gianmarco already pointed me out that it could
imply some performance flaws. 

Looking forward for yours feedback/suggestion.


[1] http://msdn.microsoft.com/en-us/library/ms176102.aspx
[2] http://www.techonthenet.com/oracle/functions/rank.php
[3] http://www.postgresql.org/docs/9.1/static/tutorial-window.html
> RANK function like in SQL
> -------------------------
>                 Key: PIG-2353
>                 URL: https://issues.apache.org/jira/browse/PIG-2353
>             Project: Pig
>          Issue Type: New Feature
>            Reporter: Gianmarco De Francisci Morales
>            Assignee: Allan Avendaño
>              Labels: gsoc2012, mentor
>         Attachments: PIG2353.patch
> Implement a function that given a (sorted) bag adds to each tuple a unique, increasing
identifier without gaps, like what RANK does for SQL.
> This is a candidate project for Google summer of code 2012. More information about the
program can be found at https://cwiki.apache.org/confluence/display/PIG/GSoc2012

This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message