hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-1304) add row_sequence UDF
Date Tue, 13 Apr 2010 21:31:49 GMT
add row_sequence UDF

                 Key: HIVE-1304
                 URL: https://issues.apache.org/jira/browse/HIVE-1304
             Project: Hadoop Hive
          Issue Type: New Feature
          Components: Metastore
    Affects Versions: 0.6.0
            Reporter: John Sichi
            Assignee: John Sichi
             Fix For: 0.6.0

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.
If you think it was sent incorrectly contact one of the administrators: https://issues.apache.org/jira/secure/Administrators.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira


View raw message