Search found 1806 matches

by JimKnicely
Mon Mar 26, 2018 3:24 pm
Forum: General
Topic: Handling Large Objects, Data Greater than 32 MB
Replies: 1
Views: 401

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

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

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

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

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

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...
by JimKnicely
Mon Feb 05, 2018 9:58 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Default Size of the NUMBER Data Type
Replies: 0
Views: 347

Vertica Quick Tip: Default Size of the NUMBER Data Type

Vertica Community Blog post authored by Jim Knicely When creating a table where you do not define a precision for a NUMBER column data type, Vertica will use a default precision of 38 digits. Often this is larger than necessary. By specifying NUMBER(37) you will potentially get better query perform...

Go to advanced search