Review the reply here:
https://forum.vertica.com/discussion/23 ... -cascading
Search found 1825 matches
- Thu Feb 22, 2018 6:25 pm
- Forum: General
- Topic: Monitor query cascading
- Replies: 1
- Views: 14827
- Tue Feb 06, 2018 6:57 pm
- Forum: Vertica Links
- Topic: Vertica Blog Post: Beware of Segmentation Islands
- Replies: 0
- Views: 15873
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...
- Tue Feb 06, 2018 6:52 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: Add a Time Zone
- Replies: 0
- Views: 15505
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...
- Mon Feb 05, 2018 10:02 pm
- Forum: Vertica Links
- Topic: Vertica Tip: Predicting the Resources a Statement Needs
- Replies: 0
- Views: 15308
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...
- Mon Feb 05, 2018 9:58 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: Default Size of the NUMBER Data Type
- Replies: 0
- Views: 15256
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...
- Mon Jan 29, 2018 4:50 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: A Truly Unique Constraint
- Replies: 0
- Views: 15075
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...
- Fri Jan 26, 2018 2:26 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: Generate a Random String
- Replies: 0
- Views: 15554
Vertica Quick Tip: Generate a Random String
Vertica Community Blog post authored by Jim Knicely
Read more here:
https://forum.vertica.com/discussion/23 ... dom-string
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