Can somebody help me with this, I can't construct a grouping concatenation (using GROUP_CONCAT) of rows of a db table in HQL.

table:pattern
columns:p_id,id(referenced to another table's id),seq, words

SELECT GROUP_CONCAT(words ORDER BY p_id,seq ASC SEPARATOR ' ') FROM pattern GROUP BY id,p_id;

thanks!

Specific vendor function implementation; Use a native query and a sql result set mapping if need.