3 The CountTableRows Example
/opt/oracle/nosql/apps/kv/examples, the hadoop.table example package would contain the following source files under the /opt/oracle/nosql/apps/kv/examples/hadoop/table/ directory:
CountTableRows.javaLoadVehicleTable.javaKVSecurityCreation.javaKVSecurityUtil.java
To run the MapReduce job launched by the CountTableRows example Java program, an Oracle NoSQL Database store (secure or non-secure) must first be deployed, and a table must be created and populated with data. Thus, before executing CountTableRows, either use the steps outlined in the Deploying a Non-Secure Store appendix to deploy a non-secure store, or use the Deploying a Secure Store appendix to deploy a store configured for security.
Once a store has been deployed, you should execute the standalone Java program LoadVehicleTable provided in the example package to create and populate a table with the name and schema expected by CountTableRows. Once the table is created and populated with example data, CountTableRows can then be executed to run a MapReduce job that counts the number of rows of data in the table.
In addition to the LoadVehicleTable program, the example package also contains the classes KVSecurityCreation and KVSecurityUtil, which are provided to support running CountTableRows against a secure store.
The standalone Java program KVSecurityCreation is provided as a convenience, and can be run to create (or delete) a password file or Oracle Wallet along with associated client side and server side login files that CountTableRows will need to interact with a secure store.
The KVSecurityUtil class provides convenient utility methods that CountTableRows uses to create and process the various security artifacts needed when accessing the store securely.
The CountTableRows Support Programs appendix explains how to compile and execute the LoadVehicleTable program to create and populate the required example table in the store that you deploy. That appendix also explains how to compile and execute the KVSecurityCreation program to create or delete any security credentials that may be needed by CountTableRows.
The following sections explain how to compile, build (JAR), and execute the CountTableRows MapReduce job on the Hadoop cluster that was deployed for this example.