question trying to create hive table to read xml file in Archives of Support Questions (Read Only)

trying to create hive table to read xml file

swagath249 — Fri, 07 Jul 2017 12:38:06 GMT

CREATE EXTERNAL TABLE BOOKDATA (TITLE STRING, PRICE FLOAT) ROW FORMAT SERDE 'com.ibm.spss.hive.serde2.xml.XmlSerDe' WITH SERDEPROPERTIES ( "column.xpath.TITLE"="/BOOK/TITLE/text()", "column.xpath.PRICE"="/BOOK/PRICE/text()") STORED AS INPUTFORMAT 'com.ibm.spss.hive.serde2.xml.XmlInputFormat' OUTPUTFORMAT 'org.apache.hadoop.hive.ql.io.IgnoreKeyTextOutputFormat' LOCATION '/home/airflow/swagat/sample.xml' TBLPROPERTIES ("xmlinput.start"="<BOOK","xmlinput.end"= "</BOOK>");

getting below error

FAILED: SemanticException Cannot find class 'com.ibm.spss.hive.serde2.xml.XmlInputFormat'

Re: trying to create hive table to read xml file

ssubhas — Fri, 07 Jul 2017 12:44:23 GMT

@swagat challagondla

Have you added custom jar for class "'com.ibm.spss.hive.serde2.xml.XmlInputFormat" before creating the table?

Re: trying to create hive table to read xml file

swagath249 — Fri, 07 Jul 2017 16:09:39 GMT

Hi SIndhu i added them now i am able to create thanks for the help

Re: trying to create hive table to read xml file

debananda_sahoo — Tue, 10 Apr 2018 21:25:20 GMT

From where I can get the jar for com.ibm.spss.hive.serde2.xml.XmlInputFormat ?