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

Allow aggregate functions in over clause

    XMLWordPrintableJSON

Details

    • New Feature
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 2.1.0
    • 2.1.0
    • Parser
    • None

    Description

      Support to reference aggregate functions within the over clause needs to be added. For instance, currently the following query will fail:

      select rank() over (order by sum(ws.c_int)) as return_rank
      from cbo_t3 ws
      group by ws.key;
      

      Attachments

        1. HIVE-13475.patch
          34 kB
          Jesus Camacho Rodriguez

        Activity

          People

            jcamachorodriguez Jesus Camacho Rodriguez
            jcamachorodriguez Jesus Camacho Rodriguez
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: