schema_of_xml function
Applies to:
Databricks SQL
Databricks Runtime 14.1 and above
Important
This feature is in Public Preview.
Returns the schema of an XML string in DDL format.
Syntax
schema_of_xml(xmlStr [, options] )
Arguments
xmlStr: ASTRINGexpression with aXMLstring.options: An optionalMAP<STRING, STRING>literal.
Returns
A STRING holding a definition of struct where the column names are derived from the XML element and attribute names.
The field values hold the derived formatted SQL types.
For details on options, see from_xml function.
Examples
> SELECT schema_of_xml('<p><a>1</a></p>');
STRUCT<a: BIGINT>
> SELECT schema_of_xml('<p><a attr="2">1</a><a>3</a></p>', map('excludeAttribute', 'true'));
STRUCT<a: ARRAY<BIGINT>>
Related functions
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for