hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Francke (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (HIVE-4934) Improve documentation of OVER clause
Date Thu, 31 Jul 2014 07:58:38 GMT

    [ https://issues.apache.org/jira/browse/HIVE-4934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14080623#comment-14080623
] 

Lars Francke commented on HIVE-4934:
------------------------------------

Yeah, I thought it was easier to see that each OVER has only one associated function call
but I'm not overly attached to the line breaks so if you feel it looks better on one line
feel free to change it.

> Improve documentation of OVER clause
> ------------------------------------
>
>                 Key: HIVE-4934
>                 URL: https://issues.apache.org/jira/browse/HIVE-4934
>             Project: Hive
>          Issue Type: Bug
>            Reporter: Lars Francke
>            Assignee: Lars Francke
>            Priority: Minor
>
> {code}
> CREATE TABLE test (foo INT);
> SELECT ntile(10), foo OVER (PARTITION BY foo) FROM test;
> FAILED: SemanticException org.apache.hadoop.hive.ql.metadata.HiveException: Only COMPLETE
mode supported for NTile function
> SELECT foo, ntile(10) OVER (PARTITION BY foo) FROM test;
> ...works...
> {code}
> I'm not sure if that is a bug or necessary. Either way the error message is not helpful
as it's not documented anywhere what {{COMPLETE}} mode is. A cursory glance at the code didn't
help me either.
> Edit: It is not a bug, it wasn't clear to me that the OVER clause only applies to the
directly preceding function.



--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message