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

Add streaming support for row_number

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 2.2.0
    • Component/s: Query Processor
    • Labels:
      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: