myVertica  

Vertica Blog

SQL

Investigating Public Data: Road Safety in the U.K.

When learning new database applications, a good place to start is with some compelling, real-world data. It’s not necessarily so easy to find.

Unlimited Access to Vertica for SQL on Hadoop for Free!

Join the Early Adopter Program for Vertica for SQL on Hadoop to experience the full power of Vertica for SQL on Hadoop without any commitments.

Installing Vertica SQL on Hadoop

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!

Kerberos Authentication for Hadoop Integration: Keeping your data safe

Like all HP 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 HP Vertica for SQL on Hadoop.

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 HP Vertica for SQL on Hadoop can help ? Check out the scenario that follows to learn how.

New Vertica for SQL on Hadoop Features

HP Vertica is excited to announce new features for HP Vertica for SQL on Hadoop in HP Vertica version 7.1.2. Most notably, we’ve added Kerberos integration for Hadoop, and the ability to directly read ORC files.

Vertica for SQL on Hadoop

HP Vertica now offers a SQL on Hadoop license, which allows you to leverage Vertica’s powerful analytics engine to explore data in Hadoop Distributed File System (HDFS).

MySQL Ate My Homework: Five Reasons You Should Always Use a Subpar Data Platform

In the big data technology industry, we spend most of our time writing blogs and whitepapers about our technology.  I’m sure you’ve heard this before…”Our technology is great…it’s the best…most functional…top-notch” and so forth.  But we never really discuss when someone might want to use less effective technology – systems that may be more raw, or less suited to the task, or that have no vendor behind them.  Sure, these systems can break easily or might not do everything you want, but some of these technologies have tens of thousands of users around the world. So, they must be valid choices, right?

How to make ROLLUP fly in Vertica?

ROLLUP is a very common Online Analytic Processing (OLAP) function and is part of ANSI SQL. Many customers use ROLLUP to write reports that automatically perform sub-total aggregations across multiple dimensions at different levels in one SQL query.