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!
Copying from Vertica to Vertica (Cluster size?)
Moderator: NorbertKrupa
Copying from Vertica to Vertica (Cluster size?)
Everyday is an adventure!
-
- GURU
- Posts: 527
- Joined: Tue Oct 22, 2013 9:36 pm
- Location: Chicago, IL
- Contact:
Re: Copying from Vertica to Vertica (Cluster size?)
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.
Take a look at my blog post about the available copy methods.
Checkout vertica.tips for more Vertica resources.
Re: Copying from Vertica to Vertica (Cluster size?)
Thank you norbertk. Nice blog post too
Everyday is an adventure!