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
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
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 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
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 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
Hive: regexp_extract to extract muti match in one line??
Hé Geeks, I have a table that each row contains data (line), and I want to extract all patterns that match in each line, the actuel comportement of the udf rexexp_extract returns me one occurence match!! but with regexp_replace the comportement is différent (replace all pattern match in line) how can I extract all pattern match in each line ?? select (line,'*.(pattern_match_group).*, index_group) as truc from my_table Thanks by advance ;) Matouk -- *Matouk IFTISSEN | Consultant BI Big Data[image: http://www.ysance.com] * 24 rue du sentier - 75002 Paris - www.ysance.com http://www.ysance.com/ Fax : +33 1 73 72 97 26 *Ysance sur* :*Twitter* http://twitter.com/ysance* | Facebook https://www.facebook.com/pages/Ysance/131036788697 | Google+ https://plus.google.com/u/0/b/115710923959357341736/115710923959357341736/posts | LinkedIn http://www.linkedin.com/company/ysance | Newsletter http://www.ysance.com/nous-contacter.html* *Nos autres sites* : *ys4you* http://.ys4you.com/* | labdecisionnel http://www.labdecisionnel.com/ | decrypt http://decrypt.ysance.com/*
unsubscribe-reg
please unsubscribe me from user@hive.apache.org