hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Francke (JIRA)" <>
Subject [jira] [Commented] (HIVE-4934) Improve documentation of OVER clause
Date Mon, 04 Aug 2014 09:22:11 GMT


Lars Francke commented on HIVE-4934:

I just wanted to add the clarification and saw that you've been - once more - faster than
me. Thanks for helping out!

> Improve documentation of OVER clause
> ------------------------------------
>                 Key: HIVE-4934
>                 URL:
>             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;
> {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

View raw message