SparkSQL – coalesce not working, empty array column

I have a global temp view in spark, here’s a piece of schema with problematic column:

How to aggregate in Spark SQL

I have a dataset like