Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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 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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.