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...
Helpful Tips message on post-it note

Eonclose CSV File With Fields Enclosed by Quotes

It's easy to export table data to a CSV file using vsql. Although there isn't a vsql option to enclose each output field in quotes, but you can accomplish that task with the Linux sed command. Once the formatting looks good, you can redirect the output to your CSV file: Helpful Links: Have fun!
WOS ROS differences

Write Optimized Store (WOS) Deprecation – What You Need to Know

In Vertica 10.0, WOS (Write Optimized Store) will be deprecated. In this blog, we introduce the historical justification for WOS and its purpose, why we believe that it's no longer needed, and our justification for deprecating it. We'll go over the data and the testing we performed that gives us the confidence to ensure that...

Uber, The Trade Desk, and Other Exciting Presenters at Virtual Vertica BDC 2020

Ever wonder how Uber, the world’s largest ride-hailing service, manages communications and billing for hundreds of thousands of inquiries and rides per day? Or how ad-tech companies like The Trade Desk process those ad bidding wars in milliseconds, the ones that end with a display ad on your screen that’s eerily relevant to your web...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Focused young woman working at laptop in office

New hands-on training at Vertica Academy takes users deep into Vertica Essentials

Since was launched in September 2019, this versatile online training portal has acquired more than 1,500 registered users (as of beginning of March), and that number is growing daily. Users are finding answers to tough questions that arise as they explore the complex world of big data analytics. They’re finding self-paced courses, webinars and certifications,...
BDC 2020 Virtual Conference

Vertica Big Data Conference 2020 is Going Virtual

The updated guidelines around the Coronoavirus (COVID-19) have caused the to be postponed – from Mobile World Congress to HIMSS to even SXSW, which had a run of 34 consecutive years. Over the last few weeks, a handful of our customer speakers expressed their disappointment in learning that corporate travel restrictions would prevent them from...
Team Touchdown with Vertica

Fill the Gaps on Your Team with BDC Sponsors

Jeff Healey’s got me thinking about analytics in sports. When I was in graduate school, I attended a sports analytics conference sponsored by MIT. As you may know, Major League Baseball has compiled dozens of statistics over the years, and at that time was adding new ones that had never been tracked before. Analytics had...

Explore Popular Topics

Scale to the Moon - 7 petabytes

How Vertica uses limitless big data analytics to blow past small-scale vendors

As time moves on, so does data.  What was once big is now small, and what was once considered fast is now not even good enough. Ten years ago, Vertica found its place in the market with New Economy companies who were not just disrupting traditional industries but creating new ones.  Social media exploded, wearables...
Flight Tracking

Pennard, We Have a Problem – Troubleshooting Flight Tracking with the Grafana Plugin for Vertica

With Vertica’s Management Console, I have everything I need at my fingertips to manage and monitor my Vertica clusters and databases.  Whether that be investigating query performance issues, checking on the health of the cluster’s nodes, running the Database Designer or marveling at the volume of data being ingested by the Vertica Scheduler from a...
Decisions Decisions

The Vertica Big Data Conference Choice Challenge

Over the years, we’ve had remarkable feedback about the . (#VerticaBDC)  How does it get better than this?  And just to be clear, we know the three people who said “no,” but that’s a story for another day. However, I cannot lie.  We have received consistent feedback about one problem that virtually all attendees face...
Global Partitions

Optimizing Vertica Data With Partitions

How do partitions affect overall Vertica operations? Let’s look at a snapshot of the Flight Data Tracker dataset and compare performance ...