Vertica named by InfoWorld as one of 8 databases supporting in-database machine learning

A Feb. 17 article in InfoWorld names Vertica as one of eight analytical platforms that offer in-database machine learning “right where your data resides.” Authored by contributing editor and reviewer Martin Heller, the article validates two of Vertica’s long-held principles: flexibility in ML modeling and training, and the ability to analyze data without transmitting it...

Technology Partnership with Jaguar Racing to Deliver Vertica Analytics at Jaguar Speed

Jaguar Racing announced that it has partnered with Micro Focus, ahead of season seven of the ABB FIA Formula E World Championship. Joining as the team’s official digital transformation, business resiliency, and analytics partner, Micro Focus will provide support to Jaguar Racing’s push for more points, podiums, and wins on the racetrack. Vertica plays a...

Vertica outperforms competing cloud analytical platforms in third-party benchmark study

Vertica proven to be faster, more affordable, and more scalable in terms of concurrency in third-party benchmark over Amazon Redshift and an unnamed data cloud platform Choosing a cloud-based big data analytics platform for your organization’s analytical needs is seldom an easy task, and it can’t be the first step on your big data journey....

The Unified Analytics Warehouse Reaches your Data, Wherever it Lives

You may have noticed something interesting about the next generation enterprise data warehouse (EDW) vendors. They’re all pushing to ensure all data moves to the same place for analytics purposes, which of course means their particular data store. This is very worrisome to me because it involves two levels of lock in: 1) underlying infrastructure...
The Earth

“awk” sed Grep, “whoami?”. Time CC if bash makes head or tail and sort > plain.txt and make us API

Things to do whilst confined to barracks due to COVID-19 For those who know me well, having worked in IT for four decades, will know that I can be a bit of a Luddite when it comes to new-fangled technology. Give me a character-based, green-screen PuTTY application over any pointy-clicky interface.  Let me use vsql...

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

Unified Data Analytics Warehouse

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

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

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,...
Analytics human interest stories

Making a Difference with Analytics – Inspiring Human Interest Stories

I wake up before the sun rises, head to my home office, parse through the emails that have flowed in overnight, and look at my calendar to prepare for my day. I fill daylight hours with meetings, research, more meetings, writing … and more meetings. Sometimes, it is exhausting and even a little overwhelming. So,...

Explore Popular Topics

Vertica and Attunity Replicate Change Data Capture

Attunity Replicate is a software solution that loads data from multiple sources and accelerates data integration for analytics, replication, streaming, and synchronizing, on-premises and in the cloud. Attunity Replicate and Vertica integration exists for Vertica as a Target. This integration enables moving large volumes of data from multiple sources into the Vertica database. It leverages...

Award Winning – Vertica Proves It

June has been quite a month of industry recognition for Vertica and its customers. Fresh off earning top leadership position in GigaOm’s Radar Report for Evaluating Data Warehouse Platforms, Vertica has once again been named to this year’s DBTA 100 Companies that Matter Most in Data, a special list that salutes today’s top companies in...
A man and woman looking under the hood

Tune in for Monthly Vertica Tune-Ups

Our Under the Hood Webcast series builds on the engineering-led sessions that our product and R&D teams deliver at our annual Vertica Big Data Conference. You can tune in nearly every month and get a deep dive of Vertica features and releases through this popular series. Last month, Vertica R&D covered one of our most...

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

I was asked some time ago whether Vertica was just another SQL database.  I could have just said “Yes” and left it at that. However, my passion for Vertica would never have allowed me to leave it at that.  Rewording a famous UK High Street retailer’s tag-line, “This is not just any SQL database, this...
Quick Tip - blue button

Copy a Table with an Identity to a Table with an Identity on the Same Database Keeping the Identities in Sync

An IDENTITY associates a table column with a sequence. This sequence automatically increments the column value as new rows are added. There are some noteable restrictions on IDENTITY columns: You cannot INSERT values manually into an IDENTITY column You cannot UPDATE the values of an IDENTITY column once they has been populated via the sequence...
Visual Storytelling

VSQL, Visual Storytelling through Query Language

This tip expands on my earlier post: “Pure Vertica SQL Graph Flavors” Visual story telling has not just the ability to capture attention, it make things simple to understand. Consider the following to boost your query result set readability. What is the visual correlation between CPU utilization and Canary Queries elapsed time?      ...