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: Security Updates

Phil Molea, Sr. Information Developer, Vertica
April 27, 2017

Vertica 8.1 includes the following enhancements to Vertica security. Function to Verify Kerberos Configuration The function KERBEROS_CONFIG_CHECK allows you to test your Kerberos configuration of the Vertica cluster. Running this function checks: • Whether or not Kerberos services are available. • If a keytab file exists • If the Kerberos configuration parameters are set in...
Database Server Room

What’s New in Vertica 8.1: Machine Learning

Soniya Shah, Information Developer
April 25, 2017

This blog post was authored by Soniya Shah. Overall, you will notice that Machine Learning for Predictive Analytics, introduced in Vertica 7.2.2, is more accessible to use in Vertica 8.1, with the addition of several important functions. There are improvements to model management with access control ability to save and re-apply normalization parameters, missing value...

What’s New in Management Console 8.1

Lisa Donaghue
April 24, 2017

Vertica 8.1 introduced new monitoring and usability enhancements to Management Console (MC). MC now provides the ability to easily monitor catalog memory and configure Workload Analyzer. You’ll also find usability improvements to cluster creation and setup for Extended Monitoring. Watch our short video about What's New In MC in Vertica 8.1: https://www.youtube.com/watch?v=2yqzCAZGyeA&feature=youtu.be Read on to...

Subscribe For Email Updates

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

Sign-up

What’s New in Vertica 8.1: the Connector for Apache Spark

Gary Gray, Principal Information Developer
April 20, 2017

The Vertica 8.1 release includes updates for the Vertica Connector for Apache Spark. The biggest new feature is Apache Spark 2.0 compatibility. This makes the connector compatible with the version of Spark included with most recent Hadoop distributions. In addition, the connector supports multiple versions of the Scala programming language. Most Hadoop distributions that support...

What’s New in Vertica 8.1: Supported Platforms

nunziato
April 18, 2017

With Vertica Release 8.1, we continue to enhance and broaden our platform support. New Operating Systems for Vertica Server Vertica continues to perform extensive testing as we qualify major Linux distributions for use with the Vertica Analytic Database. Our testing ensures both stability and performance when you use Vertica with a supported operating system. For...

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

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

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

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