hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jesus Camacho Rodriguez (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-13475) Allow aggregate functions in over clause
Date Mon, 11 Apr 2016 15:48:25 GMT
Jesus Camacho Rodriguez created HIVE-13475:
----------------------------------------------

             Summary: Allow aggregate functions in over clause
                 Key: HIVE-13475
                 URL: https://issues.apache.org/jira/browse/HIVE-13475
             Project: Hive
          Issue Type: New Feature
          Components: Parser
    Affects Versions: 2.1.0
            Reporter: Jesus Camacho Rodriguez
            Assignee: Jesus Camacho Rodriguez


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

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




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Mime
View raw message