Parsing deeply nested XML in Databricks

[SreedharVengala]

Hi Guys,

Can someone point me to libraries to parse XML files in Databricks using Python / Scala.

Any link to blog / documentations will be helpful.

Looked into https://docs.databricks.com/data/data-sources/xml.html.

Want to parse XSD's, seem this is experimental in DBR.

[Kaniz]

Hi @SreedharVengala! My name is Kaniz, and I'm the technical moderator here. Great to meet you, and thanks for your question! Let's see if your peers on the community have an answer to your question first. Or else I will follow up with my team and get back to you soon.Thanks.

[SreedharVengala]

Thanks Kaniz Fatma!

[Kaniz]

You're most welcome @Sreedhar Vengala​ .

[Anonymous]

@Sreedhar Vengala​ - I heard back from the team. As you noted, the feature is still experimental and not supported at this time.

I would like to assure you that the team is aware of this. I have no information about a time frame to make this a supported feature.

I hope that helps a bit.

[Kaniz · Accepted solution]

Hi @Sreedhar Vengala​ , Please find attached the link related to XML Data Source for Apache Spark. Let me know if it helps.

• https://github.com/databricks/spark-xml

You'll find these things in the above provided link -

• A library for parsing and querying XML data with Apache Spark, for Spark SQL and DataFrames. The structure and test tools are mostly copied from CSV Data Source for Spark.

• This package supports to process format-free XML files in a distributed way, unlike JSON datasource in Spark restricts in-line JSON format.

• Compatible with Spark 3.0 and later with Scala 2.12, and also Spark 3.2 and later with Scala 2.12 or 2.13. Scala 2.11 and Spark 2 support ended with version 0.13.0.