[
https://issues.apache.org/jira/browse/HIVE-4934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14081337#comment-14081337
]
Lefty Leverenz commented on HIVE-4934:
--------------------------------------
Hm, that's a good point. The line break after SELECT adds helpful emphasis so
feel free to restore it, or I will.
A bit of text explaining the obvious would also be good, such as "In this
example, the first OVER clause applies to COUNT(b) and the second OVER clause
applies to SUM(b)." Maybe with "only" thrown in.
> 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)
