Vertica Blog

The Vertica Academy Is Open for Learning

Posted September 9, 2019 by Joy King, VP, Vertica Product Management & Product Marketing

Read More

Introducing an Industry First – Vertica in Eon Mode for Pure Storage

This week at the Pure Accelerate conference, Vertica and Pure Storage of Vertica in Eon Mode for Pure Storage, the industry’s first and only analytical database solution with a separation of compute and storage architecture for on-premises analytic workloads. Why is this important to you? The rush to migrate analytic workloads to the cloud was,...

Vertica Big Data Conference Registration is Open!

We’re excited to announce that for the next Vertica Big Data Conference (BDC), held March 30 – April 2, 2020, at the Encore Boston Harbor Hotel. Don’t miss out on the early bird pricing rate of $695 (a $300 savings), along with buy 3 get 1 free group discounts!   What is the Big Data...

Tell the Optimizer You Have a Better Plan

You're upgrading your database and some query appears to execute less efficiently than before. What can you do? Vertica addresses this concern in Vertica 7.2 with directed queries

Using Looker to Leverage Vertica Capabilities: ORC Reader, Flex Tables, and Place

Want some hints about how to use Looker to visualize data in your Vertica database? The Looker user community, known as , has published three articles that explain how to use Looker with these Vertica features: ORC reader, Flex tables, and Geospatial functions and data"

Data-Centric Security: Vertica and SecureData

Take advantage of the recent integration of Vertica and SecureData. This integration allows you to keep your data protected when it flows across multiple systems spread across multiple data centers on premise or in the cloud.

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Restoring Objects from a Full Backup

Before Vertica version 7.2, you had two options: perform full backups and restore full backups (remove everything from the storage unit) or perform object-level backups and restore those individually (maintain separate storage units). But as of Vertica 7.2, you can have the best of both worlds. You can perform full backups and restore individual objects...

Using Inherited Privileges

New to Vertica 7.2.0, the inherited privileges feature provides a one-step method for enabling privileges at the schema level.
Three 3D arrows, different colors pointing in different directions

Using the Informatica PowerCenter Connector for Vertica

Have you been using the plug-in (Java or Native) that Vertica developed to connect to your Vertica database using Informatica PowerCenter? Now there's a better option that provides additional functionality.

Explore Popular Topics

Converting Multicharacter Delimiters for Loading

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.

Understanding ROS and WOS: A Hybrid Data Storage Model

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

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!

Using JDBC Routable Query API for High Concurrency and High Throughput

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.

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

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

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.