hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Namit Jain (JIRA)" <j...@apache.org>
Subject [jira] Updated: (HIVE-1304) add row_sequence UDF
Date Wed, 23 Jun 2010 07:17:50 GMT

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

Namit Jain updated HIVE-1304:

          Status: Resolved  (was: Patch Available)
    Hadoop Flags: [Reviewed]
      Resolution: Fixed

Committed. Thanks John

> add row_sequence UDF
> --------------------
>                 Key: HIVE-1304
>                 URL: https://issues.apache.org/jira/browse/HIVE-1304
>             Project: Hadoop Hive
>          Issue Type: New Feature
>          Components: Query Processor
>    Affects Versions: 0.6.0
>            Reporter: John Sichi
>            Assignee: John Sichi
>             Fix For: 0.7.0
>         Attachments: HIVE-1304.1.patch, HIVE-1304.2.patch, HIVE-1304.3.patch
> This is a poor man's answer to the standard analytic function row_number(); it assigns
a sequence of numbers to rows, starting from 1.
> I'm calling it row_sequence() to distinguish it from the real analytic function, so that
once we add support for those, there won't be any conflict with the existing UDF.
> The problem with this UDF approach is that there are no guarantees about ordering in
SQL processing internals, so use with caution.

This message is automatically generated by JIRA.
You can reply to this email to add a comment to the issue online.

View raw message