Copying from Vertica to Vertica (Cluster size?)

Moderator: NorbertKrupa

Post Reply
User avatar
janice
Intermediate
Intermediate
Posts: 51
Joined: Wed May 30, 2012 1:14 pm

Copying from Vertica to Vertica (Cluster size?)

Post by janice » Thu Feb 05, 2015 2:55 pm

Howdy,

I want to set up a pre-production cluster and a production cluster so that I can load data into the pre-production cluster and then once it has been verified, move it to the production cluster using the COPY FROM VERTICA command.

My question is do both the pre-production cluster and production cluster have to have the same number of nodes? Can my pre-production cluster be smaller?

Thanks in advance!
Everyday is an adventure!

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

Re: Copying from Vertica to Vertica (Cluster size?)

Post by NorbertKrupa » Thu Feb 05, 2015 5:51 pm

If you're using the COPY FROM VERTICA command, the clusters do not need to have the same number of nodes as you're using a COPY statement.

Take a look at my blog post about the available copy methods.
Checkout vertica.tips for more Vertica resources.

User avatar
janice
Intermediate
Intermediate
Posts: 51
Joined: Wed May 30, 2012 1:14 pm

Re: Copying from Vertica to Vertica (Cluster size?)

Post by janice » Thu Feb 05, 2015 10:47 pm

Thank you norbertk. Nice blog post too :)
Everyday is an adventure!

Post Reply

Return to “New to Vertica Database Administration”