Vertica Blog

Perfect Vision 20/20 – Vertica’s 20 coolest features to see in 2020

Posted June 4, 2020 by Mark Whalley, Corporate Systems Engineer

Read More

Unified Data Analytics Warehouse

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

Mike Perrow, Senior Product Marketing Writer/Editor
June 29, 2020

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

Mike Perrow, Senior Product Marketing Writer/Editor
June 25, 2020

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

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
April 14, 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!

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

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!

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

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

Jim Knicely, Vertica Field Chief Technologist
March 29, 2020

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

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...
WOS ROS differences

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

Sumeet Keswani, Vertica Product Technology Engineer
March 23, 2020

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

DBadmin
SQL
Best Practices
VSQL
machine learning
Advanced Analytics
Cloud
Eon Mode
Vertica
AWS
Projections
Hadoop
IoT
Analytics
Partner Integrations

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

Mike Perrow, Senior Product Marketing Writer/Editor
March 16, 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

Mike Perrow, Senior Product Marketing Writer/Editor
March 12, 2020

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

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
March 9, 2020

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

Jeremiah Morrow, Senior Product Marketing Manager – Partner Ecosystem
March 4, 2020

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

Joy King, VP, Vertica Product Management & Product Marketing
March 2, 2020

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

Mark Whalley, Corporate Systems Engineer
February 26, 2020

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