Page 1 of 1

Loading data from S3 bucket into Vertica DB

Posted: Tue May 05, 2015 9:46 pm
by Vertica_grm
Hi I'm a new Vertica user. I have an Amazon S3 bucket setup and some data is present. I want to load that data in Vertica. what are the steps/commands to do that?

I'm not able to figure out how to connect the two.

Any help would be greatly appreciated.

Re: Loading data from S3 bucket into Vertica DB

Posted: Tue May 05, 2015 11:11 pm
by NorbertKrupa
Is Vertica also in AWS? We need more information on the topology of your environment.

Re: Loading data from S3 bucket into Vertica DB

Posted: Wed May 06, 2015 9:38 pm
by Vertica_grm
No Vertica is not on AWS. it's separate.

The command we got in tht demo was

s3fs data.folder /vertica/s3 -o allow_other -o default_acl=public-read -o
use_cache=/vertica/s3cache/

I'm not able to interpret this command. Where to run this and which parameters to change!