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.
|
Load 100000 files
3 posts
• Page 1 of 1
Load 100000 filesI 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. nnani........
Long way to go
Re: Load 100000 filesHi 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 filesCouldn't the COPY command with wild cards help? See here:
http://vertica-forums.com/viewtopic.php?f=49&t=172 THANKS - BECKSTER
3 posts
• Page 1 of 1
Who is onlineUsers browsing this forum: No registered users and 0 guests |