Vertica Blog

Learn How Much Money Vertica Can Save Your Business

Posted January 7, 2020 by Mike Perrow, Senior Product Marketing Writer/Editor

Read More

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...
Brandeis University sign

Hands-on Class Makes Parallel Data Management Theories Concrete

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

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

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

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

Explore Popular Topics

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