Vertica Blog

Vertica Blog

Best Practices

Tips in bright neon red letters on a dark background with touchscreens.

High Availability in an EON Mode Database with Read-Only Mode

This blog is authored by Sruthi Anumula In Eon Mode, there are two major requirements for high availability: maintaining quorum and shard coverage. If either of them is lost, the whole cluster goes down. Before going into details, let us understand what quorum and shard coverage mean. Quorum: In Eon Mode, more than half of...

How to Quickly Install Vertica on Large Clusters

This quick tip was provided by Sruthi Anumula. 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....
SQL Query Optimization

Improving COUNT DISTINCT Performance with Approximate Functions

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

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?

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

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

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

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

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

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

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

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