79209444

Date: 2024-11-21 02:05:44
Score: 1.5
Natty:
Report link

I needed something similar recently - this is how I hacked it.

If you're okay with converting your STRUCT to JSON string than this method will work for you.

SELECT ARRAY_AGG(DISTINCT TO_JSON_STRING(STRUCT(field_a, field_b))) as c FROM table
Reasons:
  • Blacklisted phrase (0.5): I need
  • Low length (0.5):
  • Has code block (-0.5):
  • Low reputation (1):
Posted by: Parth Shah