# Grouping functions for Hive SQL in Dremio

**URL:** <https://community.dremio.com/t/grouping-functions-for-hive-sql-in-dremio/7150>\
**Category:** Uncategorized\
**Created:** [March 17, 2021, 8:41am UTC](https://community.dremio.com/t/grouping-functions-for-hive-sql-in-dremio/7150 "2021-03-17T08:41:29Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sreekanth](https://avatars.discourse-cdn.com/v4/letter/s/e47774/32.png) [@Sreekanth](https://community.dremio.com/u/Sreekanth)\
**Post date:** [March 17, 2021, 8:41am UTC](https://community.dremio.com/t/grouping-functions-for-hive-sql-in-dremio/7150/1 "2021-03-17T08:41:29Z")

</div>

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