Search found 21 matches

by banurajadurai
Mon Jan 06, 2014 11:07 am
Forum: Vertica Performance Tuning
Topic: INCREASE COMPRESSION RATIO
Replies: 0
Views: 4955

INCREASE COMPRESSION RATIO

Hi i have 1 column for date as datetime ,
Can u all suggest me the best way to store date and time , to increase the compression ratio.


I mean , in which case compression ratio will be high ????
a) Keeping column as datetime or seperate columns for Date and time ???
Reply sooon :-)
by banurajadurai
Fri Nov 29, 2013 1:11 pm
Forum: ODBC
Topic: !! error occurred during query execution
Replies: 0
Views: 13165

!! error occurred during query execution

Dear all, I am new to Vertica. I am using ODBC in perl to connect to vertica database. I am trying to run a complex select query using DBD::ODBC. The query yields few records and exits randomly after fetching few records. Below is the error which is being thrown DBD::ODBC::st fetch failed: [unixODBC...
by banurajadurai
Mon Nov 18, 2013 10:08 am
Forum: Perl
Topic: ODBC buffer size
Replies: 3
Views: 62662

Re: ODBC buffer size

hi m facing the same error again , i increased the buffer size to 5000000000, even then After fetching 2047 rows the script is getting stopped with error DBD::ODBC::st fetchrow_array failed: [unixODBC][Vertica][VerticaDSII] (20) An error occurred during query execut ion: (SQL-HY000) at TDA_test.pl l...
by banurajadurai
Thu Nov 14, 2013 12:24 pm
Forum: Perl
Topic: fetchrow_array in perl
Replies: 7
Views: 31321

Re: fetchrow_array in perl

HI , last time too fetchrow_array was not working for me , Again got stucked there :( When i fetch large number of Rows from Vertica using perl code , m ending up with DBD::ODBC::st fetchrow_array failed: [unixODBC][Vertica][VerticaDSII] (20) An error occurred during query execution: ERROR Please He...
by banurajadurai
Thu Nov 14, 2013 10:58 am
Forum: Vertica Analytics
Topic: Compression Ratio varies with number of nodes
Replies: 7
Views: 31650

Re: Compression Ratio varies with number of nodes

NO yaar , thats wat m saying ,
in single node compression ratio s 12 GB befor DBD operation and ONCE i run dbd it is reduced to 5 GB ....
in 3 node after running DBD it is 12 GB (1 backupcopy + Actual data with ksafety 1.... Means Actual data = 6 GB )

1 GB diffrence .
by banurajadurai
Thu Nov 14, 2013 7:01 am
Forum: Perl
Topic: Can't connect to Vertica database
Replies: 1
Views: 14879

Can't connect to Vertica database

Hi m using 3 node vertica (ex: node A B C). m trying to connect to Vertica database from perl code from Node A . i installed all ODBC drivers . Now when executing perl code m not able to connect to db, its throwing error as DBI connect('VerticaDSN','tdaadmin',...) failed: [unixODBC][Vertica][ODBC] (...
by banurajadurai
Thu Nov 14, 2013 5:52 am
Forum: Vertica Analytics
Topic: Compression Ratio varies with number of nodes
Replies: 7
Views: 31650

Re: Compression Ratio varies with number of nodes

IN single node vertica , For super projection Compression ratio was 12.71 GB .

Go to advanced search