12 Executing SQL Queries Against Oracle NoSQL Database

The examples presented in this document were run using Oracle Big Data SQL 4.x and Oracle NoSQL Database 20.x, both installed on an Oracle Big Data Appliance (BDA). The system's Hive client environment was configured according to the directions presented in the Configuring the Hive Client Environment appendix.

Prior to attempting the examples presented here, first make sure you have satisfied all prerequisites described at the beginning of this document; which includes deploying an Oracle NoSQL Database store, either secure or non-secure.

Once the necessary prerequisites have been satisfied, follow the directions presented in the CountTableRows Support Programs appendix to create and populate the table named vehicleTable in the Oracle NoSQL Database. Then follow the directions presented in the Creating and Populating the rmvTable appendix and the Creating and Populating the exampleJsonTable appendix to create and populate the tables named rmvTable and exampleJsonTable respectively.

Finally, after satisfying all prerequisites and creating and populating each example table in the Oracle NoSQL Database store, follow the directions presented in the Configuring Oracle Big Data SQL For Querying Oracle NoSQL Database appendix to configure the Oracle Big Data SQL system for executing SQL queries against data stored in the Oracle NoSQL Database you deployed.