Vertica Blog

Vertica Blog

Vertica Blog

Three 3D arrows, different colors pointing in different directions

Create and Assign Roles

Phil Molea, Sr. Information Developer, Vertica
March 30, 2017

A role is a collection of privileges that can be granted to one or more users or roles. Assigning roles prevents you from having to manually grant sets of privileges for each individual user. For the most part, creating and assigning roles is fairly straightforward. However, the user to which roles are assigned needs to...

Filtering Data While Loading into Vertica

Sarah Lemaire, Manager, Vertica Documentation
March 22, 2017

Suppose you have a CSV file and you want to copy some, but not all, of its contents into a Vertica table. There are two ways you can to do this: • Use the SKIP keyword with COPY. • Use the head or tail Linux command. Let's see how this works. The Data Here's a...
Programmer

Vertica Machine Learning Series: Logistic Regression

Soniya Shah, Information Developer
March 16, 2017

This blog post is based on a white paper authored by Maurizio Felici. What is Logistic Regression? Logistic regression is a popular machine learning algorithm used for binary classification. Logistic regression labels a sample with one of two possible classes, given a set of predictors in the sample. Optionally, the output can be the probability...

DataGals Hosts an International Women

Soniya Shah, Information Developer
March 9, 2017

This blog post was authored by Soniya Shah. This week, the DataGals hosted an event in celebration of International Women’s Day. This year’s campaign asked supporters around the world to #BeBoldForChange to encourage a more inclusive, gender equal world. You can read more about the campaign and influencers on the International Women’s Day site. International...

Spark Summit East

Soniya Shah, Information Developer
March 8, 2017

This blog post was authored by Myles Collins. I recently went to the Spark Summit East to take the Spark training and get current on the technology that my group (Vertica Partner Engineering) is using more and more. Conveniently, it was held here in Boston. A few weeks after I registered, marketing decided to sponsor...

Using Vertica on IoT Data: Gap Filling and Interpolation for Incomplete Sensor Data

Soniya Shah, Information Developer
March 6, 2017

This post was originally authored by Marco Gessner and appeared on LinkedIn. It has been reposted here with his permission. This article explains the basic gap filling and interpolation functionality in Vertica. Vertica was designed for the fast processing and analysis of huge volumes of data and is well suited to IoT applications. One of...

Dynamic Row and Column Access Policies

Phil Molea, Sr. Information Developer, Vertica
March 1, 2017

The content of this blog post is based on an article authored by Maurizio Felici. The Vertica Analytic Database access policies act on columns and rows to provide extra security on data in your tables. You can create flexible access policies that limit which users can access certain data by applying the access policy to...
Database Server Room

Vertica Machine Learning Series: k-means

Soniya Shah, Information Developer
February 22, 2017

The content of this blog is based on a white paper that was authored by Maurizio Felici. What is k-means Clustering? K-means clustering is an unsupervised learning algorithm that clusters data into groups based on their similarity. Using k-means, you can find k clusters of data, represented by centroids. As the user, you select the...

Using Vertica on Azure

Chris Daly
February 21, 2017

A lot of customers are starting to explore the idea of reducing infrastructure related costs of their enterprise solutions by migrating them to publicly hosted cloud based environments. With that in mind I am very pleased to announce the official support of Vertica running in the Microsoft Azure cloud environment. This latest step in the...

Using the Vertica on Azure Free Trial

Chris Daly
February 15, 2017

In August of last year, we announced support for Vertica in the Microsoft Azure Cloud environment. This includes a fully automated cluster deployment from the Azure Marketplace (which can be found here) and also includes our free Community Edition license. Microsoft, like many other public Cloud providers, offers a free trial subscription for users that...

Machine Learning Series: Linear Regression

Soniya Shah, Information Developer
February 13, 2017

The content of this blog is based on a white paper that was authored by Maurizio Felici. This blog post is just one in a series of blog posts about the machine learning algorithms in Vertica. Stay tuned for more! What is Linear Regression? Let’s start with the basics. Linear regression is one of the...

Patented: A Look into Kahlil Oppenheimer

Soniya Shah, Information Developer
February 9, 2017

Kahlil Oppenheimer was a Vertica intern during the summer of 2014. This blog post was authored by him and reprinted with his permission. During the first week of my internship at Vertica, my mentor assigned a small bug for me to fix about a set of particular SQL queries. After writing a simple fix for...