Vertica Version 10 Launches Today!

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

Happy engineer with wide arms and graphs floating above him

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

Paige Roberts, Vertica Open Source Relations Manager
March 30, 2020

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

Mark Whalley, Corporate Systems Engineer
March 27, 2020

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

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

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

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

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

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

Explore Popular Topics

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

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

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.

Learn How Much Money Vertica Can Save Your Business

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

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

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