Vertica Blog

Vertica Blog

Vertica Blog

Vertica and Qlik Team Up to Hack for a Cause

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

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

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

Why Do My License Audits Show A Significant Size Reduction?

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

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

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

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

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?

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

Time Series Analytics: The Hunt for “Missing Link” in Data

Time series analytics is a little-known, but very powerful Vertica tool. In Vertica, the TIMESERIES clause and time series aggregate functions normalize data into time slices. Then they interpolate missing values that fill in the gaps.Using time series analytics is useful when you want to analyze discrete data collected over time, such as stock market...
Three 3D arrows, different colors pointing in different directions

Always Have a Backup Plan

Why should you always have a backup plan? Because something, inevitably, goes wrong. Whether you experience something as simple as a deleted record, or as serious as a full system deletion, you need a backup.

Configuring Vertica for a Multi-Tenant Solution

One of the more interesting and popular Vertica solutions that I've come across is the so-called multi-tenant implementation. A multi-tenant database is simply a database designed to support multiple unique customers. Often, these customers interact with the database through some sort of web interface which uses an Vertica database in the backend.