Databricks Community

Tom_Jones

testing

Tom_Jones · 12-23-2022

Hi, I am new to DB SQL. I have a table where the array column (cities) contains multiple arrays and some have multiple duplicate values. I need to unpack the array values into rows so I can list the distinct values. The following query works for this...

Tom_Jones · 12-23-2022

Thanks Hubert. What i tried so far is not collecting the distinct values of the expolded column grouped by key.An example input is:key, cities1, ["milan","paris","new york"]1, ["London"]1, ["London","paris"]1, ["London","paris"]1, ["London","paris"]1...

Databricks Community

User Stats

User Activity

test 123

How to explode an array column and repack the distinct values into one array in DB SQL?

Re: How to explode an array column and repack the distinct values into one array in DB SQL?