Mapping a Hive External Table to exampleJsonTable: Secure Store

Assuming you have executed the initial steps to deploy a secure store, followed the directions presented in the Creating and Populating the exampleJsonTable appendix to create and populate the NoSQL table named exampleJsonTable, 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.