hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Alexander Pivovarov (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (HIVE-9533) remove restriction that windowed aggregate ORDER BY can only have one key
Date Sun, 01 Feb 2015 20:34:35 GMT

     [ https://issues.apache.org/jira/browse/HIVE-9533?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Alexander Pivovarov updated HIVE-9533:
--------------------------------------
    Description: 
current restriction makes the existing support very limited.
{code}
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
{code}

  was:
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


> 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
>          Components: SQL
>            Reporter: N Campbell
>
> current restriction makes the existing support very limited.
> {code}
> 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
> {code}



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

Mime
View raw message