Re: Storing and reading XML files in HIVE
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 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
Re: Storing and reading XML files in HIVE
U need to have a CustomSerde in Hive to read the XML files On Fri, Jun 6, 2014 at 2:58 PM, Yu Azuryy 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 >> > >
Re: Storing and reading XML files in HIVE
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 >
Storing and reading XML files in HIVE
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