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

Unable to set session params for awslib

I'm trying to export a table in parquet format to S3 using S3EXPORT() and am receiving an error I cannot resolve when trying to set the session params.

I'm following the instructions outlined in this support article:

https://www.vertica.com/docs/10.1.x/HTML/Content/Authoring/AdministratorsGuide/BulkLoadCOPY/AWSLibrary/configuringVerticaAWSLibrary.htm

I've generated my session params using SAML and when issuing the first command on Step 2 I receive an error:

ALTER SESSION SET UDPARAMETER FOR awslib aws_secret='<my_aws_secret_access_key';

An error occurred when executing the SQL command:
ALTER SESSION SET UDPARAMETER FOR awslib aws_secret='<my_aws_secret_access_key'

SQLValidation failure: mismatched input 'FOR' expecting '=' line: 1 position: 31
1 statement failed

I cannot figure outhow to edit that command to commit it successfully.

I am running Vertica Analytic Database v10.1.1-6.

I also could not determine if there is any other initial setup required to initiate awslib on the database.

Answers

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.