topic databricks spark XML Writer in Get Started Discussions

databricks spark XML Writer

RobsonNLPT — Wed, 07 Feb 2024 16:30:36 GMT

Hi.

I'm trying to generate XML as output base on my nested dataframe. Everything is ok except by I don't know how to add elements to rootTag.

I can add elements from rowtag but not in rootTag. Same problems to add attributes to root

<books version = "5.2">
<library>"LIB1"</library>
<book id="bk103">
<author>Corets, Eva</author>
<title>Maeve Ascendant</title>
</book>
<book id="bk104">
<author>Corets, Eva</author>
<title>Oberon's Legacy</title>
</book>
</books>

any help?

Re: databricks spark XML Writer

Ayushi_Suthar — Sat, 10 Feb 2024 13:02:29 GMT

Hi @RobsonNLPT ,Thanks for bringing up your concerns, always happy to help 😁

Can you please refer to the below document to read and write the XML files?

https://docs.databricks.com/en/query/formats/xml.html

Please let me know if this helps and leave a like if this helps, followups are appreciated.
Kudos
Ayushi

Re: databricks spark XML Writer

RobsonNLPT — Sat, 10 Feb 2024 14:58:10 GMT

Hi Ayushi.

I've checked all official documentation.

There's no support for rootTag elements and optional rootTag/rowTag