Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-10-2022 03:24 AM
The rough equivalent would be using collect_set and array_join but note you have lost the order:
Use this
SELECT col1, array_join(collect_set(col2), ',') j
FROM tmp
GROUP BY col1
