Unified Data Analytics Warehouse

How can you get the value out of Hadoop that you were promised?

Since Hadoop’s initial release 14 years ago, untold volumes of data have been stored in HDFS (Hadoop Distributed File System). Spread across a virtual landscape of data-inspired organizations, those data lakes are wide, and deep. Companies have made tremendous investments in Hadoop over the years, and data continues to pour into their data lakes. You...
Community Edition

Join the Powerful Vertica Big Data Community Open House with Free Community Edition

What comes to mind when you hear the word “community”? A village, a neighborhood? Maybe sidewalks where people say hello, where they have a few things in common – perhaps an identity, sometimes a sense of pride, definitely a sense of belonging. We’re social creatures, so being part of a community means sharing experiences, too,...
Who's awesome? BDC is awesome!

Top 10 Highlights from the Virtual Vertica BDC 2020

While it was a difficult decision to take the virtual, the registration numbers, session reviews, and overall feedback confirmed that this was our most successful BDC ever! If you did not have a chance to or missed any of the sessions, no worries. All sessions were recorded and PDFs of the presentations are available ....
Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

There’s , on the first day of the – a major new version of Vertica blasts off! Vertica version 10 soars straight into the greatest deployment flexibility of any analytical data warehouse on the market. This fast and extremely scalable platform gives you more power than ever to get industry-changing analytics, including even more advanced...
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....

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Helpful Tips message on post-it note

Export to 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, 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!
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...
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...

Explore Popular Topics

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