Bulk Loading of Data From tool

Moderator: NorbertKrupa

Post Reply
rajaduraibanu
Newbie
Newbie
Posts: 19
Joined: Thu Aug 08, 2013 8:01 am

Bulk Loading of Data From tool

Post by rajaduraibanu » Thu Sep 26, 2013 12:22 pm

Hi ,


I have vertica database installed in 3 nodes ,and when loading the data through tool, which node ip to give or how does vertica work on inserting or selecting data if there is 3 nodes or more

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Bulk Loading of Data From tool

Post by id10t » Thu Sep 26, 2013 12:51 pm

Hi!

Vertica shared nothing, no master host.
When you are connected to cluster you are connected to some particular node - this node calls "Executor Node".
"Executor node" distributes each query/task over all nodes and each node do it "self sub-job". When all is done, "Executor Node" collects results from all nodes and returns to user. Very similar to MapReduce strategy.

rajaduraibanu
Newbie
Newbie
Posts: 19
Joined: Thu Aug 08, 2013 8:01 am

Re: Bulk Loading of Data From tool

Post by rajaduraibanu » Thu Sep 26, 2013 12:56 pm

hi

if i want to install vertica instances in 3 nodes individually , what system functions to be executed or configuration is required to be done to make cluster configuration.
Or what initial settings to be done ??

id10t
GURU
GURU
Posts: 732
Joined: Mon Apr 16, 2012 2:44 pm

Re: Bulk Loading of Data From tool

Post by id10t » Thu Sep 26, 2013 1:23 pm

Hi!

IMHO: you need consultant or specialist. I can advise some member from forum: Sharon Cutter, Independent Consultant for Vertica and Hadoop
memberlist.php?mode=viewprofile&u=191
http://www.linkedin.com/pub/sharon-cutter/4/877/666

PS
No one will do your work for you: if it require to read documentation so do it!

Post Reply

Return to “Talend”