Search found 1804 matches

by JimKnicely
Mon Jun 04, 2018 1:22 pm
Forum: General
Topic: Primary Key Constraints
Replies: 7
Views: 282

Re: Primary Key Constraints

Oops... I put the email address! Sorry!

Here is the correct email address:

james.knicely@microfocus.com
by JimKnicely
Fri Jun 01, 2018 4:02 pm
Forum: General
Topic: Primary Key Constraints
Replies: 7
Views: 282

Re: Primary Key Constraints

Hi, I cannot reproduce this issue :( I noticed that your PK has the column order different (reversed) than the column order in the projections (by ordinal position) and by the ORDER BY and SEGMENTED BY positions. Can you send me via email the DDL for the table including projections? Use the EXPORT_O...
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: 105

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: 7
Views: 282

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: 923

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: 344

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: 471

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

Go to advanced search