[jira] [Created] (HIVE-9533) remove restriction that windowed aggregate ORDER BY can only have one key

[N Campbell (JIRA)]

N Campbell created HIVE-9533:
--------------------------------

             Summary: remove restriction that windowed aggregate ORDER BY can 
only have one key
                 Key: HIVE-9533
                 URL: https://issues.apache.org/jira/browse/HIVE-9533
             Project: Hive
          Issue Type: Improvement
            Reporter: N Campbell


current restriction makes the existing support very limited.

select rnum, c1, c2, c3, sum( c3 ) over(partition by c1 order by c2 , c3) from 
tolap

Error: Error while compiling statement: FAILED: SemanticException Range based 
Window Frame can have only 1 Sort Key
SQLState:  42000
ErrorCode: 40000



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