You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@flink.apache.org by "Moritz Manner (Jira)" <ji...@apache.org> on 2026/09/25 13:47:00 UTC

[jira] [Updated] (FLINK-40806) Add PARSE_XML() and TRY_PARSE_XML() functions

     [ https://issues.apache.org/jira/browse/FLINK-40806?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Moritz Manner updated FLINK-40806:
----------------------------------
    Description: 
Adds the PARSE_XML and TRY_PARSE_XML functions as described in [FLIP-612.|https://cwiki.apache.org/confluence/spaces/FLINK/pages/451974259/FLIP-612+Native+XML+Functions+for+Flink+SQL]


They parse an XML string into a VARIANT, and force_array keeps the structure the same across documents. PARSE_XML fails for invalid XML, TRY_PARSE_XML returns NULL instead. See the FLIP for the mapping.

This also adds Table API and PyFlink support.
{code:java}
PARSE_XML(xml_string [, force_array])     → VARIANT
TRY_PARSE_XML(xml_string [, force_array]) → VARIANT
{code}

  was:
Adds the PARSE_XML and TRY_PARSE_XML functions as described in [FLIP-612.|https://cwiki.apache.org/confluence/spaces/FLINK/pages/451974259/FLIP-612+Native+XML+Functions+for+Flink+SQL]
They parse an XML string into a VARIANT, and force_array keeps the structure the same across documents. PARSE_XML fails for invalid XML, TRY_PARSE_XML returns NULL instead. See the FLIP for the mapping.
This also adds Table API and PyFlink support.
{code:java}
PARSE_XML(xml_string [, force_array])     → VARIANT
TRY_PARSE_XML(xml_string [, force_array]) → VARIANT
{code}


> Add PARSE_XML() and TRY_PARSE_XML() functions
> ---------------------------------------------
>
>                 Key: FLINK-40806
>                 URL: https://issues.apache.org/jira/browse/FLINK-40806
>             Project: Flink
>          Issue Type: Sub-task
>            Reporter: Moritz Manner
>            Priority: Major
>
> Adds the PARSE_XML and TRY_PARSE_XML functions as described in [FLIP-612.|https://cwiki.apache.org/confluence/spaces/FLINK/pages/451974259/FLIP-612+Native+XML+Functions+for+Flink+SQL]
> They parse an XML string into a VARIANT, and force_array keeps the structure the same across documents. PARSE_XML fails for invalid XML, TRY_PARSE_XML returns NULL instead. See the FLIP for the mapping.
> This also adds Table API and PyFlink support.
> {code:java}
> PARSE_XML(xml_string [, force_array])     → VARIANT
> TRY_PARSE_XML(xml_string [, force_array]) → VARIANT
> {code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)