Mapping a Hive External Table to rmvTable: Secure Store

Assuming you have executed the initial steps to deploy a secure store, created and populated the table named rmvTable in that store, and configured the Hive client environment for secure interaction with Oracle NoSQL Database, you can then create two external Hive tables that each map to that Oracle NoSQL Database table by executing the Hive commands presented in the following sections.

When mapping a Hive external table to a table located in a secure Oracle NoSQL Database, because the password the Hive client uses to access and communicate with the store can be stored in either a password file or an Oracle Wallet, the sections below present commands that take different parameters, depending on the mechanism used to store the user's password.