Details

    • Type: New Feature New Feature
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 0.7.0
    • Fix Version/s: 0.7.0
    • Component/s: UDF
    • Labels:
      None
    • Hadoop Flags:
      Reviewed

      Description

      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.

      1. HIVE-1304.3.patch
        12 kB
        John Sichi
      2. HIVE-1304.2.patch
        9 kB
        John Sichi
      3. ASF.LICENSE.NOT.GRANTED--HIVE-1304.1.patch
        9 kB
        John Sichi

        Issue Links

          Activity

          John Sichi created issue -
          John Sichi made changes -
          Field Original Value New Value
          Attachment HIVE-1304.1.patch [ 12441655 ]
          John Sichi made changes -
          Component/s Query Processor [ 12312586 ]
          Component/s Metastore [ 12312584 ]
          Jeff Hammerbacher made changes -
          Link This issue is related to HIVE-896 [ HIVE-896 ]
          John Sichi made changes -
          Fix Version/s 0.6.0 [ 12314524 ]
          John Sichi made changes -
          Affects Version/s 0.7.0 [ 12315150 ]
          Affects Version/s 0.6.0 [ 12314524 ]
          John Sichi made changes -
          Fix Version/s 0.7.0 [ 12315150 ]
          Affects Version/s 0.6.0 [ 12314524 ]
          Affects Version/s 0.7.0 [ 12315150 ]
          John Sichi made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          John Sichi made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          John Sichi made changes -
          Attachment HIVE-1304.2.patch [ 12447732 ]
          John Sichi made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          John Sichi made changes -
          Status Patch Available [ 10002 ] Open [ 1 ]
          John Sichi made changes -
          Attachment HIVE-1304.3.patch [ 12447780 ]
          John Sichi made changes -
          Status Open [ 1 ] Patch Available [ 10002 ]
          Namit Jain made changes -
          Status Patch Available [ 10002 ] Resolved [ 5 ]
          Hadoop Flags [Reviewed]
          Resolution Fixed [ 1 ]
          Carl Steinbach made changes -
          Affects Version/s 0.7.0 [ 12315150 ]
          Affects Version/s 0.6.0 [ 12314524 ]
          Component/s UDF [ 12313585 ]
          Component/s Query Processor [ 12312586 ]
          Carl Steinbach made changes -
          Status Resolved [ 5 ] Closed [ 6 ]

            People

            • Assignee:
              John Sichi
              Reporter:
              John Sichi
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development