Configuring Oracle Big Data SQL For Querying Data in a Secure Store

The Hive and Oracle NoSQL Database Security appendix describes the additional security artifacts that must be generated and installed to support executing queries (both Hive and Big Data SQL) against table data stored in a secure Oracle NoSQL Database. Those artifacts include the login, trust, and password artifacts, as well as the server side JAR file that contains the necessary public credentials for communication with the secure store. After generating and installing the necessary security artifacts in the manner described in that section, add the server side JAR file to the Big Data SQL system's java.classpath.oracle system property.

For example, if the server side JAR file is named hive-nosql-server.jar and is installed in a directory such as /tmp/kv-client-security, then do the following:

cd /opt/oracle/product/18c/dbhome_1/bigdatasql/jlib
ln –s /tmp/kv-client-security/hive-nosql-server.jar \ 
    hive-nosql-server.jar

Additionally, if you will also be executing Hive queries from any of the Big Data SQL system's database nodes, then you must create the same link as that shown in the following directories on each such node,

    /opt/oracle/bigdatasql/bdcell-12.1/jlib-bds
and
    /opt/oracle/bigdatasql/bdcell-12.2/jlib-bds