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...

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...

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 ...

@ 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...

Thanks knicely87 . I will change node1 to "centos"

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...