Search found 1806 matches

by JimKnicely
Sun Jul 29, 2018 2:45 pm
Forum: Vertica Security
Topic: Objects invisible to users when NOT created by dbadmin
Replies: 2
Views: 92

Re: Objects invisible to users when NOT created by dbadmin

Check out the "Privileges Required for Common Database Operations" doc. In particular, the "Object Visibility" section: Here: https://my.vertica.com/docs/9.1.x/HTML/index.htm#Authoring/AdministratorsGuide/Security/DBUsersAndPrivileges/PrivilegesRequiredForCommonDatabaseOperations.htm Example: dbadmi...
by JimKnicely
Mon Jul 23, 2018 6:57 pm
Forum: Vertica Links
Topic: Big Data and Machine Learning London Meetup: The Movie!
Replies: 0
Views: 53

Big Data and Machine Learning London Meetup: The Movie!

Vertica's own Mark Whalley talks about the advantages of a columnar database like Vertica for analytics and machine learning, and provides some use cases in fashion and retail to show how it works.

https://www.youtube.com/watch?time_continue=31&v=EqER7Y74TII
by JimKnicely
Mon Jun 04, 2018 1:22 pm
Forum: General
Topic: Primary Key Constraints
Replies: 7
Views: 440

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

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

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

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

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

Go to advanced search