Vertica Blog

Vertica Blog

Best Practices

How to Quickly Install Vertica on Large Clusters

Sruthi Anumula, Senior Database Support Engineer
December 19, 2022

Vertica 12.0.2 introduces a new feature that allows you to install Vertica in parallel on all hosts rather than one at a time as in earlier releases. This reduces the installation time in large clusters. To use this feature, run the --parallel-no-prompts flag with the install_vertica command. This flag can be used only when passwordless...
SQL Query Optimization

Improving COUNT DISTINCT Performance with Approximate Functions

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
November 16, 2022

A common analytic use case is to find the number of distinct items in a data set. Vertica performs well at solving COUNT DISTINCT in a few ways. Since Vertica stores all data in columns, it is possible to optimize for COUNT DISTINCT by building a projection that is tuned for this use case. Vertica...

When the typewriter is broken: Vertica’s Event-Based Windows to the rescue

Mark Whalley, Manager, Vertica Education
July 18, 2022

Those of you who read my blog post “Take nothing but memories. Leave nothing but footprints” may recall my passion for using Raspberry Pi computers to capture IoT data from aeroplane transponders and GPS satellites, then feeding that streaming data into Apache Kafka and to integrate it with Vertica and perform near real-time analytics and...

What’s needed for a happy software dev team in data analytics?

Mike Perrow, Senior Product Marketing Writer/Editor
July 6, 2022

For an organization to excel at data analytics, the IT team needs to coordinate a number of different disciplines and personnel with experience in those disciplines. This usually includes data analysts, data engineers, and, increasingly, data scientists. The data engineering discipline is sometimes thought of as the plumbing that, like pipes in a house, delivers...

VerticaPy Unify 2022 Sessions

Badr Ouali, Head of Data Science
June 21, 2022

Vertica Unify 2022 is a great time to learn about Vertica, its new features, and best practices. To complement the many great presentations at Vertica Unify 2022 both in Boston and Paris, I’m very excited to present two sessions: one on VerticaPy best practices, and another general session on VerticaPy and its features. VerticaPy is...

Customers in the Spotlight at Vertica Unify ’22

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
May 31, 2022

It’s hard to believe that it has been almost a decade since we held our inaugural Vertica Big Data Conference, back in 2013. At that time, our goal was to hold an annual user conference with a few simple yet guiding principles – no sales or marketing pitches, hold the event in Boston, and line...

Vertica Wins the Gold in Bloor Market Update

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
May 3, 2022

Know Your Options for Analytical Databases and Data Warehouses For CDOs and CIOs, there have never been more options to choose from when deciding where to run their analytical workloads. Analytical databases and data warehouses are two popular options – with the data warehouse market experiencing 10% annual growth and many new entrants* – particularly...

New O’Reilly Book: Accelerate Machine Learning with a Unified Analytics Architecture

Paige Roberts, Vertica Open Source Relations Manager
February 17, 2022

Every company I’ve ever encountered needs business intelligence (BI). Increasingly, in multiple industries, more and more also need machine learning (ML) or artificial intelligence (AI) to stay competitive or gain an edge. Eventually, it should be as easy for an organization to put an ML model to work as it is to put a new...

Every second counts in Jaguar Racing Formula E

Mark Whalley, Manager, Vertica Education
February 15, 2022

Races can be won or lost with fractions of seconds separating first, second, and third. Many factors determine who stands on the podium, awarded with points and champagne, and who returns to the pit on a recovery truck. One factor that plays a critical role in helping Sam or Mitch win that race is optimal...

Vertica Stories from China: Top 3 contest winners showcase innovation

Elyzabeth Eng
February 1, 2022

This past December and January, the Vertica team for the Asia-Pacific region conducted a story contest for Chinese-speaking Vertica customers using creative solutions to data analytics requirements. In addition to reaching out and learning more about Vertica customers in the region, we wanted to gather use case details and share them with the worldwide Vertica...

New EMEA business survey reveals challenges in the move to predictive analytics

Sabrina Corazza
January 13, 2022

To discover today’s cloud and data analytics trends across Europe, the Middle East, and Africa (EMEA), Vertica recently surveyed 240 data experts from industry-leading organizations in these regions. We wanted to learn how businesses are leveraging data analytics and what challenges they are facing when implementing predictive analytics, artificial intelligence, and machine learning capabilities in...
Disk usage, traffic, and other usage concerns

All-new Vertica Advisor report designed to improve health of customers’ analytics

Amy Miller, VP for Customer Success
December 10, 2021

As Vertica’s Vice President for Customer Success, I wanted to let you know that the Vertica Advisor report has been recently updated to help Vertica customers understand their database and usage, and to get the most from their analytical investments. If you are not familiar with the Vertica Advisor report, it is a Database Health...