[
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.
References:
[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
