Databricks Community

BNV

Trying to translate this line of a SQL query that evaluates XML to Databricks SQL.SELECT MyColumn.value('(/XMLData/Values/ValueDefinition[@colID="10"]/@Value)[1]', 'VARCHAR(max)') as Color The XML looks like this:<XMLData><Values><ValueDefinition c...

BNV

Hi. Thank you for replying. My XML sample is in the original post above if it helps.I doesn't seem like the "_string" version because it's saying:AnalysisException: Can't extract value from xpath_string(ExData#251799, /XMLData/Values/ValueDefinition[...

BNV

This might be a good start but I do get an error ("Invalid XPath") when trying to access the column as the xpath. Is it not possible to use a column as the xpath?SELECT xpath(MyColumn.value, '/XMLData/Values/ValueDefinition[@colID="10"]/@Value)[1]') ...

BNV

Thank you but I'm not very familiar with Pandas. This might be out of my realm of knowledge.Are you saying Pandas would have this functionality including using SQL and that SQL function or that I would need to create a UDF to parse XML (which sounds ...

Databricks Community

User Stats

User Activity

Translating SQL Value Function For XML To Databricks SQL

Re: Translating SQL Value Function For XML To Databricks SQL

Re: Translating SQL Value Function For XML To Databricks SQL

Re: Translating SQL Value Function For XML To Databricks SQL