Announcing Vertica Version 9.3 – Ride the Winds of Change

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

Announcing Vertica Eon 9.x Essentials Course

Herb Collins, Technical Consultant
November 13, 2019

We have just released a new instructor-led course: Vertica Eon 9.x Essentials Course code: VT120EON This course provides live instructions on Vertica Eon v9.3, accompanied by comprehensive hands-on labs. Running on a public cloud platform, Vertica Eon Essentials allows users to directly connect with the Vertica Eon database and the Management Console to interact with...

Cubes with binary ones and zeroes on them clustered together floating in blue space with light shining out

Complex Data Types in SQL 1 – What Are They?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
October 28, 2019

Co-authored by James Clampffer, Deepak Majeti. 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. We support some of those complex types now, and are dedicated to adding full support for all complex types in Vertica. It’s a...

Bullet train rendering with Vertica on side, and zooming effect with "Depot" sign behind

Vertica in Eon Mode Depot – Where Did You Go?

Joy King, VP, Vertica Product Management & Product Marketing
October 3, 2019

Separating compute from storage is such a hot topic these days. “Instance types” and “S3 Object Storage” are core to the language of the public clouds (unless you’re Azure, then substitute S3 with Blob but leave the Object Storage part). This next-generation architecture enables so many operational and economic advantages – workload isolation, elastic scaling,...

Tracking Raw Schema Size Over Time

Jim Knicely, Vertica Principal Solution Architect
September 25, 2019

There is no way to go back in time to see how large a schema was a day/month/year ago. But you can use the AUDIT function to get a “raw” size of a schema and track growth over time by storing the results from a daily audit. Using cron, you can run this daily. Helpful...

Introducing an Industry First – Vertica in Eon Mode for Pure Storage

Jeremiah Morrow, Senior Product Marketing Manager – Partner Ecosystem
September 17, 2019

This week at the Pure Accelerate conference, Vertica and Pure Storage of Vertica in Eon Mode for Pure Storage, the industry’s first and only analytical database solution with a separation of compute and storage architecture for on-premises analytic workloads. Why is this important to you? The rush to migrate analytic workloads to the cloud was,...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Vertica Big Data Conference Registration is Open!

Ben, Senior Product Marketing Manager
September 16, 2019

We’re excited to announce that for the next Vertica Big Data Conference (BDC), held March 30 – April 2, 2020, at the Encore Boston Harbor Hotel. Don’t miss out on the early bird pricing rate of $695 (a $300 savings), along with buy 3 get 1 free group discounts! What is the Big Data...

7 Critical Capabilities for Embedded Analytics

Ben, Senior Product Marketing Manager
September 12, 2019

Software and technology vendors serving a range of industries – from security to healthcare – are increasingly turning to embedded analytics as a way to deliver value-added services and applications to their customers. Enterprises that embrace embedded analytics are changing the dynamics of business in every vertical market. The most disruptive companies in these industries...

Focused young woman working at laptop in office

The Vertica Academy Is Open for Learning

Joy King, VP, Vertica Product Management & Product Marketing
September 9, 2019

One of the greatest impacts from digital transformation, both from a personal and professional point of view, is not just the democratization of data - a very popular topic here at Vertica! - but the democratization of knowledge. Today, we are excited to announce the new, a platform that offers self-paced, technical training and certifications...

Explore Popular Topics

DBadmin
SQL
VSQL
Best Practices
machine learning
Advanced Analytics
Cloud
Eon Mode
AWS
Vertica
Projections
Vertica 9
Security
Checklists
IoT

Interns hiking at Blue Hills Reservation, Milton, Mass.

Intern Spotlight: Becoming an Engineer

Deb Chatigny, Manager, Information Development
September 9, 2019

My name is Richard Xu and I am a sophomore at Harvard University, studying Computer Science. This summer, Vertica has taught me how to be an engineer. Starting a career as a freshman is challenging. I may have the technical know-how and coding abilities, but the freshman stigma loomed over me. At the career fair...

Photo of actual roadrunner running on a road showing yellow stripe in the middle

Have VSQL Beep Upon Command Completion

Jim Knicely, Vertica Principal Solution Architect
September 6, 2019

There are a lot of cool command line options available to VSQL. One of my favorites is the –b option which causes Vertica to “beep” when a command completes. This is very useful if you are running a very long sequence of SQL commands via a script. You can go off and do other things...

Easy Development Schema Cleanup (i.e., Have Vertica Drop a Bunch of Tables for You)

Jim Knicely, Vertica Principal Solution Architect
September 5, 2019

On a development database, I have a lot of tables in the PUBLIC schema having similar names starting with “test_”. I’d like to drop all of these tables quickly. To do that, I can have Vertica generate the DROP commands and then execute them for me! P.S. Be careful with this command! Make sure when...

Helpful Tips in blue text with magnifying glass

Investigate Data Collector Table Data Produced by Scrutinize

Jim Knicely, Vertica Principal Solution Architect
September 5, 2019

The diagnostics tool scrutinize collects a broad range of information from a Vertica cluster. Part of the output from scrutinize includes data collector table data. Once extracted, we can easily load the data from a data collector table file into a Vertica Flex Table for analysis! Let’s take a look at the data from the...

Machine learning robot studying equations and graphs

In-Database Machine Learning 2: Calculate a Correlation Matrix – A Data Exploration Post

Arash Jalel Zadeh Fard, Senior Software Engineer at Vertica
September 5, 2019

In the , we discussed some of the reasons why it makes sense to do your machine learning inside the database. This will be the first post where we discuss some of the steps involved in the in-database machine learning workflow. Generally, the first thing you need to do is explore your data. This can...

Construction site crane building a blue SQL 3D text.

Load Data Enclosed By and Embedded With Double Quotes

Jim Knicely, Vertica Principal Solution Architect
September 4, 2019

Loading string data that is enclosed in double quotes where the string also contains double quotes can be problematic. We could alter the data so that it includes an escape character prior to each embedded double quote, but maybe that’s not possible. Another solution would be to use a FILLER to load the data then...