Sequence with multiple COPY statement

Moderator: NorbertKrupa

Post Reply
User avatar
nnani
Master
Master
Posts: 302
Joined: Fri Apr 13, 2012 6:28 am
Contact:

Sequence with multiple COPY statement

Post by nnani » Wed Jun 05, 2013 9:58 am

Hello all,

I was just curious about how Vertica reacts to this scenario:

We have 3 node cluster, a master sequence defined and a table to be loaded which is segmented by the unique(sequnce) column.

Lets say we have three flat files staged one on each node.
When we run the 3 COPY command at the same instance, one through each node for the same table. How will be the sequence column be distributed? :roll:
nnani........
Long way to go

You can check out my blogs at vertica-howto

Post Reply

Return to “Vertica Database Development”