[
https://issues.apache.org/jira/browse/HIVE-4934?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13720312#comment-13720312
]
Navis commented on HIVE-4934:
-----------------------------
I think you should do like this,
{noformat}
SELECT ntile(10) OVER (PARTITION BY foo), foo FROM test;
{noformat}
> ntile function has to be the last thing in the select list
> ----------------------------------------------------------
>
> Key: HIVE-4934
> URL: https://issues.apache.org/jira/browse/HIVE-4934
> Project: Hive
> Issue Type: Bug
> Reporter: 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.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
