hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-894) add udaf max_n, min_n to contrib
Date Tue, 20 Oct 2009 23:10:00 GMT
add udaf max_n, min_n to contrib
--------------------------------

                 Key: HIVE-894
                 URL: https://issues.apache.org/jira/browse/HIVE-894
             Project: Hadoop Hive
          Issue Type: New Feature
            Reporter: Zheng Shao


These 2 UDAFs should return the max n numbers, min n numbers in order.

{code}
SELECT max_n(userid, 3) FROM src;
[999,997,996]
SELECT max_n(userid, 3)[1] FROM src;
997
SELECT min_n(userid, 3) FROM src;
[0, 3, 8]
SELECT min_n(userid, 3)[2] FROM src;
8
{code}



-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message