Vertica Blog

OpenText Vertica 23.3 – the Smarter Data Lakehouse

Posted July 31, 2023 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Unveiling the Most Recent Version of the Vertica Grafana Data Source Plugin

Amrita Akshay, Information Developer
October 12, 2023

With over 380K downloads, the Vertica Grafana Data Source plugin just got an upgrade! The plugin was migrated from the deprecated older Grafana toolkit to align with Grafana's new Create-Plugin tool. This accelerates the plugin development with their modern build set up that requires no additional configuration. Additionally, the Vertica SQL Go driver received an...
Quick Tip on a blue enter key on a keyboard

Setting Session Authorization to Troubleshoot

Sruthi Anumula, Senior Database Support Engineer
September 29, 2023

There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...
SQL

Quick Tip: WITH Clause Recursion

James Knicely, Vertica Field Chief Technologist
June 11, 2021

Starting with version 10.1.x, Vertica supports recursive queries. These are incredibly useful in modeling and working with self-referential hierarchical data. Let's take a look at a natural instance of this form of data: the manager-subordinate relationship. The following table contains employees (EMP_NAME), their IDs (EMP_ID), and the IDs of their managers (EMP_MGR_ID). For example, the...
Vintage businessman concept wearing futuristic helmet at office

Quick Tip: Combine SQL and vsql Meta-commands on the vsql Command Line

James Knicely, Vertica Field Chief Technologist
June 10, 2021

When using vsql, the -c (--command) flag lets you pass a single statement to vsql as a string and then exits. Examples: While you can't combine a SQL statement with a vsql meta-command... ...You can use echo to combine and pipe SQL statements and vsql meta-functions to vsql! Have Fun!

EMA Awards Vertica as Top Vendor for Hyperperformance with Multi-Structured Data in Radar Report on Unified Analytics Warehouses

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
June 4, 2021

If you could describe in just one word what Vertica provides better than any other unified analytics platform on the market, what would that word be? Read any of our case studies, watch any of our Data Disruptor Webcasts, or attend Vertica Unify ’21, and, chances are, you’ll agree that that one word is performance....

Subscribe For Email Updates

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

Sign-up

Kubernetes StatefulSets Makes Containerization of Vertica a Piece of Cake

Paige Roberts, Vertica Open Source Relations Manager
June 2, 2021

Containerization is an idea that seems tasty and wonderful at first. Automated deployment on any platform is a particularly enticing advantage, especially for Vertica, a database with infrastructure freedom as a core principle. Fast deployment without human intervention makes containers incredibly useful, especially in environments that require dynamic scaling. And containers are small, quick to...

New Forrester Total Economic Impact Study: Vertica customers achieve big results

Mike Perrow, Senior Product Marketing Writer/Editor
June 1, 2021

Predictive analytics is becoming an imperative for nearly every organization that hopes to increase market share. Modern data analytics techniques provide insights into where a business is heading, based partly on where it has been, and on the clear trend lines that point to where the business is going. So, if you’re an entrepreneur, or...
Business card that says Expert Tips,

Quick Tip: Create User-Defined Inverse Hyperbolic Functions

James Knicely, Vertica Field Chief Technologist
May 28, 2021

Vertica includes a ton of built-in mathematical functions to help you on your analytic journey, and creating new ones is quick and easy. Let's create the inverse hyperbolic functions: ACOSH - To compute the inverse (arc) hyperbolic cosine of its argument. ASINH - To compute the inverse (arc) hyperbolic sine of its argument. ATANH -...

Explore Popular Topics

SQL
DBadmin
Advanced Analytics
machine learning
Best Practices
Cloud
VSQL
Eon Mode
Analytics
Partner Integrations
Vertica
Open Source
AWS
IoT
Time series
Tips and Tricks Orange Button

Quick Tip: Create “Super Wide” Tables

James Knicely, Vertica Field Chief Technologist
May 27, 2021

Starting in Vertica 10.1.0, you can go super wide with up to 9,800 column definitions in a table! Prior to Vertica 10.1.x, tables were limited to 1,600 columns. Example Creating a table with 9,800 columns: Hint: Try to avoid running a SELECT * FROM … a table with 9,800 columns and a trillion+ rows 😊...
Hand writing the text: Helpful Tips

Quick Tip: Use a “Seed” Table to Populate a Table with Random Values

James Knicely, Vertica Field Chief Technologist
May 26, 2021

Oftentimes, I need to do some testing with randomly generated data. For instance, if I need to insert a million rows I used to cross join several system tables with one another in an INSERT statement. Method 1 (bad): CROSS JOIN Suppose we need a table full of many random UUIDs. We could do this...
Helpful Tips message on post-it note

Quick Tip: EXPORT TO PARQUET Compression with GZIP, Brotli, and ZSTD

James Knicely, Vertica Field Chief Technologist
May 25, 2021

EXPORT TO PARQUET exports a table, columns from a table, or query results to files in the Parquet format. These Parquet files use Snappy compression by default. Starting in Vertica 10.1.1, EXPORT TO PARQUET supports the GZIP, Brotli, and ZSTD compression types! Let’s see how these compression types compare in disk usage: Snappy compression: GZIP...

Join us in the Vertica Unify Developer Lounge: An interview with Vertica’s CTO Chuck Bear

Joy King, VP Product & GTM Strategy, Vertica
May 10, 2021

Every Vertica conference provides users and big data enthusiasts an opportunity to network with their peers in data analytics. But for attendees to find the exact Vertica engineer for questions and answers, there’s nothing like the popular Developer Lounge, which returns this year at Vertica Unify 2021. It’s the place for Vertica users to meet...

Vertica 10.1.1 Goes Beyond Analytics with Support for Azure Cloud, Kubernetes, and Containers

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
April 30, 2021

With each release of Vertica, you can always count on major enhancements and features to help you address each step of the predictive analytics process with even more analytical functions and end-to-end machine learning capabilities. While Vertica 10.1.1 includes support for the latest version of PMML, 4.4, some useful new analytical functions, and a new...

Be inspired by the best – DataGals Panel at Vertica Unify 2021

Joy King, VP Product & GTM Strategy, Vertica
April 27, 2021

Over the years, I’ve had the honor to work with a variety of women who have a passion for software development, product management, data science, and analytics. These are all very technical career paths, and as women, we know we’ll be in the minority, often the only woman in the room or on the team....