hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John Sichi (JIRA)" <>
Subject [jira] Updated: (HIVE-1304) add row_sequence UDF
Date Wed, 23 Jun 2010 00:30:52 GMT


John Sichi updated HIVE-1304:

    Status: Patch Available  (was: Open)

New patch with test moved to contrib, and DESCRIBE and EXPLAIN thrown in for good measure.

> add row_sequence UDF
> --------------------
>                 Key: HIVE-1304
>                 URL:
>             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