I have a situation here, my xml is having multiple nodes with same tag hence I have used xpath(tags/tag/innertag/) and it is returning array of a string now I have to use the multiple explode function - which is creating problem as I'm getting Cartesian product values 😞 I should get A a1 B b1 but I'm getting A a1 A b1 B a1 B b1 This is the reason my hive table data increased unnecessary and also I'm not getting correct results. Any UDF of other approach which may help me please advice. ... View more