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 >> > >
