hadoop-hive-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Min Zhou (JIRA)" <j...@apache.org>
Subject [jira] Created: (HIVE-650) [UDAF] implement GROUP_CONCAT(expr)
Date Fri, 17 Jul 2009 06:20:14 GMT
[UDAF]  implement  GROUP_CONCAT(expr)
-------------------------------------

                 Key: HIVE-650
                 URL: https://issues.apache.org/jira/browse/HIVE-650
             Project: Hadoop Hive
          Issue Type: New Feature
            Reporter: Min Zhou


It's a very useful udaf for us. 
http://dev.mysql.com/doc/refman/5.0/en/group-by-functions.html#function_group-concat

GROUP_CONCAT(expr)

This function returns a string result with the concatenated non-NULL values from a group.
It returns NULL if there are no non-NULL values. The full syntax is as follows: 

GROUP_CONCAT([DISTINCT] expr [,expr ...]
             [ORDER BY {unsigned_integer | col_name | expr}
                 [ASC | DESC] [,col_name ...]]
             [SEPARATOR str_val])


-- 
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