Mapping Hive to Secure rmvTable: Password File

If a password file is used for password storage, then you can create an external Hive table that maps to the rmvTable by executing the following Hive command:

CREATE EXTERNAL TABLE IF NOT EXISTS rmvTablePasswd
    (zipcode STRING, lastname STRING, firstname STRING, ssn BIGINT, 
        gender STRING, license BINARY, phoneinfo MAP<STRING, STRING>,
        address STRUCT<number:INT street:STRING, 
            unit:INT, city:STRING, zip:INT>,
        vehicleinfo ARRAY<STRUCT<type:STRING, make:STRING,
            model:STRING, class:STRING, color:STRING, 
            value:FLOAT, tax:DOUBLE, paid:BOOLEAN>>)
    COMMENT 'Hive mapped to NoSQL table: rmvTable'
    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" = "rmvTable", 
            "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");