Vertica Blog

Vertica Blog

flex tables

data lakehouse example

Going Beyond a Data Lakehouse

David Sprogis, Director of Product Management
December 15, 2021

The way things get named in this industry can be pretty odd.  A lot of people have been hearing noise about how cool a “Data Lakehouse” is since it combines the power of a data lake with the power of a data warehouse. When I think of a lakehouse, I think of a great place...

Vertica Unify 2021 – Day 2 keynote spotlights a noble cause

Mike Perrow, Senior Product Marketing Writer/Editor
July 21, 2021

At Vertica Unify 2021, the focus this week has been on the techniques and best practices around data analytics. Naturally. There’s a lot of technology to cover in this space, and we’re delighted to have so many of the best and brightest minds in virtual attendance, helping us deliver, explain, and demonstrate these things. And,...

Extracting Log Data into Vertica With Regex Parsing

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
October 5, 2020

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...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

2 – What Are the Benefits of Using Complex Data Types in SQL?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
December 19, 2019

Co-authored by James Clampffer, Deepak Majeti. In this second post in the Complex Data Types blog series, let’s look at some of the reasons complex types are used extensively in organized big data formats like ORC and Parquet. Be sure to read the first post in this series where we discussed the what complex data...

Vertica on the Road! Using Vertica to Prepare and Analyze Vehicle Telematics Data

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
December 17, 2019

Vehicles generate a lot of data from onboard electronics and there is increasing interest in monitoring vehicle handling to help assess insurance risk and premiums. At Vertica, we're working with a few auto manufacturers, so I built this demo to show a relatively simple example of data collection, aggregation and preparation, and analysis of the...
View from above of a sailing ship in the ocean with the sail full and the crew leaning to one side to balance

Announcing Vertica Version 9.3 – Ride the Winds of Change

Paige Roberts, Vertica Open Source Relations Manager
October 16, 2019

The winds of change have been blowing strong. This week, Vertica version 9.3 made its big splash. Vertica has a tendency to pack a lot of features even into minor releases, and this is not a minor release. Rather than dive deep, I’m going to skim the surface of the ocean of new features. Eon...
Cloud pattern in circuit board

Vertica Ranked #1 Cloud Data Warehouse

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
July 30, 2019

July has been quite an exciting month for Vertica. Our three keynote presenters are now confirmed for the Vertica Big Data Conference 2020 – Vertica founder and Turing Award winner Dr. Michael Stonebraker, kingpin of the famous MIT blackjack team Jeffrey Ma, and renowned analyst Ray Wang of Constellation Research. And, in addition to receiving...
Hand writing the text: Helpful Tips

Analyzing JSON Already Loaded into Vertica Regular Tables

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
July 22, 2019

Vertica flex tables allow you to query data in JSON format. But what if you've imported JSON objects into VARCHAR already? Here's how you can extract the JSON into flex tables without exporting and importing. Let's create a sample table with a JSON column to convert: Now let's create a flex table: Flex tables use...

Auditing Flex Tables Quick Tip

James Knicely, Vertica Field Chief Technologist
February 20, 2019

The AUDIT_FLEX function returns the estimated ROS size of __raw__ column in a Flex table, equivalent to the export size of the flex data in the audited objects. Note that the AUDIT function returns 0 for a Flex table if no columns in the Flex table have been materialized.
Child sleeping peacefully under a blue blanket labelled Vertica

Take Vertica and Call Me in the Morning

Joy King, VP Product & GTM Strategy, Vertica
February 4, 2019

Last night, at 1:37 am, I found myself awake and thinking about Vertica. To anyone who knows me, this should come as no surprise. I was thinking about how different Vertica is from so many other players in the market and I realized that we have for years proudly described Vertica as a full ANSI...
surprised data analyst

What You Never Knew About Vertica Could Surprise You

Paige Roberts, Vertica Open Source Relations Manager
December 17, 2018

I just started working on the Vertica team. As the “new guy,” my first few weeks of work have been largely about cramming as much Vertica information into my brain as possible in the shortest time possible. That’s my favorite part of working in the big data analysis world. You always have to keep learning....

Enter the Flex Zone –– An Exploration in Processing Twitter Data

Ben Vandiver
January 13, 2014

With our