Mapping Hive to Secure exampleJsonTable: Password File
If a password file is used for password storage, then you can create an external Hive table that maps to the exampleJsonTable
by executing the following Hive command:
CREATE EXTERNAL TABLE IF NOT EXISTS exampleTablePasswd
(id INTEGER, jsonfield STRING)
COMMENT 'Hive mapped to NoSQL table: exampleJsonTable'
STORED BY 'oracle.kv.hadoop.hive.table.TableStorageHandler'
TBLPROPERTIES (
"oracle.kv.kvstore" = "example-store",
"oracle.kv.hosts"="kv-host-1:5000,kv-host-2:5000,kv-host-3:5000",
"oracle.kv.tableName" = "exampleJsonTable",
"oracle.kv.hadoop.hosts" = "dn-host-1,dn-host-2,dn-host-3",
"oracle.kv.security" = "/tmp/hive-nosql.login",
"oracle.kv.ssl.truststore" = "/tmp/client.trust",
"oracle.kv.auth.username" = "example-user",
"oracle.kv.auth.pwdfile.file" = "/tmp/example-user.passwd");