Vertica Blog

Vertica Blog

SQL

List the Missing Dates in a Date Series

James Knicely, Vertica Field Chief Technologist
October 22, 2020

The TIMESERIES clause in Vertica makes it easy to list all of the gap days (that is, those that are missing) from a series of dates. Say I have this simple date series: As you can see, there are several dates missing from the series (2020-10-30, 2020-11-02, 2020-11-03 and 2020-11-04). I can list these absent...
Compass rose with true north pointing to "Helpful Tips" text

Getting Every Nth Row from a Table (Enhanced)

James Knicely, Vertica Field Chief Technologist
October 20, 2020

In a previous Vertica Quick Tip we learned how to query every Nth row from a table when we had a unique ID column having sequential values (that is, from a sequence). See, https://www.vertica.com/blog/vertica-quick-tip-getting-every-n-th-row-table/ What if we don’t have a key like that in our table? No problem thanks to the ROW_NUMBER() Analytic Function! Say...
Electronic medical record on digital smart device

Vertica in Good Health: Ingesting, Securing, and Analyzing Healthcare Data

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
September 29, 2020

Electronic Medical Records and new personal healthcare technology, particularly medical devices, generate a huge amount of data. Organizations including Cerner and Philips Healthcare rely on Vertica for data analysis. How can Vertica help you analyze this data? Vertica excels at data ingest and provides hundreds of built-in SQL and analytic functions with broad integration with...

Constellation Research Report Finds Vertica 10 a Leading Choice

Mike Perrow, Senior Product Marketing Writer/Editor
September 14, 2020

A few pages into a new, detailed overview of Vertica 10, produced by Constellation Research, principle analyst Doug Henschen summarizes the top new capabilities of Vertica 10 like this: In short, the Vertica team has steadily evolved the product to keep pace with the demands of organizations that seek to do the following: Unify diverse...
Quick Tip - blue button

Copy a Table with an Identity to a Table with an Identity on the Same Database Keeping the Identities in Sync

James Knicely, Vertica Field Chief Technologist
May 25, 2020

An IDENTITY associates a table column with a sequence. This sequence automatically increments the column value as new rows are added. There are some noteable restrictions on IDENTITY columns: You cannot INSERT values manually into an IDENTITY column You cannot UPDATE the values of an IDENTITY column once they has been populated via the sequence...
Visual Storytelling

VSQL, Visual Storytelling through Query Language

Moshe Goldberg, Vertica System Engineer
May 21, 2020

This tip expands on my earlier post: “Pure Vertica SQL Graph Flavors” Visual story telling has not just the ability to capture attention, it make things simple to understand. Consider the following to boost your query result set readability. What is the visual correlation between CPU utilization and Canary Queries elapsed time?      ...
Brandeis University sign

Hands-on Class Makes Parallel Data Management Theories Concrete

Mike Perrow, Senior Product Marketing Writer/Editor
February 5, 2020

Parallel data management in databases is a tough thing to learn when you’re a student. It can feel like another one of those esoteric theories, and it never quite sticks. Now, there’s a cool class at Brandeis University that brings those lofty theories down to earth, and gives students a real chance to see how...
Helpful Tips text with hand and marker over data center background

Define a Vertica Flattened Table Column as Having Both DEFAULT and SET USING Constraints

James Knicely, Vertica Field Chief Technologist
January 31, 2020

Columns in a flattened table can query other tables with constraints DEFAULT and SET USING . Vertica executes DEFAULT queries only on new rows when they are added to the flattened table, through load operations such as INSERT and COPY. Thereafter, changes in the original data sources have no effect on the flattened table. Vertica...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

2 – What Are the Benefits of Using Complex Data Types in SQL?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
December 19, 2019

Co-authored by James Clampffer, Deepak Majeti. In this second post in the Complex Data Types blog series, let’s look at some of the reasons complex types are used extensively in organized big data formats like ORC and Parquet. Be sure to read the first post in this series where we discussed the what complex data...
TOP 5 - with stars on white background - 3D

Top 5 Reasons Why You Win Big with Data at the Vertica Big Data Conference 2020

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
December 9, 2019

A few years ago, we held a user conference for our growing Vertica community. However, we underestimated its success – selling out the inaugural event because we had booked a venue that couldn’t accommodate the interest of hundreds of customers, prospects, and partners for what turned out to be Boston’s biggest and best Big Data...
Tips and Tricks Orange Button

Moving a Table to a New Schema and Inheriting the New Schema Privileges

James Knicely, Vertica Field Chief Technologist
December 6, 2019

You can move a table from one schema to another schema with a simple ALTER TABLE command. But, you might be surprised that the table will not inherit the new schema’s privileges even if the new schema was created using the DEFAULT INCLUDE PRIVILEGES directive. After moving the table you will need to manually alter...

Announcing Vertica 9.3 Instructor-Led Training Courses

Drea Brandford, Technical Consultant
November 21, 2019

Just in time for the release of version 9.3, Vertica is pleased to announce the release of two updated instructor-led training courses: Vertica 9.3 Essentials and Vertica 9.3 Descriptive Analytics. A description of each course follows: Vertica 9.3 Essentials This 4-day course explores the capabilities of the Vertica platform solution in Enterprise mode, and prepares...