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-1128) Let max/min handle complex types like struct
Date Wed, 03 Feb 2010 19:57:29 GMT
Let max/min handle complex types like struct
--------------------------------------------

                 Key: HIVE-1128
                 URL: https://issues.apache.org/jira/browse/HIVE-1128
             Project: Hadoop Hive
          Issue Type: Improvement
    Affects Versions: 0.6.0
            Reporter: Zheng Shao


A lot of users are interested in doing "arg_min" and "arg_max". Basically, return the value
of some other columns when one column's value is the max value.

The following is an example usage when this is done:

{code}
SELECT department, max(struct(salary, employee_name))
FROM compensations;
{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