question Re: extract xml fields in Support Questions

extract xml fields

roshanbi — Thu, 01 Jul 2021 11:30:53 GMT

Hello Team,

how can we extract XML values from the column below (type string) from Impala (Kudu)

Regards,

Roshan

Re: extract xml fields

ChethanYM — Mon, 05 Jul 2021 07:16:43 GMT

Hello,

Have you tried with a query like this -> select <column-name> from <table-name>;

If this is not your expectation let us know in detail regarding the requirement.

Regards,

Chethan YM

Re: extract xml fields

VidyaSargur — Tue, 06 Jul 2021 09:17:22 GMT

Hi @roshanbi, has the reply helped resolve your issue? If so, please mark the appropriate reply as the solution, as it will make it easier for others to find the answer in the future.

Re: extract xml fields

roshanbi — Sat, 07 Aug 2021 15:54:01 GMT

Hi,

no it won't work.

Re: extract xml fields

robbiez — Tue, 10 Aug 2021 10:21:22 GMT

You need a UDF to parse the XML string and extract the values. As far as I know, Impala doesn't have a native function to do it.