Search found 29 matches

by vcarusi
Sat Jun 10, 2017 3:00 pm
Forum: Vertica Certification
Topic: HP2-N45 Vertica Big Data Solutions Administrator
Replies: 18
Views: 5326

Re: HP2-N45 Vertica Big Data Solutions Administrator

Thank you, JimKnicely!
Infact, it is inactive:

Inactive certifications Inactive date
HP ASE - Vertica Big Data Solutions Administrator V1 15 Mar 2017
HP ATP - Vertica Big Data Solutions V1 01 Mar 2017
by vcarusi
Wed Jun 07, 2017 3:22 pm
Forum: Vertica Database Administration
Topic: change ip address
Replies: 6
Views: 763

Re: change ip address

I wrote a script that is executed before starting the vertica server. It changes the old ip address with the new one. old_ip_address = aaa.bbb.ccc.ddd new_ip_address old_broadcast_ip_address = old_ip_address.255 (aaa.bbb.ccc.255) new_broadcast_ip_address = new_ip_address.255 N_old_ip_address = Naaab...
by vcarusi
Wed Jun 07, 2017 8:33 am
Forum: Vertica Database Administration
Topic: change ip address
Replies: 6
Views: 763

Re: change ip address

hi,
but how to change the ip address for an one node vertica cluster.
there is an 'constraint' : the node must be done.
how to execute 'alter node' on an inactive (down) node ?
by vcarusi
Tue Jun 06, 2017 6:13 pm
Forum: Vertica Certification
Topic: HP2-N45 Vertica Big Data Solutions Administrator
Replies: 18
Views: 5326

Re: HP2-N45 Vertica Big Data Solutions Administrator

is this exam still active? from https://certification-learning.hpe.com/TR/DataSheet/Exam/HP2-N45?version=9&entityType=Exam Customers, follow these steps to register for the exam: 1. Sign up at the HPE Software Education Learning Portal 2. When you pass the hands on exam, you receive a voucher for th...
by vcarusi
Tue Jun 06, 2017 5:52 pm
Forum: Vertica Certification
Topic: HP2-N45 Vertica Big Data Solutions Administrator
Replies: 18
Views: 5326

Re: HP2-N45 Vertica Big Data Solutions Administrator

hi,
for me is unclear how to enroll for hands-on exam/lab?
can you provide me a link ?
thank you
by vcarusi
Thu Jun 02, 2016 10:00 am
Forum: Vertica Management Console
Topic: mc-activity-query monitoring-running queries-memory column
Replies: 6
Views: 5436

Re: mc-activity-query monitoring-running queries-memory column

hi, for a 'easy' query |request |memoryacquired_mb|pool_name|start_time |request_type|acquisition_mb| |SELECT 'fast'...| 100.0 |pool_1 |2016-06-02 10:41:01|Acquire | 100.0 | |SELECT 'fast',..| 100.0 |pool_1 |2016-06-02 10:41:01|Reserve | 25.00 | for a 'medium' query |request |memoryacquired_mb|pool_...
by vcarusi
Wed Jun 01, 2016 3:33 pm
Forum: Vertica Database Administration
Topic: resource pools chain
Replies: 4
Views: 1290

Re: resource pools chain

I obtained the following error when QUEUETIMEOUT has been exhaused (after 303 sec) : Insufficient resources to execute plan on pool general [Timedout waiting for resource request: Request exceeds limits: Memory(KB) Exceeded: Requested = 2733342, Free = 0 (Limit = 17831818, Used = 18251444) (queueing...

Go to advanced search