You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Alexander Pivovarov (JIRA)" <ji...@apache.org> on 2015/02/01 21:34:35 UTC
[jira] [Updated] (HIVE-9533) remove restriction that windowed
aggregate ORDER BY can only have one key
[ 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)