You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@hive.apache.org by "Min Zhou (JIRA)" <ji...@apache.org> on 2009/07/17 08:20:14 UTC

[jira] Created: (HIVE-650) [UDAF] implement GROUP_CONCAT(expr)

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