Search found 21 matches

by banurajadurai
Wed Nov 13, 2013 6:23 am
Forum: Vertica Analytics
Topic: Compression Ratio varies with number of nodes
Replies: 7
Views: 31624

Re: Compression Ratio varies with number of nodes

i have loaded 39 GB of raw data In single node it is compressed to 5.1 GB and in 3 node it is compressed to 12.01 GB with K safety 1 (Original data + 1 backup copy) 1 GB differece ..... All Table structure , Optimized Query , Db designs are same in both the single and 3 node Vertica .. why this larg...
by banurajadurai
Tue Nov 12, 2013 10:11 am
Forum: Vertica Database Administration
Topic: Vertica's Compression and Encoding
Replies: 7
Views: 17796

Re: Vertica's Compression and Encoding

HI ,

Can anyone please tell me whether compression ratio varies with number of nodes .

My raw data size is 11 gb , in single node it is compressed to 3 Gb , in 3 node cluster it is compressed to 2 GB

waiting for reply
by banurajadurai
Tue Nov 12, 2013 7:12 am
Forum: Vertica Analytics
Topic: Compression Ratio varies with number of nodes
Replies: 7
Views: 31624

Compression Ratio varies with number of nodes

HI

How Exactly data is compressed in Multinode Vertica set up ? Is there any difference in Compression ratio with number of nodes ?
by banurajadurai
Tue Oct 29, 2013 12:45 pm
Forum: Vertica Installation
Topic: installing node on a cluster -elastic cluster
Replies: 1
Views: 13467

installing node on a cluster -elastic cluster

hi


does the operating system for all nodes ,where we are about to install vertica should be same .
if 3 nodes means all 3 nodes have same os running in them
by banurajadurai
Thu Sep 26, 2013 9:54 am
Forum: Vertica Backup & Recovery
Topic: Unable to connect to db , while taking backup
Replies: 7
Views: 33863

Re: Unable to connect to db , while taking backup

Thanku :) Now its working fine ..

Sorry for confusion , me and my colleague was working on this so bit confusion :)
Banu Rajadurai
by banurajadurai
Thu Sep 26, 2013 8:12 am
Forum: Talend
Topic: Copy command in talend and in perl code
Replies: 1
Views: 14064

Copy command in talend and in perl code

hi,

What is the difference between using copy command from talend tool and in perl code . Both will connect to DB and issue copy ,but which is more advantageous to use from tool or through code??

Go to advanced search