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

Using Vertica on Azure

Chris Daly
February 21, 2017

A lot of customers are starting to explore the idea of reducing infrastructure related costs of their enterprise solutions by migrating them to publicly hosted cloud based environments. With that in mind I am very pleased to announce the official support of Vertica running in the Microsoft Azure cloud environment. This latest step in the...

Using the Vertica on Azure Free Trial

Chris Daly
February 15, 2017

In August of last year, we announced support for Vertica in the Microsoft Azure Cloud environment. This includes a fully automated cluster deployment from the Azure Marketplace (which can be found here) and also includes our free Community Edition license. Microsoft, like many other public Cloud providers, offers a free trial subscription for users that...

Subscribe For Email Updates

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

Sign-up

Machine Learning Series: Linear Regression

Soniya Shah, Information Developer
February 13, 2017

The content of this blog is based on a white paper that was authored by Maurizio Felici. This blog post is just one in a series of blog posts about the machine learning algorithms in Vertica. Stay tuned for more! What is Linear Regression? Let’s start with the basics. Linear regression is one of the...

Patented: A Look into Kahlil Oppenheimer

Soniya Shah, Information Developer
February 9, 2017

Kahlil Oppenheimer was a Vertica intern during the summer of 2014. This blog post was authored by him and reprinted with his permission. During the first week of my internship at Vertica, my mentor assigned a small bug for me to fix about a set of particular SQL queries. After writing a simple fix for...

Updating UDx Projects: Syncing the Vertica Plug-in for Eclipse with New Vertica Versions

Soniya Shah, Information Developer
February 7, 2017

The Vertica SDK Plug-in for Eclipse version 7.1.2 creates UDxs that are compatible with Vertica version 7.1.x. By replacing two files (BuildInfo.java and VerticaSDK.jar) in projects created with this plug-in, you can update your project to work with newer versions of Vertica. You get the replacement files (/opt/vertica/sdk/BuildInfo.java and /opt/vertica/bin/VerticaSDK.jar) from your currently installed Vertica...

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