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>>