[
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)
