Vertica Blog

Constellation Research Report Finds Vertica 10 a Leading Choice

Posted September 14, 2020 by Mike Perrow, Senior Product Marketing Writer/Editor

Read More

Electronic medical record on digital smart device

Vertica in Good Health: Ingesting, Securing, and Analyzing Healthcare Data

Electronic Medical Records and new personal healthcare technology, particularly medical devices, generate a huge amount of data. Organizations including Cerner and Philips Healthcare rely on Vertica for . How can Vertica help you analyze this data? Vertica excels at data ingest and provides hundreds of built-in SQL and analytic functions with broad integration with programming...
Taking data analytics to the next level

Vertica 10 SP1 Takes Data Analytics to the Next Level

The first service pack for Vertica 10 brings even more incredible new features to the most flexible and scalable data analytics warehouse on the market.
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...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

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 ...
Larry Bird Monument - Photo by Eric Kilby WC

Practice Makes Perfect at BDC 2020

Larry Bird, Boston Celtics legend and NBA Hall of Famer, shot 500 free throws every morning before his first class in high school. But, he didn’t stop there. Larry was known to shoot 100 free throws after every NBA game. The result? The sharp-shooting forward from French Lick, Indiana led the NBA in free throw...
Brandeis University sign

Hands-on Class Makes Parallel Data Management Theories Concrete

Parallel data management in databases is a tough thing to learn when you’re a student. It can feel like another one of those esoteric theories, and it never quite sticks. Now, there’s a cool class at Brandeis University that brings those lofty theories down to earth, and gives students a real chance to see how...

Explore Popular Topics

Map with pins

Loading ZIP Code Boundaries from a Shapefile in Three Easy Steps!

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

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...
Helpful Tips text with hand and marker over data center background

Define a Vertica Flattened Table Column as Having Both DEFAULT and SET USING Constraints

Columns in a flattened table can query other tables with constraints DEFAULT and SET USING . Vertica executes DEFAULT queries only on new rows when they are added to the flattened table, through load operations such as INSERT and COPY. Thereafter, changes in the original data sources have no effect on the flattened table. Vertica...
Helpful Tips in blue text with magnifying glass

Viewing Parquet Export Events More Easily

The EXPORT TO PARQUET command exports a table, columns from a table, or query results to files in the Parquet format. When you run EXPORT TO PARQUET information about the files created during the export is stored in the Vertica log. It's no fun combing through a Vertica log looking for those particular records. Good...
Hand writing the text: Helpful Tips

Clearing the Screen in VSQL

Lots of old school folks use VSQL for administrative tasks. As you enter commands, eventually the command prompt will end up at the bottom left of the screen making it a little difficult to read any additional output from your commands. You can clear the screen and move the prompt back up to the top...
A cloud of data points with a businessman's hand holding it up on a black background

Vertica’s Eon Mode – New Architecture for Flexibility, Performance, and Savings

Vertica was born in the age of the enterprise data warehouse (EDW) appliance, in 2005. At the time, the EDW appliance was a great idea – a relatively simple bundle of hardware and software. You plugged it in, and it worked. This single box came with a lot of services, too. But it also came...