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

Embedded Vertica speeds EOITEK’s growth in AIOps

The phrase “digital transformation” has quickly evolved from a buzz term to an apt description for innovative changes evident today. More businesses are implementing the technical tactics that are actually bringing new business models to fruition, and that was the original promise: Doing things with digital technology that simply weren’t possible before. That was the...
Vertica wishes you a Happy Holidays

New VerticaPy Features Added – Just in Time for the Holidays

The team behind wishes you happy holidays and a happy new year from Boston, and from Grenoble in the French Alps! Make 2021 your year to operationalize .    VerticaPy is a Python library that exposes scikit-like functionality for conducting data science projects in your Vertica database. With in-database machine learning, data preparation and exploration,...
Vertica + Scality

Vertica in Eon Mode Now Supports Scality for Even Greater Choice

We are pleased to announce the general availability of Vertica in Eon Mode for Scality RING S3 object storage on the HPE Apollo 4000 platform
Cloud analytics

Vertica now available as a managed service from Full 360

The Vertica partner ecosystem is steadily growing, with a who provide help with implementation, professional services, and value added reselling. This means that if you’re new to Vertica, or working to create your own data platform for the first time, you’ll find the right expertise within our ecosystem. Now, we’re happy to report that Full...

DX Radio Episode 3: Climate Corporation and Digital Agriculture

I have the honor of hosting the latest episode of DX Radio. It features The Climate Corporation’s Daniel McCaffrey, Vice president of Data and Analytics, and Erich Hochmuth, Big Data Architect Engineer, as they explore the digital transformation of farming.

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

List the Missing Dates in a Date Series

The TIMESERIES clause in Vertica makes it easy to list all of the gap days (that is, those that are missing) from a series of dates. Say I have this simple date series: As you can see, there are several dates missing from the series (2020-10-30, 2020-11-02, 2020-11-03 and 2020-11-04). I can list these absent...
Compass rose with true north pointing to "Helpful Tips" text

Getting Every Nth Row from a Table (Enhanced)

In a previous Vertica Quick Tip we learned how to query every Nth row from a table when we had a unique ID column having sequential values (that is, from a sequence). See, What if we don’t have a key like that in our table? No problem thanks to the ROW_NUMBER() Analytic Function! Say I...

Extracting Log Data into Vertica With Regex Parsing

Formatted text such as system logs hold a huge amount of actionable data if you can extract and discover the content. If there is a pattern to the lines, then you can build a Vertica regex parser to extract fields and contents into Vertica for query and analysis at scale. Vertica’s regex parser uses Perl-like...

Explore Popular Topics

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.
A cloud of data points with a businessman's hand holding it up on a black background

Prepare for Your Multicloud Future Today

You only have to read as far as the subtitle of the to understand that more and more organizations are adopting a multi-cloud strategy – cloud spend is rising as organizations adopt multi-cloud strategies and put more workloads and data in the cloud. This ninth annual report, based on 750 global cloud decision-makers, revealed that...
Risk Analysis

How security risk is making sense to the corner office

As Big Data continues to get bigger, data volume is only one aspect of the expansion. Just as critical for CDOs and business leaders to get a handle on are the growing sources of data. Data sources are expanding, and becoming important as businesses look to capture data from every conceivable end-point – from IoT...