Vertica Blog

Vertica Blog

Vertica Blog

Installing Vertica SQL on Hadoop

Gary Gray, Principal Information Developer
January 27, 2016

Interested in adding Vertica's analytic capabilities to your Hadoop cluster? Watch this tutorial video to learn how you can install Vertica on Hadoop, giving it faster access to your data!

What are Vertica Engineers Reading?

Sarah Lemaire, Manager, Vertica Documentation
January 6, 2016

Ever wonder what Vertica engineers do when they aren?t busy building and perfecting an awesome product?

Tell the Optimizer You Have a Better Plan

Michael Kronenberg
December 17, 2015

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

BD_Partner_Eng
December 8, 2015

Want some hints about how to use Looker to visualize data in your Vertica database? The Looker user community, known as

Data-Centric Security: Vertica and SecureData

BD_Partner_Eng
December 3, 2015

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.

Restoring Objects from a Full Backup

Sarah Lemaire, Manager, Vertica Documentation
November 24, 2015

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

Phil Molea, Sr. Information Developer, Vertica
November 16, 2015

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

BD_Partner_Eng
November 5, 2015

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.

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!

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.