Re: XPATH_INT behavior - XML - Function in Spark

2020-05-13 Thread Chetan Khatri
Anyone can please suggest how can I achieve this? On Tue, May 12, 2020 at 5:35 PM Jeff Evans wrote: > It sounds like you're expecting the XPath expression to evaluate embedded > Spark SQL expressions? From the documentation > , there

Re: XPATH_INT behavior - XML - Function in Spark

2020-05-12 Thread Chetan Khatri
Thank you for the clarification. What do you suggest to get this use case achieved. On Tue, May 12, 2020 at 5:35 PM Jeff Evans wrote: > It sounds like you're expecting the XPath expression to evaluate embedded > Spark SQL expressions? From the documentation >

Re: XPATH_INT behavior - XML - Function in Spark

2020-05-12 Thread Jeff Evans
It sounds like you're expecting the XPath expression to evaluate embedded Spark SQL expressions? From the documentation , there appears to be no reason to expect that to work. On Tue, May 12, 2020 at 2:09 PM Chetan Khatri wrote: > Ca

Re: XPATH_INT behavior - XML - Function in Spark

2020-05-12 Thread Chetan Khatri
Can someone please help.. Thanks in advance. On Mon, May 11, 2020 at 5:29 PM Chetan Khatri wrote: > Hi Spark Users, > > I want to parse xml coming in the query columns and get the value, I am > using *xpath_int* which works as per my requirement but When I am > embedding in the Spark SQL query c