You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Lars Francke (JIRA)" <ji...@apache.org> on 2014/07/30 10:28:39 UTC
[jira] [Updated] (HIVE-4934) Improve documentation of OVER clause
[ https://issues.apache.org/jira/browse/HIVE-4934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Lars Francke updated HIVE-4934:
-------------------------------
Description:
{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.
was:
{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.
> 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)