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
: ASTRING
expression with aXML
string.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
https://aka.ms/ContentUserFeedback.
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:Submit and view feedback for