hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Zheng Shao (JIRA)" <>
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
             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:

SELECT department, max(struct(salary, employee_name))
FROM compensations;

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

View raw message