Hi All,
I am new to Oracle XML Extensions for Hive. I am trying to setup the Oracle XML extension as documented in user guide.
I have CDH 5.7 installed on my cluster.
==================FROM USER GUIDE====================================================
1.7.2 Installing Oracle XQuery for Hadoop
Take the following steps to install Oracle XQuery for Hadoop.
To install Oracle XQuery for Hadoop:
1. Unpack the contents of oxh-version.zip into the installation directory:
unzip oxh-2.3.0-cdh-4.4.0.zip
Archive: oxh-2.3.0-cdh-4.4.0.zip
creating: oxh-2.3.0-cdh-4.4.0/
creating: oxh-2.3.0-cdh-4.4.0/lib/
inflating: oxh-2.3.0-cdh-4.4.0/lib/ant-launcher.jar
inflating: oxh-2.3.0-cdh-4.4.0/lib/ant.jar
inflating: oxh-2.3.0-cdh-4.4.0/lib/apache-xmlbeans.jar
inflating: oxh-2.3.0-cdh-4.4.0/lib/avro-mapred-1.7.4-hadoop2.jar
7.2 Using the Hive Extensions
To enable the Oracle XQuery for Hadoop extensions, use the --auxpath and -i arguments when starting Hive:
$ hive --auxpath $OXH_HOME/hive/lib -i $OXH_HOME/hive/init.sql
===================================================================================================
When I run the above command "hive --auxpath $OXH_HOME/hive/lib -i $OXH_HOME/hive/init.sql" i get the below error
$ hive --auxpath $OXH_HOME/hive/lib -i $OXH_HOME/hive/init.sql
Logging initialized using configuration in jar:file:/opt/cloudera/parcels/CDH-5.4.5-1.cdh5.4.5.p1357.1177/jars/hive-common-1.1.0-cdh5.4.5.jar!/hive-log4j.properties
FAILED: Class oracle.hadoop.xquery.hive.OXMLQueryUDF not found
FAILED: Execution Error, return code 1 from org.apache.hadoop.hive.ql.exec.FunctionTask
Note: I have added the OXH installation directory in path:
$ echo $PATH
:/home/ibietl/mxxxx/oxh-4.5.0-cdh5.0.0:/home/ibietl/mkamdar/oxh-4.5.0-cdh5.0.0/hive/lib:/home/ibietl/mxxxx/oxh-4.5.0-cdh5.0.0/hive/lib
Could you please let me know if i have missed something.
Thanks
mik