Importing from Amazon S3 using the Vertica Library for Amazon Web Services
I have a use case where i am trying to load the data into one of the Vertica table from a .csv file present in AWS S3 bucket.
I would like to know how can i configure the Vertica Library for Amazon Web Services Parameters ?
I did try doing it using the instructions provided on the below link , but it did not work -->
AFTER completing the steps above i ran the below command , but getting the error -->
ERROR MESSAGE - ERROR 6085: Unexpected exception calling process() User Function in UDSource
All i need to achieve is load the data to vertica table from s3 . command that i used is as below -
table name> WITH SOURCE S3(url='s3://idl-sbg-uw2-processed-analytics-prod-prd/<filename.csv>');
If anyone has done this kind of usecase , please let me know . Appreciate your help.