Hello All, One of my hive columns has text data in xml format. What are all the efficient ways to parse the xml and query based on certain node values. Biz User select/filter Query requirements are based 6 or 7 nodes in xml. Is there any built-in support or supporting libraries for this in HIVE? I have used SerDe for unstructured log parsing, but wanted to check the most efficient way without writing specific UDFS which can parse the xml.
Could some of you share your experiences and best practices? Thanks and Regards R
