[jira] Created: (HIVE-1128) Let max/min handle complex types like struct

[Zheng Shao (JIRA)]

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.