[HIVE-4934] Improve documentation of OVER clause

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Assignee: Lars Francke
• Reporter: Lars Francke
• Created: 25/Jul/13 16:54
• Updated: 04/Aug/14 09:21
• Resolved: 30/Jul/14 08:26

Description

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...

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.