Vertica Blog

Vertica Blog

Vertica Blog

Vertica Quick Tip: Date Arithmetic

This blog post was authored by Jim Knicely. Date arithmetic in Vertica is extremely easy! What is today’s, yesterday’s and tomorrow’s date? But you’re not limited to whole days! You can also easily add and subtract partial days (i.e. hours, minutes and seconds)! Have Fun!

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. A table named BIG_DATE_TABLE has 1 billion rows and a column...

Eon Mode Beta Overview in 9.0.1

This blog post was authored by Soniya Shah. What is Eon Mode Beta? In Vertica 9.0.1, Eon Mode Beta, the separation of compute and storage, continues on Amazon Web Services S3. Eon Mode Beta was introduced in Vertica 9.0 to capitalize on cloud economics, while still enjoying the fast query processing for which Vertica is...

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. For example: But what if I need a random date? Luckily in Vertica I can create my own SQL function for that! Example

Vertica Test Results for Operating System Patches for Meltdown and Spectre Security Flaws

For the latest Vertica update on the Meltdown and Spectre security flaws, read this blog: UPDATED: Vertica Test Results with Microcode Patches for the Meltdown and Spectre Security Flaws, published May 21, 2018. Vertica engineers have run performance tests using the operating system patches for the Meltdown and Spectre security flaws. Based on the results,...

Vertica Quick Tip: The LIMIT Analytic Function

This blog post was 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. Example Say I have the following table data: But I only want to see the latest test number for each date. For...

Vertica Quick Tip: How to Query for NaN Values

This blog post was 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 using the predicate...

IMPORTANT: What you need to know about hardware security flaws

Vertica is aware of potential chip-level security flaws in recently discovered hardware bugs. Operating system vendors have developed patches to address these problems. Installing the patches could impact application performance. Vertica engineers are actively investigating how these patches might affect Vertica performance and will keep our customers informed. There is much speculation about the impact...

Authentication Methods for dbadmin

This blog post was authored by Sumeet Keswani. In Vertica, when you create a new database, there are no configured authentication methods. In this case, Vertica assumes that all users, including the dbadmin, have an implicit password authentication. Users can use this authentication method both for authenticating over a network interface and for over a...
Three 3D arrows, different colors pointing in different directions

DataGals Year in Review

The DataGals had an amazing 2017! Everyone on our steering committee - Lisa Donaghue, Styliani Pantela, Soniya Shah, Diem Tran, and Sharada Vesta would like to wish you a very happy new year! Check out our year in review below. We look forward to a successful 2018. Happy holidays from the DataGals!

External data is easier to manage than the Hadoop Stack

This blog post was authored by Steve Sarsfield. It has been a thrilling ride. In a few short years, Hadoop has seen astronomical rise, but recently, interest in Hadoop has peaked. Analysts like Gartner and Datanami are reporting that the hype in Hadoop is waning, with some hope that use cases for Hadoop will find...
Programmer

Vertica in the Clouds

This blog post was authored by Soniya Shah. The benefits of using cloud computing and storage are virtually endless. You can scale services up or down to fit your needs, customize applications, and access cloud services from everywhere. Using the cloud makes it easy to scale elastically and makes infrastructure both affordable and flexible. With...