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