Vertica Blog

Vertica Blog

Hadoop

OpenText Vertica 23.3

OpenText Vertica 23.3 – the Smarter Data Lakehouse

The latest release of the Vertica analytical database, now OpenTextTM VerticaTM  includes a lot of features that Vertica customers have been eagerly awaiting like: Resharding the database as needed Rollback snapshots that capture a moment in time without a whole other data copy Workload routing so you can automate directing specific queries to just the right...
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,...
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...
Heavy rocket blasting above the clouds

Vertica Version 10 Launches Today!

There’s big news today, on the first day of the Virtual Vertica Big Data Conference 2020 – a major new version of Vertica blasts off! Vertica version 10 soars straight into the greatest deployment flexibility of any analytical data warehouse on the market. This fast and extremely scalable platform gives you more power than ever...
Larry Bird Monument - Photo by Eric Kilby WC

Practice Makes Perfect at BDC 2020

Larry Bird, Boston Celtics legend and NBA Hall of Famer, shot 500 free throws every morning before his first class in high school. But, he didn’t stop there. Larry was known to shoot 100 free throws after every NBA game. The result? The sharp-shooting forward from French Lick, Indiana led the NBA in free throw...
Helpful Tips in blue text with magnifying glass

Viewing Parquet Export Events More Easily

The EXPORT TO PARQUET command exports a table, columns from a table, or query results to files in the Parquet format. When you run EXPORT TO PARQUET information about the files created during the export is stored in the Vertica log. It's no fun combing through a Vertica log looking for those particular records. Good...
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?

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...
3D render of a binary data stream flowing into a network server surrounded by clouds

Is Your Future Cloudy? This Buyer’s Guide Offers Clarity

When I started at Vertica about seven years ago, I was met by anxious sales people warning me that Hadoop (HDFS, specifically) was going to completely replace the enterprise data warehouse (EDW), as we knew it. And we should be very concerned. That was 2012, a year that I first encountered the lovable elephant and...
Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

1 – What are Complex Data Types?

Co-authored by James Clampffer, Deepak Majeti. - First in a series A lot of projects require querying ORC or Parquet files, or other data that may have internal types that are a bit more complex than usual. It’s a little hard to explain what we mean when we say, “complex.” So, this is the first in...
Cloud pattern in circuit board

Vertica Ranked #1 Cloud Data Warehouse

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...
surprised data analyst

What You Never Knew About Vertica Could Surprise You

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