Search found 1802 matches

by JimKnicely
Fri May 25, 2018 8:59 pm
Forum: General
Topic: [Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general
Replies: 1
Views: 27

Re: [Vertica][VJDBC](3587) ERROR: Insufficient resources to execute plan on pool general

Hi, Check on the query budget available for each query: SELECT node_name, memory_size_kb, max_memory_size_kb, planned_concurrency, query_budget_kb FROM resource_pool_status WHERE pool_name = 'general'; Most likely for you it will be 188 GB * (0.95) / 48 = 3.72 GB Check the last 5 events where memory...
by JimKnicely
Fri May 25, 2018 8:46 pm
Forum: General
Topic: Primary Key Constraints
Replies: 1
Views: 12

Re: Primary Key Constraints

Hi, If you have an enabled PK constraint there has to be at least one "special" Projections to enforce it. Check if the new unsegmented projection you created is one of those (in the PROJECTIONS system table, IS_KEY_CONSTRAINT_PROJECTION will be TRUE). If so, you can drop the segmented projection. E...
by JimKnicely
Wed Apr 04, 2018 7:00 pm
Forum: New to Vertica Database Administration
Topic: admintools has random letters all over the screen
Replies: 1
Views: 855

Re: admintools has random letters all over the screen

Hi,

Run this:

export NCURSES_NO_UTF8_ACS=1

And add the command to your .bashrc file so the change is applied every time you log on!

echo export NCURSES_NO_UTF8_ACS=1 >> ~/.bashrc
by JimKnicely
Mon Mar 26, 2018 3:24 pm
Forum: General
Topic: Handling Large Objects, Data Greater than 32 MB
Replies: 1
Views: 320

Re: Handling Large Objects, Data Greater than 32 MB

Hi, There is a maximum row size of 32,768,000 bytes... so if using all 32,000,000 bytes in a single LONG VARCHAR, that doesn't leave much room for a second LONG VARCHAR in the same table. You'd have to use separate tables. Question: What do you plan on doing with storing data of this size in Vertica?
by JimKnicely
Sat Feb 24, 2018 4:33 pm
Forum: Vertica Analytics
Topic: Vertica Logistic Reg Function
Replies: 1
Views: 421

Re: Vertica Logistic Reg Function

Hi, The privileges on the ML functions must not be granted to PUBLIC. Have the admin user run the following script in vsql to reinstall the ML Package: vsql -f /opt/vertica/packages/MachineLearning/ddl/install.sql After re-installing you should see the EXECUTE privilege granted to PUBLIC: dbadmin=> ...
by JimKnicely
Thu Feb 22, 2018 6:25 pm
Forum: General
Topic: Monitor query cascading
Replies: 1
Views: 362

Re: Monitor query cascading

by JimKnicely
Tue Feb 06, 2018 6:57 pm
Forum: Vertica Links
Topic: Vertica Blog Post: Beware of Segmentation Islands
Replies: 0
Views: 516

Vertica Blog Post: Beware of Segmentation Islands

Vertica Community Blog post authored by Curtis Bennett Many clients who are new to Vertica are also new to big data. While Vertica’s reliance on industry-standard SQL can make the transition very easy, often the introduction of multiple nodes used in support of a database platform can take some get...

Go to advanced search