Creating and Populating the exampleJsonTable

Similar to the programs that create and populate the example vehicleTable and rmvTable, the Oracle NoSQL Database example distribution provides another program, named LoadJsonExample, that you can use to create and populate a table consisting of rows with a field containing a JSON document. You can use the table created by the LoadJsonExample program to explore employing Hive to query JSON documents stored in an Oracle NoSQL Database.

This section describes the LoadJsonExample program, along with the schema employed when creating the desired example table, as well as how to compile and execute that program.