This error means you need the XQuery for Hadoop jars in your classpath. You can download them here: https://www.oracle.com/technetwork/database/database-technologies/bdc/big-data-connectors/downloads/index.html "Oracle XQuery for Hadoop 4.9.1" Then sections 7.2 and 7.3 show how you can add the jars to your classpath: https://docs.oracle.com/bigdata/bda412/BDCUG/oxh_hive.htm#BDCUG691 CREATE TABLE F_CATEGORY_XML (recid STRING, xmlrecord STRING) ROW FORMAT    SERDE 'oracle.hadoop.xquery.hive.OXMLSerDe' STORED AS    INPUTFORMAT 'oracle.hadoop.xquery.hive.OXMLInputFormat'    OUTPUTFORMAT 'oracle.hadoop.xquery.hive.OXMLOutputFormat' TBLPROPERTIES(    "oxh-elements" = "row",     "oxh-column.recid" = "./c1",    "oxh-column.xmlrecord" = "./c2" ) ... View more