Search found 1800 matches

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

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

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

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

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

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...
by JimKnicely
Tue Feb 06, 2018 6:52 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Add a Time Zone
Replies: 0
Views: 228

Vertica Quick Tip: Add a Time Zone

Vertica Community Blog post authored by Jim Knicely Vertica recognizes many time zones. However, there might come a time (zone) when you will need to reference one that is not available by default. Luckily it’s relatively easy to add a time zone to Vertica. See how here: https://my.vertica.com/blog...
by JimKnicely
Mon Feb 05, 2018 10:02 pm
Forum: Vertica Links
Topic: Vertica Tip: Predicting the Resources a Statement Needs
Replies: 0
Views: 240

Vertica Tip: Predicting the Resources a Statement Needs

Vertica Community Blog post authored by Jim Knicely You may find you want to set up resource pools before running queries to know how many resources a particular query needs. One way to do this is to create a small resource pool, profile the query, and note when the query is rejected. When the quer...

Go to advanced search