Vertica Blog

Vertica Blog

Vertica Blog

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.

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.

The Benefits of Vertica for SQL on Hadoop

Wei Wang
July 13, 2015

If you store large data sets in Hadoop, you undoubtedly face many challenges in managing and analyzing that data. Did you know that Vertica for SQL on Hadoop can help ? Check out the scenario that follows to learn how.

Automatic Vertica Database Loader for AWS S3

Bob_Strahan
June 25, 2015

Are you using Amazon Web Services for your Vertica cluster(s)? Are you staging your source data files on AWS S3 storage? If so, this AWS S3 loader for Vertica may be just the thing for you! It will automatically pick up files as they are dropped into S3, and load them into target tables in...

Best Practices for Refreshing Large Projections

Sarah Lemaire, Manager, Vertica Documentation
May 27, 2015

More than once I have worked with customers who need to update a superprojection or create a new projection for a large fact table. It seems like a simple and easy process: just create a projection and perform a refresh. However, refreshing projections for large fact tables can produce unwanted complications. In this blog, we?ll...

What is a Lock Anyway?

Sarah Lemaire, Manager, Vertica Documentation
May 19, 2015

We talk a lot about database security and how you can protect your sensitive data from outside threats. But what about internal, unintentional data corruption? What if the data you are trying to analyze or manipulate is simultaneously being manipulated by another transaction? A scenario such as this could lead to data loss and inconsistency....