Uploaded image for project: 'Hive'
  1. Hive
  2. HIVE-13936

Add streaming support for row_number

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 2.2.0
    • Query Processor
    • None

    Description

      Without this support row_number will cause heap issues in reducers. Example query below against 10 million records will cause failure. 

      select a, row_number() over (partition by a order by a desc) as row_num from j100mil;

      Same issue different function in JIRA HIVE-7062

      Attachments

        1. HIVE-13936.1.patch
          5 kB
          Yongzhi Chen

        Issue Links

          relates to

          Bug - A problem which impairs or prevents the functions of the product. HIVE-7062 Support Streaming mode in Windowing

          • Major - Major loss of function.
          • Closed

          Activity

            People

              ychena Yongzhi Chen
              johndee Johndee Burks
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: