Search found 8 matches

by fotographs
Thu Jul 11, 2013 10:26 pm
Forum: Vertica Database Administration
Topic: Adding third node to community server fails
Replies: 1
Views: 816

Re: Adding third node to community server fails

I re-created the entire cluster by specifying 3 nodes and now the cluster shows all 3 nodes active.

Adding a third node after creating a 2 node cluster did not work.
by fotographs
Thu Jul 11, 2013 8:44 pm
Forum: Vertica Database Administration
Topic: Adding third node to community server fails
Replies: 1
Views: 816

Adding third node to community server fails

I tried adding a third node to a 2-node Community Edition cluster. when I tried the Add Hosts option, it went through the motions of creaeting the database directories/catalog but gave an error "Failed to add nodes to database. Cannot create node. The current license permits 3 nodes and the database...
by fotographs
Tue Jul 09, 2013 8:38 pm
Forum: New to Vertica Database Administration
Topic: Avoiding super projection
Replies: 8
Views: 3428

Re: Avoiding super projection

I was hoping to avoid an extra load

Looks like I have to create a separate table and manage space accordingly

Thank you for your help.
by fotographs
Tue Jul 09, 2013 8:06 pm
Forum: New to Vertica Database Administration
Topic: Avoiding super projection
Replies: 8
Views: 3428

Re: Avoiding super projection

Vertica chooses the correct plan..I just need to purge the super projection data but retain the optimized projection...(ie. I have partitioned the data by date...can I drop just the partitions of the super-projection while keeping the partitions of the optimized projection ?
by fotographs
Tue Jul 09, 2013 8:05 pm
Forum: Vertica Database Administration
Topic: Adding a new node to a single host cluster
Replies: 3
Views: 1807

Re: Adding a new node to a single host cluster

Yes..looks like that is the issue

Thank you for the clarification
by fotographs
Tue Jul 09, 2013 7:11 pm
Forum: New to Vertica Database Administration
Topic: Avoiding super projection
Replies: 8
Views: 3428

Re: Avoiding super projection

Hi

I was looking more at purging the super projection to keep data usage under control. (I am aware that the actual projection can be queried directly)..

Here is what I need

purge super_projection (is this allowed)..
by fotographs
Tue Jul 09, 2013 7:09 pm
Forum: Vertica Database Administration
Topic: Adding a new node to a single host cluster
Replies: 3
Views: 1807

Adding a new node to a single host cluster

I setup a Vertica instance on a single host. The admin Web Page shows a cluster with a single host

I want to add a new machine to the cluster. When I involve the Add Host command form the adminTools menu, I get a message

"All hosts are participating in this cluster"..and nothing happens

Go to advanced search