[jira] [Updated] (PIG-3247) Piggybank functions to mimic OVER clause in SQL

2013-07-19 Thread Alan Gates (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-3247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alan Gates updated PIG-3247:


  Resolution: Fixed
Release Note: Added OVER clause like functionality in Piggybank.
  Status: Resolved  (was: Patch Available)

Patch committed.  Thanks Cheolsoo for the review.

> Piggybank functions to mimic OVER clause in SQL
> ---
>
> Key: PIG-3247
> URL: https://issues.apache.org/jira/browse/PIG-3247
> Project: Pig
>  Issue Type: New Feature
>  Components: piggybank
>Reporter: Alan Gates
>Assignee: Alan Gates
> Fix For: 0.12
>
> Attachments: Over.2.patch, Over.patch
>
>
> In order to test Hive I have written some UDFs to mimic the behavior of SQL's 
> OVER clause.  I thought they would be useful to share.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (PIG-3247) Piggybank functions to mimic OVER clause in SQL

2013-03-26 Thread Alan Gates (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-3247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alan Gates updated PIG-3247:


Attachment: Over.2.patch

A new version of the patch that fixes an error in the percent_rank calculation 
and adds the ability to specify the return type of the Over function.

> Piggybank functions to mimic OVER clause in SQL
> ---
>
> Key: PIG-3247
> URL: https://issues.apache.org/jira/browse/PIG-3247
> Project: Pig
>  Issue Type: New Feature
>  Components: piggybank
>Reporter: Alan Gates
>Assignee: Alan Gates
> Fix For: 0.12
>
> Attachments: Over.2.patch, Over.patch
>
>
> In order to test Hive I have written some UDFs to mimic the behavior of SQL's 
> OVER clause.  I thought they would be useful to share.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (PIG-3247) Piggybank functions to mimic OVER clause in SQL

2013-03-13 Thread Alan Gates (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-3247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alan Gates updated PIG-3247:


Fix Version/s: 0.12
   Status: Patch Available  (was: Open)

> Piggybank functions to mimic OVER clause in SQL
> ---
>
> Key: PIG-3247
> URL: https://issues.apache.org/jira/browse/PIG-3247
> Project: Pig
>  Issue Type: New Feature
>  Components: piggybank
>Reporter: Alan Gates
>Assignee: Alan Gates
> Fix For: 0.12
>
> Attachments: Over.patch
>
>
> In order to test Hive I have written some UDFs to mimic the behavior of SQL's 
> OVER clause.  I thought they would be useful to share.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira


[jira] [Updated] (PIG-3247) Piggybank functions to mimic OVER clause in SQL

2013-03-13 Thread Alan Gates (JIRA)

 [ 
https://issues.apache.org/jira/browse/PIG-3247?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Alan Gates updated PIG-3247:


Attachment: Over.patch

> Piggybank functions to mimic OVER clause in SQL
> ---
>
> Key: PIG-3247
> URL: https://issues.apache.org/jira/browse/PIG-3247
> Project: Pig
>  Issue Type: New Feature
>  Components: piggybank
>Reporter: Alan Gates
>Assignee: Alan Gates
> Attachments: Over.patch
>
>
> In order to test Hive I have written some UDFs to mimic the behavior of SQL's 
> OVER clause.  I thought they would be useful to share.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira