Search found 1798 matches

by JimKnicely
Sat Feb 24, 2018 4:33 pm
Forum: Vertica Analytics
Topic: Vertica Logistic Reg Function
Replies: 1
Views: 28

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

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

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

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

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

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...
by JimKnicely
Mon Jan 29, 2018 4:50 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: A Truly Unique Constraint
Replies: 0
Views: 114

Vertica Quick Tip: A Truly Unique Constraint

Vertica Community Blog post authored by Jim Knicely According to the ANSI standards SQL:92, SQL:1999, and SQL:2003, a UNIQUE constraint should disallow duplicate non-NULL values, but allow multiple NULL values. A Unique Constraint in Vertica does just that! But what if I do not want to allow more t...

Go to advanced search