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

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

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

Subscribe For Email Updates

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

Sign-up

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

Software Engineering Internships at Vertica: Make a Difference This Summer

Chana Zolty
January 30, 2017

Vertica is looking for summer interns in Cambridge, MA for 2017! Vertica is the leading Big Data analytics database, and our scale, performance, and simplicity are unparalleled in the industry. Vertica enables customers like Facebook, Twitter, Uber, and Zynga to solve Big Data problems at scale that they could not tackle otherwise. If you study...

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

Crowd-sourced Reviews Compare Oracle, Vertica, and Others

Soniya Shah, Information Developer
January 30, 2017

This blog post was authored by Steve Sarsfield.  Crowd-sourced reviews are becoming more and more important in our lives. When you’re thinking about going to a new job, you check out Glassdoor. If you’re heading out to dinner, you check out Yelp. When buying online, the reviews on Amazon are not only informative, but sometimes hilarious....
Modern Database Analytics

LDAP and User Accounts

Soniya Shah, Information Developer
January 30, 2017

This blog post was authored by Soniya Shah. If you are a database administrator, you probably need to authenticate users in Vertica. There are many methods users can use to authenticate, including Ident, Kerberos, LDAP, and hash. This blog walks you through the steps to take if you want to authenticate some users using LDAP...

Vertica Hears From UMass Computer Science Professor

Vertica Technical Team
January 12, 2017

On December 7, Vertica employees were lucky enough to hear a talk from UMass Boston Computer Science Professor Dr. Duc A. Tran. Dr. Tran spoke to us about a distributed storage project he is working on with his students.

The Life of a Query, According to Henry Ford

Vertica Technical Team
January 10, 2017

Batch Exporting Directed Queries

Vertica Technical Team
December 16, 2016

An
Database Server Room

DataGals Hosts a Hot Chocolate Discussion

Chana Zolty
December 13, 2016

Last week, DataGals?an Vertica employee resource group that encourages women in STEM?hosted a hot chocolate and discussion event open to all Microfocus employees.