Skip to main content

AWSLIB not available

  • December 5, 2017
  • 2 replies
  • 6 views

DieterC
Forum|alt.badge.img+2

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

2 replies

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • December 5, 2017

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
Forum|alt.badge.img+2
  • Author
  • Participating Frequently
  • December 5, 2017

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