AWSLIB not available

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

Comments

  • Jim_KnicelyJim_Knicely - Select Field - Administrator
    edited December 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

  • 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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file