Databricks Community

QueryingQuagga

Edit: value of inner key "value" was an array - I have added the square brackets to the example below.Hello all,I'm working with Spark SQL API for querying semi-structured data in Databricks. Currently I'm having a hard time understanding how I can n...

QueryingQuagga

I'm unsure if the schema that you are parsing above is the correct one though (I might be misunderstanding). If I edit your json to the following: { "extendedinformation":[ { "name": "CHANNEL", "value": "[{\"id\":\"DUMMYID...

QueryingQuagga

Thank you - I'm looking into a solution using `LATERAL`.

Databricks Community

User Stats

User Activity

Working with semi-structured data (complex - variant)

Re: Working with semi-structured data (complex - variant)

Re: Working with semi-structured data (complex - variant)