Search found 302 matches

by nnani
Wed Apr 23, 2014 8:21 am
Forum: Vertica Data Load
Topic: INSERT very slow
Replies: 6
Views: 13404

Re: INSERT very slow

Hi Skwa,

I was not sure on the Pyvertica usage last year, but it seems there are many new features with this driver now.
Thanks for pointing us to this. :)

Surely going to try this.
by nnani
Tue Apr 22, 2014 7:03 am
Forum: Vertica Management Console
Topic: management console inconsistent info on nodes
Replies: 0
Views: 12706

management console inconsistent info on nodes

Hello All, This thing caught my attention when we were trying to look at the cluster state in the Manage tab of MC. In Manage tab, we can see all the nodes and their health, status and much more info. My problem is. For 1 cluster 1. I can't see consistent info on all nodes, first 5 nodes I have IP, ...
by nnani
Mon Apr 21, 2014 6:16 am
Forum: Vertica Management Console
Topic: Time Service Task Error
Replies: 1
Views: 14328

Time Service Task Error

Hello All, Going through the management console, I see it is giving many warnings, stating "Time Service Task Error" There is no documentation on these warnings . what are these warnings and what are causing them. Any document which states all these warnings and errors and their causes. I think mana...
by nnani
Mon Apr 21, 2014 6:05 am
Forum: Vertica SQL
Topic: add column in ordinal positions
Replies: 1
Views: 8111

add column in ordinal positions

Hello All, Can we a add a column into an existing table at a specific ordinal position. I can see the ordinal postions of columns in the columns table, If I want to add a column in middle of ordinal positions, Can we do it. Is there some different alter table statement. I want to do it using Alter t...
by nnani
Wed Apr 16, 2014 4:17 pm
Forum: Vertica Database Administration
Topic: max k-safety
Replies: 5
Views: 10696

max k-safety

Hello All,

What is the maximum number of k-safety value we can configure.

Lets say I have a 10 node cluster, what will be the best k-safety and what will be the max k-safety

Thanks
by nnani
Tue Apr 15, 2014 6:29 am
Forum: Announcements, Events and Activities
Topic: Mike Stonebraker's 70th Birthday
Replies: 0
Views: 4715

Mike Stonebraker's 70th Birthday

Hello All,

I know I am a bit late on this :) .
But if any body attended this, it would be a chance of lifetime.

http://stonebraker70.com/

Thanks
by nnani
Mon Apr 14, 2014 8:42 am
Forum: Vertica Database Administration
Topic: Copy schema statistics
Replies: 5
Views: 9557

Re: Copy schema statistics

Hi, Regarding Export Statistics Generates an XML file that contains statistics for the database. You can optionally export statistics on a single database object (table, projection, or table column). If you wish to generate this for schema, then you can try this. 1. Generate statistics xml file for ...

Go to advanced search