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

What’s New in Vertica 8.1?

Chana Zolty
April 17, 2017

Watch this video to learn what’s new in Vertica version 8.1. New features include: - flattened tables - supported platforms update - Management Console features - Kafka connectivity update - machine learning functions - rack locality - Geohash conversions - security upgrades - wide column data query improvement

What’s up with rejected data?

Chana Zolty
April 12, 2017

This blog post was authored by Kanti Mann. In a perfect world, any and all data you attempt to load into your database would seamlessly and accurately move from point A to point B. Unfortunately, this doesn’t always happen. Occasionally, data fails to load into its destination table, and you’ll probably want to know what...

Why auto-scaling analytical databases aren’t so magical

Soniya Shah, Information Developer
April 6, 2017

This blog post was authored by Steve Sarsfield. There is a new feature in analytical databases that seems to be all the rage, particular in cloud data warehouse - Autoscaling. Autoscaling’s promise is that if you have a particularly hard analytical workload, autoscaling will spin up new storage and compute to get the job done....

Subscribe For Email Updates

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

Sign-up

Understanding AT TIME ZONE

Soniya Shah, Information Developer
April 4, 2017

TIMESTAMPTZ AT TIME ZONE and TIMESTAMP AT TIME ZONE return date input in another time zone. How Vertica executes AT TIME ZONE varies, depending on whether the input is a TIMESTAMPTZ or TIMESTAMP. At first glance, this might be confusing. More about that later. First, let's review AT TIME ZONE syntax: { TIMESTAMPTZ | TIMESTAMP...
Three 3D arrows, different colors pointing in different directions

Create and Assign Roles

Phil Molea, Sr. Information Developer, Vertica
March 30, 2017

A role is a collection of privileges that can be granted to one or more users or roles. Assigning roles prevents you from having to manually grant sets of privileges for each individual user. For the most part, creating and assigning roles is fairly straightforward. However, the user to which roles are assigned needs to...

Filtering Data While Loading into Vertica

Sarah Lemaire, Manager, Vertica Documentation
March 22, 2017

Suppose you have a CSV file and you want to copy some, but not all, of its contents into a Vertica table. There are two ways you can to do this: • Use the SKIP keyword with COPY. • Use the head or tail Linux command. Let's see how this works. The Data Here's a...

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
Programmer

Vertica Machine Learning Series: Logistic Regression

Soniya Shah, Information Developer
March 16, 2017

This blog post is based on a white paper authored by Maurizio Felici. What is Logistic Regression? Logistic regression is a popular machine learning algorithm used for binary classification. Logistic regression labels a sample with one of two possible classes, given a set of predictors in the sample. Optionally, the output can be the probability...

DataGals Hosts an International Women

Soniya Shah, Information Developer
March 9, 2017

This blog post was authored by Soniya Shah. This week, the DataGals hosted an event in celebration of International Women’s Day. This year’s campaign asked supporters around the world to #BeBoldForChange to encourage a more inclusive, gender equal world. You can read more about the campaign and influencers on the International Women’s Day site. International...

Spark Summit East

Soniya Shah, Information Developer
March 8, 2017

This blog post was authored by Myles Collins. I recently went to the Spark Summit East to take the Spark training and get current on the technology that my group (Vertica Partner Engineering) is using more and more. Conveniently, it was held here in Boston. A few weeks after I registered, marketing decided to sponsor...

Using Vertica on IoT Data: Gap Filling and Interpolation for Incomplete Sensor Data

Soniya Shah, Information Developer
March 6, 2017

This post was originally authored by Marco Gessner and appeared on LinkedIn. It has been reposted here with his permission. This article explains the basic gap filling and interpolation functionality in Vertica. Vertica was designed for the fast processing and analysis of huge volumes of data and is well suited to IoT applications. One of...

Dynamic Row and Column Access Policies

Phil Molea, Sr. Information Developer, Vertica
March 1, 2017

The content of this blog post is based on an article authored by Maurizio Felici. The Vertica Analytic Database access policies act on columns and rows to provide extra security on data in your tables. You can create flexible access policies that limit which users can access certain data by applying the access policy to...
Database Server Room

Vertica Machine Learning Series: k-means

Soniya Shah, Information Developer
February 22, 2017

The content of this blog is based on a white paper that was authored by Maurizio Felici. What is k-means Clustering? K-means clustering is an unsupervised learning algorithm that clusters data into groups based on their similarity. Using k-means, you can find k clusters of data, represented by centroids. As the user, you select the...