Configuring the Hive Client Environment
In order to use Apache Hive to query data in an Oracle NoSQL Database table, the Hive integration classes and other third party supporting classes provided by Oracle NoSQL Database must be made available to the Java VM of the Hive client, as well as the Java VMs of the data nodes making up the Hadoop cluster. This is accomplished by setting the value of the Hive client's HIVE_AUX_JARS_PATH environment variable to include each of the following JAR files provided with the Oracle NoSQL Database installation:
kvclient.jarkvstore-ee.jarjackson-core.jarjackson-databind.jarjackson-annotations.jar
All JAR files specified by the HIVE_AUX_JARS_PATH environment variable will ultimately be added to the classpaths of the necessary VMs. Depending on the type of system, there are different options for adding the desired JAR files to your system's HIVE_AUX_JARS_PATH.