Hi, I'm very new to Hadoop+Hive. I've worked through the Hadoop in Action book and understand the basic principles. However, I've had a hard time finding information on loading xml data into a hive table. CSV and TSV are straightforward, but for XML it seems you either need to write some custom SerDe, convert XML to CST, or go down into Hadoop and use some streaming input reader. Is that correct? Has anyone done something with loading XML data and willing to give advice?
Thanks much in advance, Adriaan