Mapping a Hive External Table to vehicleTable: Secure Store

Assuming you have executed the initial steps to deploy a secure store, created and populated the table named vehicleTable 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 single Oracle NoSQL Database table by executing the Hive commands presented in both of 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 following sections present commands that take different parameters, depending on the mechanism used to store the user's password.