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

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, Sr Director, Vertica Product Marketing at 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...

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

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

3D render of a binary data stream flowing into a network server surrounded by clouds

Is Your Future Cloudy? This Buyer’s Guide Offers Clarity

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
November 25, 2019

When I started at Vertica about seven years ago, I was met by anxious sales people warning me that (HDFS, specifically) was going to completely replace the , as we knew it. And we should be very concerned. That was 2012, a year that I first encountered the lovable elephant and met swarms of Hadoop...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

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

Are Your Columns too Wide?

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
November 14, 2019

This tip expands on the earlier post on encoding and compression at When you have millions to billions of rows, data type becomes a bit more important: even an extra 10 bytes per row across a huge data set will impact storage or performance (or both!). When I created the big_fact_table, I included some VARCHAR...

Announcing Vertica Eon 9.x Essentials Course

Herb Collins, Technical Consultant
November 13, 2019

We have just released a new instructor-led course: Vertica Eon 9.x Essentials Course code: VT120EON This course provides live instructions on Vertica Eon v9.3, accompanied by comprehensive hands-on labs. Running on a public cloud platform, Vertica Eon Essentials allows users to directly connect with the Vertica Eon database and the Management Console to interact with...

Explore Popular Topics

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

Checking and Improving Column Compression and Encoding

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
November 7, 2019

When working with terabytes of data, storage and transfer become major time and cost sinks. Vertica can help minimize storage cost and transfer time with column compression and encoding. How can we identify Vertica tables that might benefit from compression? Information about column size and current compression is stored across column_storage and projection_columns table. The...

Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

Complex Data Types in SQL 1 – What Are They?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
October 28, 2019

Co-authored by James Clampffer, Deepak Majeti. A lot of projects require querying ORC or Parquet files, or other data that may have internal types that are a bit more complex than usual. We support some of those complex types now, and are dedicated to adding full support for all complex types in Vertica. It’s a...

Vertica Big Data Conference 2020 – Are You Excited Yet?

Joy King, VP, Vertica Product Management & Product Marketing
October 25, 2019

The Vertica Big Data Conference (BDC) clock is ticking and my excitement is growing by the minute! I want to make sure that our Vertica community is up to date on the latest news, especially some of the General Session speakers and Breakout tracks. And let’s not forget one of the most special components of...

Vertica and Amazon – Better Together, for Years

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
October 23, 2019

The year was 2012. Marvel’s The Avengers hit the box office. Facebook went public. NASA's Curiosity rover landed on the surface of Mars. And, the Vertica AMI (Amazon Machine Image) made its debut on , enabling data-driven organizations to easily deploy Vertica on the Amazon cloud and start accelerating their analytics. Running Vertica on Amazon...

Construction site crane building a blue SQL 3D text.

Get the Row Count from an Outer Table Join

Jim Knicely, Vertica Principal Solution Architect
October 22, 2019

Aggregate functions summarize data over groups of rows from a query result set. When using an aggregate function like COUNT with an "*" or "1" parameter value, you may get a different result when the query implements a LEFT join verses an INNER join. If you want a row count of just the rows from...

DIRECT Is Now the Default Load Type

Jim Knicely, Vertica Principal Solution Architect
October 19, 2019

Write Optimized Store (WOS) is a memory-resident data structure for short-term data storage while Read Optimized Store (ROS) is a highly optimized, read-oriented, disk storage structure, organized by projection. Prior to Vertica 9.3, by default, Vertica initially loads data into WOS. For databases created in version 9.3 and later, Vertica now uses a default load...