About h_itdrs

h_itdrs · ‎07-28-2016

Thank You Sunile. I have explored the same based on information available on apache.hive site. My bad, I may not have provided the detail on what I am trying to do. The XML String I am trying to parse is a nested string and second part is I am trying to create multiple records based on number of times each node repeats with proper associations to child elements.

h_itdrs · ‎07-28-2016

I Have an HBase table, which has the Row Key and CF:CQ that holds the base64 encoded xml I created a Hive table using the HBase Handler with two columns rowdy and xml_string. Now I created a view in Hive with rowkey and unbase64(xml_string). The xml_string is nested structure. Now I need to extract attributes from xml_string along with the rowkey reference. Can someone help me with that. All I am seeing are the examples of reading xml files using HiveXMLSerde [com.ibm.spss.hive.serde2.xml.XmlSerDe] none for parsing an existing XML string inside a hive table / view.

Online	Offline
Last Visited	‎07-28-2016 05:51 PM

Member Since	‎07-28-2016 03:23 AM
Last Visited	‎07-28-2016 05:51 PM
Posts	2

Cloudera Community

Re: How do I do XML String Parsing in Hive?

How do I do XML String Parsing in Hive?