Vertica Blog

The Unified Analytics Warehouse Reaches your Data, Wherever it Lives

Posted July 23, 2020 by Joy King, VP, Vertica Product Management & Product Marketing

Read More

The Earth

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

Mark Whalley, Corporate Systems Engineer
July 13, 2020

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...
Unified Data Analytics Warehouse

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

Mike Perrow, Senior Product Marketing Writer/Editor
June 29, 2020

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

Mike Perrow, Senior Product Marketing Writer/Editor
June 25, 2020

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

Joy King, VP, Vertica Product Management & Product Marketing
June 18, 2020

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

Vertica and Attunity Replicate Change Data Capture

Amrita Akshay, Information Developer
June 15, 2020

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

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Award Winning – Vertica Proves It

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
June 12, 2020

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

Tune in for Monthly Vertica Tune-Ups

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
June 9, 2020

Our Under the Hood Webcast series builds on the engineering-led sessions that our product and R&D teams deliver at our annual . 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 popular topics these...

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

Mark Whalley, Corporate Systems Engineer
June 4, 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...

Explore Popular Topics

DBadmin
SQL
Best Practices
VSQL
machine learning
Advanced Analytics
Cloud
Eon Mode
Vertica
AWS
Analytics
Projections
Hadoop
IoT
Time series
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

Jim Knicely, Vertica Field Chief Technologist
May 25, 2020

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 with SQL

VSQL, Visual Storytelling through Query Language

Moshe Goldberg, Vertica System Engineer
May 21, 2020

This tip expands on my earlier post: “” 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?

Tips and Techniques for Vertica Integration with Denodo

Amrita Akshay, Information Developer
May 12, 2020

Denodo is a data federation tool that integrates data from various data sources including enterprise, big data, cloud, and real-time data services. It enables you to quickly and easily access data through reports, dashboards, mobile, and web applications for analytical and operational use cases. Denodo already has an integration with Vertica. It leverages Vertica’s query...

Let Business Intelligence and Data Science Coexist!

Mike Perrow, Senior Product Marketing Writer/Editor
May 11, 2020

Business intelligence and data science frequently compete for resources, and BI got there first. Vertica in Eon Mode subclusters can help them coexist.