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...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

Complex Data Types in SQL 2 – Benefits of SQL Support

Co-authored by James Clampffer, Deepak Majeti. In this second post in the blog series, let’s look at some of the reasons complex types are used extensively in organized big data formats like ORC and Parquet. Be sure to read the in this series where we discussed the , and explored the various complex types in...

Vertica on the Road! Using Vertica to Prepare and Analyze Vehicle Telematics Data

Vehicles generate a lot of data from onboard electronics and there is increasing interest in monitoring vehicle handling to help assess insurance risk and premiums. At Vertica, we're working with a few auto manufacturers, so I built this demo to show a relatively simple example of data collection, aggregation and preparation, and analysis of the...
TOP 5 - with stars on white background - 3D

Top 5 Reasons Why You Win Big with Data at the Vertica Big Data Conference 2020

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

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Tips and Tricks Orange Button

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

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

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

Announcing Vertica 9.3 Instructor-Led Training Courses

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

Explore Popular Topics

Are Your Columns too Wide?

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

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

Checking and Improving Column Compression and Encoding

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?

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...
Happy dog running in grass

Vertica Big Data Conference 2020 – Are You Excited Yet?

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 logos

Vertica and Amazon – Better Together, for Years

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