Page 1 of 1

Load 100000 files

Posted: Sun Apr 22, 2012 9:46 am
by nnani
I have to load 100000 files into one table of Vertica database these files are splitted on three nodes node1 , node2 , node3. What is the best way to do it?
I am trying to make a script with the help of echo and for loop. Please help me with this.

Re: Load 100000 files

Posted: Wed May 09, 2012 1:11 pm
by rajasekhart
Hi Navin,

I am new to vertica, so far we are working with a single node.
Can you please tell me

1) What are the requirements to create multiple nodes?

2) What are the steps of distributing data among those nodes?

Thanks in advance,
Raj

Re: Load 100000 files

Posted: Sun May 13, 2012 12:50 am
by becky
Couldn't the COPY command with wild cards help? See here:

viewtopic.php?f=49&t=172