Vertica Blog

Vertica Blog

Vertica Blog

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

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.

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.

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.

The Benefits of Single Node Queries

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.