AWSLIB not available

DieterCDieterC Employee
in Archived Posts

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

  • DieterCDieterC Employee

    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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • Archived PostsComment As ...