see if this can help you https://github.com/dvasilen/Hive-XML-SerDe/wiki/XML-data-sources
On Fri, Jun 6, 2014 at 3:25 PM, Knowledge gatherer < knowledge.gatherer....@gmail.com> wrote: > U need to have a CustomSerde in Hive to read the XML files > > > On Fri, Jun 6, 2014 at 2:58 PM, Yu Azuryy <azuryy....@gmail.com> wrote: > >> AFAIK, Hive doesn't provide XMLInputFormat , so you had to write it by >> yourself. >> >> >> On Fri, Jun 6, 2014 at 5:23 PM, Ramasubramanian Narayanan < >> ramasubramanian.naraya...@gmail.com> wrote: >> >>> Dear All, >>> >>> Request your help to guide how to store and read XML data in HIVE. >>> >>> while querying it should look as if we are having txt format file under >>> HIVE (it is fine if we use view to parse the XML and show). >>> >>> Have gone through some sites but not able to figure out correctly.. few >>> are mentioning that we need use some JAR's to achieve it... >>> >>> >>> Thanks in advance, >>> Rams >>> >> >> > -- Nitin Pawar
