Search found 6 matches

by komaty
Tue Nov 05, 2013 2:36 am
Forum: New to Vertica
Topic: Can not create buddy projection ?
Replies: 3
Views: 3356

Re: Can not create buddy projection ?

Thanks. I've done. But I get error "ERROR 3587: Insufficient resources to execute plan on pool general [Request exceeds session memory cap: 4611049KB > 2097152KB]" after using query (include join, example: select * from projection_A, projection_B where ...) You know, I have 3 nodes with 4GB-RAM each...
by komaty
Mon Nov 04, 2013 4:44 am
Forum: New to Vertica
Topic: Can not create buddy projection ?
Replies: 3
Views: 3356

Can not create buddy projection ?

Hi all, I want to create buddy projection, here my script: -- Create projection -- query_01 CREATE PROJECTION if not exists projection_test ( table_a_column_a, table_b_column_b ) as select tableA.col_a, tableB.col_b from tableA, tableB where tableA.FK_ID = tableB_PK_ID order by tableA.col_a unsegmen...
by komaty
Mon Oct 28, 2013 8:36 am
Forum: Vertica Installation
Topic: [ERROR] Post-install check failed.
Replies: 4
Views: 1647

Re: [ERROR] Post-install check failed.

Solved: + reinstall vertica on node 03. + add host: try again update_vertica -A host_name + add node . @knicely87: But I have a problem: in node 03 (/home/dbadmin/) is empty , but when I create new schema in NODE 01 (create schema abcd) , I can get data (see schema abcd) in NODE 03 (\dn command), I ...
by komaty
Mon Oct 28, 2013 8:20 am
Forum: Vertica Installation
Topic: [ERROR] Post-install check failed.
Replies: 4
Views: 1647

Re: [ERROR] Post-install check failed.

@ knicely87: I have the same error when trying add new node . (3 node have same OS Redhat - I cloned 3 machines) new node:10.1.101.115 [root@host01 ~]# /opt/vertica/sbin/update_vertica -A host03 -r /opt/newdisk/vertica_6.1.2.x86_64 Vertica Analytic Database 6.1.2-0 Installation Tool Starting install...
by komaty
Fri Oct 25, 2013 4:21 pm
Forum: Vertica Installation
Topic: [ERROR] Post-install check failed.
Replies: 4
Views: 1647

Re: [ERROR] Post-install check failed.

Thanks knicely87 . I will change node1 to "centos" :)
by komaty
Fri Oct 25, 2013 12:15 pm
Forum: Vertica Installation
Topic: [ERROR] Post-install check failed.
Replies: 4
Views: 1647

[ERROR] Post-install check failed.

Hi there, I try to install HP vertica on 2 nodes but i get error (below): node01: 10.1.101.102 (redhat) node02: 10.1.101.141 (centos 5.6) (of course, ssh node01 & node02 is ok) [root@localhost ~]# /opt/vertica/sbin/install_vertica -s host01,host02 -r /opt/vertica_6.1.2.x86_64 -u dbadmin Vertica Anal...

Go to advanced search