Search found 1796 matches

by JimKnicely
Tue Feb 06, 2018 6:57 pm
Forum: Vertica Links
Topic: Vertica Blog Post: Beware of Segmentation Islands
Replies: 0
Views: 69

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

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

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

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

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

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
by JimKnicely
Fri Jan 26, 2018 2:24 pm
Forum: Vertica Links
Topic: Vertica Quick Tip: Which rows will commit?
Replies: 0
Views: 44

Vertica Quick Tip: Which rows will commit?

Vertica Community Blog post authored by Jim Knicely Did you ever update a bunch of rows in a table, then forget which ones you changed? Fearing you might have updated an incorrect record, you might have to roll back and start again. Or, in Vertica you can first check which records have been modifie...

Go to advanced search