INSTALL_COMMUNITY_KEY

Stores the Connector Framework Service security key in the Vertica Distributed File System (DFS).

Syntax

V_IDOL.INSTALL_COMMUNITY_KEY(USING PARAMETERS file_path='keyfile‑path'); 

Parameters

file_path

Specifies the location of key file from which the key is copied to DFS.

Privileges

You must be a dbadmin user.

Example

Store the CFS security key that is in btea.key:

=> SELECT v_idol.install_community_key(
USING PARAMETERS file_path='/home/release/IDOL/test-data/btea.key');