Solved: Json with Select Distinct - Page 2

samreedhi · 06-12-2024 11:52 PM

Is it possible to utilize 'Select Distinct' with a table containing a JSON column, especially when dealing with large datasets?

samreedhi

Hey is it possible if we can use group by instead of distinct ?

View solution in original post

ms4446

Yes, you can use GROUP BY instead of SELECT DISTINCT when working with JSON columns in Google Cloud BigQuery. This approach can often provide more flexibility and performance benefits, especially when dealing with large datasets.

View solution in original post