query related to xml input to hive

rishit606 — Tue, 10 Jan 2017 18:54:26 GMT

hi,

i am trying to import xml data in hive.

below is an example:

<ns2:reqValAdd xmlns:ns2="http://www.ss.ss"></ns2:reqValAdd>

CREATE TABLE xml_test4(ns2 STRING) ROW FORMAT SERDE 'com.ibm.spss.hive.serde2.xml.XmlSerDe' WITH SERDEPROPERTIES ( "column.xpath.ns2"="/ns2:ReqValAdd/@ns2" ) STORED AS INPUTFORMAT 'com.ibm.spss.hive.serde2.xml.XmlInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' TBLPROPERTIES ( "xmlinput.start"="<ns2:reqValAdd xmlns:ns2", "xmlinput.end"="</ns2:reqValAdd>" );

the output is coming as NULL while i am expecting "http://www.ss.ss".

can you please suggest what is wrong and how to rectify?

thanks,

Rishit Shah

Re: query related to xml input to hive

rishit606 — Thu, 19 Jan 2017 14:37:42 GMT

thanks, but this is solved by using xpath.

question query related to xml input to hive in Archives of Support Questions (Read Only)

query related to xml input to hive

Re: query related to xml input to hive