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
0
Leave a Comment
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.
Comments
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