public final class LoadRmvTable extends Object
To run this class, type a command like the following:
> cd <KVEXAMPLES>
> java -classpath lib/kvclient.jar \
[:lib/oraclepki.jar:lib/osdt_cert.jar:lib/oadt_core.jar] \
:examples hadoop.hive.table.LoadRmvTable \
-store <storename> -host <hostname> -port <port> \
-nops <number-of-rows-to-generate> \
[-security <login-properties-file>] [-delete]
where the additonal JAR files (oraclepki.jar, osdt_cert.jar, and
oadt_core.jar) are required only if the password is stored in an Oracle
Wallet; which is available only in the enterprise edition of Oracle NoSQL
Database.
If the security for the store is enabled, use the oracle.kv.security property to specify a user login file. For example,
> java -Doracle.kv.security=$KVHOME/kvroot/security/user.security \
hadoop.hive.table.LoadRmvTable
You can also disable the security of the store. For kvlite, you can use the
following command to start a non-secure store.
> java -jar KVHOME/lib/kvstore.jar kvlite -secure-config disable
More details are available at:
This class demonstrates the use of Oracle NoSQL Table DDL
(Data Definition Langue) to create a table named
rmvTable
with the following format:
CREATE TABLE IF NOT EXISTS rmvTable ( \
zipcode STRING, \
lastname STRING, \
firstname STRING, \
ssn LONG, \
gender ENUM(male,female), \
license BINARY(9), \
phoneinfo MAP(STRING), \
address RECORD (number INTEGER, \
street STRING, \
unit INTEGER, \
city STRING, \
state STRING, \
zip INTEGER), \
vehicleinfo ARRAY (RECORD (type STRING, \
make STRING, \
model STRING, \
class STRING, \
color STRING, \
value FLOAT, \
tax DOUBLE, \
paid BOOLEAN)), \
PRIMARY KEY (SHARD(zipcode), lastname, firstname, ssn))
public static void main(String[] args)
Copyright (c) 2011, 2017 Oracle and/or its affiliates. All rights reserved.