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

The Benefits of Vertica for SQL on Hadoop

Wei Wang
July 13, 2015

If you store large data sets in Hadoop, you undoubtedly face many challenges in managing and analyzing that data. Did you know that Vertica for SQL on Hadoop can help ? Check out the scenario that follows to learn how.

Automatic Vertica Database Loader for AWS S3

Bob_Strahan
June 25, 2015

Are you using Amazon Web Services for your Vertica cluster(s)? Are you staging your source data files on AWS S3 storage? If so, this AWS S3 loader for Vertica may be just the thing for you! It will automatically pick up files as they are dropped into S3, and load them into target tables in...

Best Practices for Refreshing Large Projections

Sarah Lemaire, Manager, Vertica Documentation
May 27, 2015

More than once I have worked with customers who need to update a superprojection or create a new projection for a large fact table. It seems like a simple and easy process: just create a projection and perform a refresh. However, refreshing projections for large fact tables can produce unwanted complications. In this blog, we?ll...

Subscribe For Email Updates

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

Sign-up

What is a Lock Anyway?

Sarah Lemaire, Manager, Vertica Documentation
May 19, 2015

We talk a lot about database security and how you can protect your sensitive data from outside threats. But what about internal, unintentional data corruption? What if the data you are trying to analyze or manipulate is simultaneously being manipulated by another transaction? A scenario such as this could lead to data loss and inconsistency....

Time Series Analytics: The Hunt for “Missing Link” in Data

Sarah Lemaire, Manager, Vertica Documentation
May 12, 2015

Time series analytics is a little-known, but very powerful Vertica tool. In Vertica, the TIMESERIES clause and time series aggregate functions normalize data into time slices. Then they interpolate missing values that fill in the gaps.Using time series analytics is useful when you want to analyze discrete data collected over time, such as stock market...
Three 3D arrows, different colors pointing in different directions

Always Have a Backup Plan

Sarah Lemaire, Manager, Vertica Documentation
May 6, 2015

Why should you always have a backup plan? Because something, inevitably, goes wrong. Whether you experience something as simple as a deleted record, or as serious as a full system deletion, you need a backup.

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
Modern Database Analytics

Configuring Vertica for a Multi-Tenant Solution

Curtis_1
April 27, 2015

One of the more interesting and popular Vertica solutions that I've come across is the so-called multi-tenant implementation. A multi-tenant database is simply a database designed to support multiple unique customers. Often, these customers interact with the database through some sort of web interface which uses an Vertica database in the backend.
Machine Learning programmer in glasses looks at graphs

I Love DIY Projects

Joy King, VP Product & GTM Strategy, Vertica
April 17, 2015

I love DIY projects. I love watching the YouTube videos, scouring the web for advice from others, and learning new skills. The innovation and creativity that’s out there is amazing! Plus, DIY projects save money, sometimes a lot of money! This past month, we decided to build our own stone patio in the backyard …...

For Your Eyes Only: Using Vertica Access Policies

Sarah Lemaire, Manager, Vertica Documentation
April 8, 2015

Everyone knows there?s virtually no limit to the amount of data you can store, manage, and query in Vertica. But you may not be aware of how easy it is to control who sees what in your database. In this blog, Alexey Kireyev, the lead security developer for Vertica, explains how you can use the...
Database Server Room

Vertica Best Practices: Identifying Queries for DBD

Sarah Lemaire, Manager, Vertica Documentation
March 26, 2015

The Vertica Database Designer is a tool that analyzes a logical schema definition, sample queries, and sample data, and creates a physical schema (projections) in the form of a SQL script that you deploy automatically or manually. The result is an optimized database with optimal query performance and data compression.

Vertica Storage Location for HDFS

Sarah Lemaire, Manager, Vertica Documentation
January 27, 2015

Do you find yourself running low on disk space on your Vertica database? You could delete older data, but that sacrifices your ability to perform historical queries. You could add new nodes to your cluster or add storage to your existing nodes. However, these options require additional expense.The Vertica Storage Locations for HDFS feature introduced...

What Is a Range Join and Why Is It So Fast?

ChuckB
January 20, 2015

Last week, I was at the 2015 Conference on Innovative Data Systems Research (CIDR), held at the beautiful Asilomar Conference Grounds. The picture above shows one of the many gorgeous views you won't see when you watch other people do PowerPoint presentations. One Vertica user at the conference said he saw a ?range join? in...