query related to xml input to hive

[#1]

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

[#2 · Accepted solution]

thanks, but this is solved by using xpath.