Search found 1797 matches

by JimKnicely
Thu Feb 22, 2018 6:25 pm
Forum: General
Topic: Monitor query cascading
Replies: 1
Views: 39

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

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

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

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

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

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...
by JimKnicely
Fri Jan 26, 2018 2:26 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Generate a Random String
Replies: 0
Views: 83

Vertica Quick Tip: Generate a Random String

Vertica Community Blog post authored by Jim Knicely
You saw in a previous Vertica Quick Tip that you can create a SQL function that generates random dates. How about one that generates random strings?

Read more here:
https://forum.vertica.com/discussion/23 ... dom-string

Go to advanced search