[jira] [Assigned] (HIVE-4934) ntile function has to be the last thing in the select list

["Lars Francke (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/HIVE-4934?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Lars Francke reassigned HIVE-4934:
----------------------------------

    Assignee: Lars Francke

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



--
This message was sent by Atlassian JIRA
(v6.2#6252)