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.
Loading data from S3 bucket into Vertica DB
Moderator: NorbertKrupa
-
- Newbie
- Posts: 17
- Joined: Tue Apr 21, 2015 8:35 pm
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Loading data from S3 bucket into Vertica DB
Is Vertica also in AWS? We need more information on the topology of your environment.
Checkout vertica.tips for more Vertica resources.
-
- Newbie
- Posts: 17
- Joined: Tue Apr 21, 2015 8:35 pm
Re: Loading data from S3 bucket into Vertica DB
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!
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!