You are viewing a plain text version of this content. The canonical link for it is here.

Posted to dev@hive.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2015/01/31 14:57:34 UTC

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

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)