Learn How Much Money Vertica Can Save Your Business

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

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

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
February 4, 2020

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

Stephen Crossman, SW Engineering(Systems) - Partner Engineering
February 3, 2020

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

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

Jim Knicely, Vertica Principal Solution Architect
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...

Helpful Tips in blue text with magnifying glass

Viewing Parquet Export Events More Easily

Jim Knicely, Vertica Principal Solution Architect
January 27, 2020

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.

Clearing the Screen in VSQL

Jim Knicely, Vertica Principal Solution Architect
January 27, 2020

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

Joy King, VP, Vertica Product Management & Product Marketing
January 21, 2020

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

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
January 21, 2020

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

DBadmin
SQL
VSQL
Best Practices
machine learning
Advanced Analytics
Cloud
Eon Mode
AWS
Vertica
Projections
IoT
Vertica 9
Security
Time series

The Kafka Convergence

Paige Roberts, Vertica Open Source Relations Manager
January 20, 2020

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?

Jim Knicely, Vertica Principal Solution Architect
January 14, 2020

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

Vertica Partners Are the Key to Your Success at BDC 2020

Jeremiah Morrow, Senior Product Marketing Manager – Partner Ecosystem
January 8, 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.

Tracking Santa’s Flight Plan

Mark Whalley, Corporate Systems Engineer
December 20, 2019

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