I am trying to parse XML and extract node value within XML using Spark-SQL ,
Consider below XML
<Account><ID1><other><ID>123</ID></other></ID1></Account>
Here I am trying to extract 123 using XPath but not getting expected Result.
I appreciated any help here.