Search found 9 matches

by vigneshn
Wed Sep 09, 2015 8:46 pm
Forum: Vertica Installation
Topic: Install 3 Node Vertica Cluster in VMWARE
Replies: 3
Views: 7141

Re: Install 3 Node Vertica Cluster in VMWARE

Hi Kincely,

For 1 Node Cluster,

I was using the vmdk file from vertica as well as I have installed it in virtual box.

When it comes to 3 node,

I did not know to create a link between the cloned machine. the link helped me a lot and it is a great article.

Thanks for sharing.

Thanks,
Vignesh N.
by vigneshn
Wed Sep 09, 2015 12:16 pm
Forum: Vertica Installation
Topic: Install 3 Node Vertica Cluster in VMWARE
Replies: 3
Views: 7141

Install 3 Node Vertica Cluster in VMWARE

Hi All, Till today, I was trying vertica using single node in my laptop. I would like to install 3 nodes using VMWARE. Any procedures document will be really helpful. I tried cloning single node but I am not sure how to configure hosts. I am newbie to VMWARE. Help is really appreciated. Thanks, Vign...
by vigneshn
Fri May 01, 2015 2:50 pm
Forum: Vertica Performance Tuning
Topic: What is the difference between the Planned Concurrency and max concurreny in Resource Pool ?
Replies: 2
Views: 4440

What is the difference between the Planned Concurrency and max concurreny in Resource Pool ?

I tried getting answers from the reference guide , but Could not get better understanding.
by vigneshn
Tue Mar 17, 2015 5:38 pm
Forum: Vertica User Defined Functions (UDFs)
Topic: Masking - UDF
Replies: 2
Views: 3342

Masking - UDF

Hi, I am planning to write a function, to mask the data in the table. The masking should be reversible. So I tried a logic in C program. Please find attached the C program. This program, shuffles the position of data The Sample Output of the C program shuffle.c $ ./1.out vignesh The argument supplie...
by vigneshn
Mon Mar 16, 2015 6:07 pm
Forum: Vertica SQL
Topic: Select count(*) in Sub query
Replies: 2
Views: 3520

Select count(*) in Sub query

Hi I am trying to get the count(*) from a subquery which has a column count(*) . The result of outer query according to me should be 1, but it takes the count(*) from the inner query and results the inner query's count(*). Is this known/correct behaviour. -- Inner Query Output. dbadmin=> select 'No ...
by vigneshn
Tue Mar 10, 2015 6:20 pm
Forum: Vertica Data Load
Topic: Data in WOS
Replies: 6
Views: 3915

Re: Data in WOS

Thanks Jim and Norbertk for your time in explaining the concept. I got an one more doubt what will happen if we insert with *Direct* options. From the documentation it says , the records directly move to ROS. But I feel that any data moving to Hard disk moves via Ram. In our case it is WOS. So what ...
by vigneshn
Sun Mar 08, 2015 4:47 am
Forum: Vertica Data Load
Topic: Data in WOS
Replies: 6
Views: 3915

Re: Data in WOS

Thanks for your reply.

I am just reiterating . Please correct me if I am wrong, If I insert a record to a table having 10 projections then WOS will have 10 records. A record for every projection.

Go to advanced search