trying to create hive table to read xml file

[#1]

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'

[#2 · Accepted solution]

@swagat challagondla

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

[#3]

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

[#4]

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