Grouping functions for Hive SQL in Dremio

“concat_ws” and “collect_set” functions can be used for grouping purpose in the Hive database SQL statements.Can you please provide the equivalent grouping fucntions to be used in the Dremio for Hive SQL statements.