Hi You can write your own UDF method to parse the XML.
On Thu, Mar 8, 2012 at 3:48 AM, Keaton Adams <[email protected]> wrote: > So is there documentation or something that you can point me to that gives > a good example of how to access XML files stored in HDFS through (possibly) > an external table definition in Hive? > > I am attempting to figure out how to define src to run statements such as > this: > > > SELECT xpath_string ('<a><b>bb</b><c>cc</c></a>', 'a') FROM src LIMIT 1 ; > bbcc > > > Thanks. > > > > -- *Ric Dong * Newegg Ecommerce, MIS department
