セキュアなvehicleTableへのHiveのマッピング: Oracle Wallet

パスワード記憶域としてOracle Walletが使用されている場合は、次のHiveコマンドを実行することで、vehicleTableにマップする外部Hive表を作成できます。

CREATE EXTERNAL TABLE IF NOT EXISTS vehicleTableWallet
    (type STRING, make STRING, model STRING, class STRING, color STRING, 
        price DOUBLE, count INT, dealerid DECIMAL, delivered TIMESTAMP)
    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" = "vehicleTable", 
        "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.wallet.dir" = "/tmp/example-user-wallet.dir");