Vertica Blog

Vertica Version 10 Launches Today!

Posted March 31, 2020 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Happy engineer with wide arms and graphs floating above him

Vertica Engineers Go Deep at Vertica BDC – Last Chance to Register!

I have had the privilege over the last few weeks to work with the Vertica engineering team as they developed, practiced and polished their presentations for the virtual Vertica Big Data Conference. Years back, I was an engineer, and spent the vast majority of my days alone in an office writing, compiling and testing code....
goldfinch songbird in a field of thistle in Wales

COVID-19 Birdsong

For a number of years, when presenting one of my favourite Vertica demos, in which I talk about , I would typically start with a short, 30-second video clip to get the audience’s attention. The inspiration for this clip came about when I was staring aimlessly into the blue sky above my home in Pennard...
Map with pins

Loading ZIP Code Boundaries from a Shapefile in Three Easy Steps!

Are you working on a project where you'd like to classify position data into a geographic region? The US Census Bureau provides shapefiles for ZIP code tracts that you can ingest into Vertica and use to identify the ZIP code for given coordinates. In this exercise, we'll load the shapefile into Vertica, examine the contents,...

Announcing the Availability of Grafana Data Source Plugin for Vertica

The Vertica-Grafana-Plugin is finally here! Grafana allows you to query, visualize, alert on, and understand your metrics. Grafana has a repository where plugins are available for many Apps and Data Sources and they promote the development of plugins from the Grafana community. We are pleased to announce the availability of the vertica-grafana-datasource, a community developed...
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

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...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Helpful Tips in blue text with magnifying glass

Viewing Parquet Export Events More Easily

The EXPORT TO PARQUET command exports a table, columns from a table, or query results to files in the Parquet format. When you run EXPORT TO PARQUET information about the files created during the export is stored in the Vertica log. It's no fun combing through a Vertica log looking for those particular records. Good...
Hand writing the text: Helpful Tips

Clearing the Screen in VSQL

Lots of old school folks use VSQL for administrative tasks. As you enter commands, eventually the command prompt will end up at the bottom left of the screen making it a little difficult to read any additional output from your commands. You can clear the screen and move the prompt back up to the top...
A cloud of data points with a businessman's hand holding it up on a black background

Vertica’s Eon Mode – New Architecture for Flexibility, Performance, and Savings

Vertica was born in the age of the enterprise data warehouse (EDW) appliance, in 2005. At the time, the EDW appliance was a great idea – a relatively simple bundle of hardware and software. You plugged it in, and it worked. This single box came with a lot of services, too. But it also came...

Explore Popular Topics

Business man showing profitable stock market graph hologram over a tablet.

Finding Patterns in Stock Prices With Vertica

Vertica can ingest data from many sources and enable SQL-based preparation and analytics. Here is another real-world example: Let's use Vertica to find patterns in a public data set of stock and (Exchange-Traded Fund) ETF prices from Kaggle. I’ll use the following data source in this post: This data source provides several thousand files for...
Planets in solar system

The Kafka Convergence

Apache Kafka seems to be everywhere these days. I’m feeling a bit surrounded by Kafka right now, in fact, like I’m at the center of a convergence of the planets, and data flowing through Kafka is the gravitational pull. Let me give you an idea of what I mean. So, Vertica just announced the release...
Compass rose with true north pointing to "Helpful Tips" text

Which Database Mode Is My Database Using?

You can run Vertica in either Eon Mode or Enterprise Mode. The primary difference between Eon and Enterprise Modes is where they store data. Eon Mode stores data in a shared object store called communal storage, while Enterprise Mode stores data across the filesystems of the database nodes. If you are working with a new...
partner fist bump

Vertica Partners Are the Key to Your Success at BDC 2020

There are a lot of reasons to be excited about the Vertica Big Data Conference 2020. One of my favorite parts of the event will be introducing our partner ecosystem to our customers! As Vertica’s partner marketing manager, one of my guiding principles is that innovation doesn’t happen in a silo.
Calculating ROI

Learn How Much Money Vertica Can Save Your Business

The ROI for software systems is notoriously tough to pin down. The effort to integrate new software with systems already in place often adds time and labor costs to the upfront investment. What’s more, if there is any cultural resistance to change, then the ROI can be impossible to measure for months or years, or...
Santa flying over night sky

Tracking Santa’s Flight Plan

You probably all know of my love for (or more precisely a plethora of them) and Vertica. Although I started flight tracking around 2012, my interest grew when I saw this from NATS (National Air Traffic Services) - a series of great video clips from UK, Middle East, Europe and North Atlantic Though at this...