Search found 1825 matches
- Fri Jan 26, 2018 2:24 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: Which rows will commit?
- Replies: 0
- Views: 14116
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...
- Fri Jan 26, 2018 2:23 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: Date Arithmetic with Intervals
- Replies: 0
- Views: 14128
Vertica Quick Tip: Date Arithmetic with Intervals
Vertica Community Blog post authored by Jim Knicely
Read more here:
https://forum.vertica.com/discussion/23 ... ertica-tip
In the last Vertica Quick Tip we saw how easy date arithmetic can be. Well, it can be even easier with Intervals!
Read more here:
https://forum.vertica.com/discussion/23 ... ertica-tip
- Fri Jan 26, 2018 2:22 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: Date Arithmetic in Vertica
- Replies: 0
- Views: 14338
Vertica Quick Tip: Date Arithmetic in Vertica
Vertica Community Blog post authored by Jim Knicely
Read more here:
https://forum.vertica.com/discussion/23 ... in-vertica
Date arithmetic in Vertica is extremely easy!
Read more here:
https://forum.vertica.com/discussion/23 ... in-vertica
- Fri Jan 26, 2018 2:21 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: Avoid Using Functions on Very Large Data Sets
- Replies: 0
- Views: 14044
Vertica Quick Tip: Avoid Using Functions on Very Large Data Sets
This blog post was authored by Jim Knicely. You can store billions and billions and billions (i.e., a lot) of records in your Vertica tables. When querying these large data sets, try to avoid using database functions like TO_DATE, TO_CHAR, NVL, etc. when unnecessary. Read more here: https://forum.v...
- Fri Jan 26, 2018 2:20 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: Generating a Random Date
- Replies: 0
- Views: 14013
Vertica Quick Tip: Generating a Random Date
This blog post was authored by Jim Knicely.
I can easily generate a random integer value using the Vertica built-in RANDOMINT function.
Read more here:
https://forum.vertica.com/discussion/23 ... andom-date
- Fri Jan 26, 2018 2:19 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: The LIMIT Analytic Function
- Replies: 0
- Views: 5124
Vertica Quick Tip: The LIMIT Analytic Function
Vertica Community Blog post authored by Jim Knicely Vertica contains an abundance of built-in SQL analytic functions. One of the lesser known but also one of the coolest is the LIMIT analytic function. Read more here: https://forum.vertica.com/discussion/239345/vertica-quick-tip-the-limit-analytic-...
- Fri Jan 26, 2018 2:17 pm
- Forum: Vertica Links
- Topic: Vertica Quick Tip: How to Query for NaN Values
- Replies: 0
- Views: 5202
Vertica Quick Tip: How to Query for NaN Values
Vertica Community Blog post authored by Jim Knicely We’re introducing a new series: Vertica Quick Tips! These tips are intended to give you concise information to help you get the most out of using Vertica. NaN (Not a Number) does not equal anything, not even another NaN. You can query for them usi...