Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-10555 Improve windowing spec of range based windowing to support additional range formats
  3. HIVE-10650

Improve sum() function over windowing to support additional range formats

Log workAgile BoardRank to TopRank to BottomBulk Copy AttachmentsBulk Move AttachmentsVotersWatch issueWatchersConvert to IssueMoveLinkCloneLabelsUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Sub-task
    • Status: Resolved
    • Major
    • Resolution: Pending Closed
    • None
    • 1.3.0
    • PTF-Windowing

    Description

      Support the following windowing function x preceding and y preceding and x following and y following.
      e.g.

       
      select sum(value) over (partition by key order by value rows between 2 preceding and 1 preceding) from tbl1;
      select sum(value) over (partition by key order by value rows between unbounded preceding and 1 preceding) from tbl1;
      

      Attachments

        1. HIVE-10650.patch
          44 kB
          Aihua Xu

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            aihuaxu Aihua Xu Assign to me
            aihuaxu Aihua Xu
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment