Lars Francke created HIVE-4934:
----------------------------------
Summary: 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
