Non-Primitive Data Types - The rmvTable Example

This example demonstrates how to execute various Hive queries on an Oracle NoSQL Database table defined with a complex schema. In this example, a schema is employed that consists of a variety of Oracle NoSQL Database data types; both primitive and non-primitive.

The Hive queries executed in this example will be applied to the table named rmvTable you initially created and populated in the Oracle NoSQL Database store. For more information on that table's schema and data types, see the Creating and Populating the rmvTable appendix.

Prior to executing Hive queries against rmvTable, you must first create an external table in Hive and map it to the table in Oracle NoSQL Database, as shown in the following sections.