AWSLIB not available

DieterC

Hi forum,
to COPY S3 data we need to specify access key and secret key. When trying to specify them in the Vertica session I find that awslib is not available, see the error message below.
During installation I had an issue with the AWS region (we are in eu-west-1).
Can I rerun some installation scripts/commands to get awslib loaded?

dbadmin=> ALTER SESSION SET UDPARAMETER FOR awslib aws_id='AKIAIYP7J44TPC3LUFGQ';
ROLLBACK 6600: [awslib] does not exist
dbadmin=>

Thank you
Dieter

Jim_Knicely

The install script is here:

/opt/vertica/packages/AWS/ddl/install.sql

You can check if its installed with this script:

/opt/vertica/packages/AWS/ddl/isinstalled.sql

DieterC

Thank you Jim,
have run the sql from /opt/vertica/packages/AWS/ddl/install.sql and this brought the result of /opt/vertica/packages/AWS/ddl/isinstalled.sql from false to true.
Dieter