Oops... I put the email address! Sorry!
Here is the correct email address:
james.knicely@microfocus.com
Search found 1825 matches
- Mon Jun 04, 2018 1:22 pm
- Forum: General
- Topic: Primary Key Constraints
- Replies: 8
- Views: 157004
- Fri Jun 01, 2018 4:02 pm
- Forum: General
- Topic: Primary Key Constraints
- Replies: 8
- Views: 157004
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...
- 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: 18236
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...
- Fri May 25, 2018 8:46 pm
- Forum: General
- Topic: Primary Key Constraints
- Replies: 8
- Views: 157004
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...
- 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: 19323
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
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
- Mon Mar 26, 2018 3:24 pm
- Forum: General
- Topic: Handling Large Objects, Data Greater than 32 MB
- Replies: 1
- Views: 13729
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?
- Sat Feb 24, 2018 4:33 pm
- Forum: Vertica Analytics
- Topic: Vertica Logistic Reg Function
- Replies: 1
- Views: 43056
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=> ...