Search found 6 matches
- Tue Nov 05, 2013 2:36 am
- Forum: New to Vertica
- Topic: Can not create buddy projection ?
- Replies: 3
- Views: 12246
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...
- Mon Nov 04, 2013 4:44 am
- Forum: New to Vertica
- Topic: Can not create buddy projection ?
- Replies: 3
- Views: 12246
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...
- Mon Oct 28, 2013 8:36 am
- Forum: Vertica Installation
- Topic: [ERROR] Post-install check failed.
- Replies: 4
- Views: 19230
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 ...
- Mon Oct 28, 2013 8:20 am
- Forum: Vertica Installation
- Topic: [ERROR] Post-install check failed.
- Replies: 4
- Views: 19230
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...
- Fri Oct 25, 2013 4:21 pm
- Forum: Vertica Installation
- Topic: [ERROR] Post-install check failed.
- Replies: 4
- Views: 19230
Re: [ERROR] Post-install check failed.
Thanks knicely87 . I will change node1 to "centos"
- Fri Oct 25, 2013 12:15 pm
- Forum: Vertica Installation
- Topic: [ERROR] Post-install check failed.
- Replies: 4
- Views: 19230
[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...