hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Lars Francke (JIRA)" <j...@apache.org>
Subject [jira] [Created] (HIVE-4934) ntile function has to be the last thing in the select list
Date Thu, 25 Jul 2013 16:55:48 GMT
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

Mime
View raw message