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

Converting Multicharacter Delimiters for Loading

Tim Donar
October 13, 2015

Do you have issues loading data in Vertica from a single input file containing multicharacter delimiters like ^~^? If so, you can develop a parser to convert the delimiters from multiple characters into a single character and then load the data in parallel streams.
Modern Database Analytics

Understanding ROS and WOS: A Hybrid Data Storage Model

Sarah Lemaire, Manager, Vertica Documentation
October 7, 2015

Vertica is unique in many ways, one of which can be seen in its data storage model. In this blog, we?ll go over each storage component and show you how to take advantage of Vertica?s storage options to optimize your database for writing and reading.
Programmer

Introducing the Developing Vertica UDxs in Java Tutorial Series

Gary Gray, Principal Information Developer
September 30, 2015

What is a Java UDx and why would you want to develop one? Check out our new tutorial series in the wiki to find out!

Subscribe For Email Updates

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

Sign-up

Using JDBC Routable Query API for High Concurrency and High Throughput

Shubhangi Vajpayee
September 14, 2015

Does your organization use high-volume short requests that return a small number of results on a single node? Do you deal with low latency and high concurrency queries, and want to achieve high throughput? You could benefit by using the Vertica JDBC Routable Query API that uses fewer system resources than distributed queries.
Database Server Room

Using Big Data Analytical Tools for Predicting Potential Global Distribution of an Amphibian Pathogen

Sarah Lemaire, Manager, Vertica Documentation
September 9, 2015

During the summer of 2015, I participated in an internship program with Vertica. Most interns assisted in software development, but my primary goal was to use Vertica, Vertica Place, and HP Distributed R to address an ecological problem

Kerberos Authentication for Hadoop Integration: Keeping your data safe

Sarah Lemaire, Manager, Vertica Documentation
August 27, 2015

Like all Vertica releases, 7.1.2 includes a bunch of new features. One specific feature can help make your HDFS data safer: Kerberos integration for Hadoop. This blog will give you an overview of using Kerberos authentication with Vertica for SQL on Hadoop.

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

The Benefits of Single Node Queries

Sumeet Keswani
August 19, 2015

If your organization deals with low latency, high concurrency applications and queries, you can benefit from having as few nodes as possible involved in each query.

Vertica and Qlik Team Up to Hack for a Cause

Sarah Lemaire, Manager, Vertica Documentation
August 17, 2015

On November 17 2014, Vertica took part in the annual Qlik Hackathon in Orlando, Florida. The hackathon, which took place the day before the Qlik World Conference, brought together engineers, developers, and Qlik experts from all over the world. The challenge was simple: leverage features from Qlik and its partners to create an application to...

Using the Vertica ORC Reader with Business Intelligence Tools

M_Warner
August 6, 2015

What we are going to discuss is the new functionality introduced in Vertica 7.1 SP2 that allows customers to access files in HDFS stored in ORC format and achieve significant performance benefits compared to raw text files.

Cloning a Vertica Cluster to AWS

Bob_Strahan
July 27, 2015

This enhancement to the
Three 3D arrows, different colors pointing in different directions

Why Do My License Audits Show A Significant Size Reduction?

nunziato
July 24, 2015

When you run a database audit, you may notice that your Vertica audit size has reduced from the audit size calculated before you upgraded to version 7.1 SP2. Don't worry, you haven't lost any data. The size reduction is due to storage changes related to licensing.

AWS Elastic Load Balancing with Vertica

Bob_Strahan
July 20, 2015

Did you know that you can use an Elastic Load Balancer (ELB) to connect to your Vertica cluster running on Amazon Web Services? You can, and you should for several reasons.