Blog Post

Azure Synapse Analytics Blog
4 MIN READ

Implementing Spark posexplode() equivalent in the serverless SQL pool

JovanPop's avatar
JovanPop
Icon for Microsoft rankMicrosoft
Mar 04, 2022
Spark enables us to work with nested data in Parquet files. If you have a Parquet file with a complex type column (array, struct, map), Spark enables you to “unpack” the values from this column and j...
Updated Mar 04, 2022
Version 1.0
Synapse SQL
Sanjay_Rathod's avatar
Sanjay_Rathod
Copper Contributor
Mar 08, 2022

Hello JovanPop 

 

What a timing, was looking for posexplode() equivalent and finally you made it for us 🙂

 

Thank you for sharing this, have been trying nasty ways to get this  feature in synapse pipeline.

 

I tried and it works perfectly as expected in synapse serverless pool sql query

 

Kind Rgds,

Sanjay