Loading data from S3 bucket into Vertica DB

Moderator: NorbertKrupa

Post Reply
Vertica_grm
Newbie
Newbie
Posts: 17
Joined: Tue Apr 21, 2015 8:35 pm

Loading data from S3 bucket into Vertica DB

Post by Vertica_grm » Tue May 05, 2015 9:46 pm

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.

NorbertKrupa
GURU
GURU
Posts: 527
Joined: Tue Oct 22, 2013 9:36 pm
Location: Chicago, IL
Contact:

Re: Loading data from S3 bucket into Vertica DB

Post by NorbertKrupa » Tue May 05, 2015 11:11 pm

Is Vertica also in AWS? We need more information on the topology of your environment.
Checkout vertica.tips for more Vertica resources.

Vertica_grm
Newbie
Newbie
Posts: 17
Joined: Tue Apr 21, 2015 8:35 pm

Re: Loading data from S3 bucket into Vertica DB

Post by Vertica_grm » Wed May 06, 2015 9:38 pm

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!

Post Reply

Return to “Vertica Data Load”