Vertica Blog

Vertica Blog

Vertica Blog

Authentication Methods for dbadmin

Soniya Shah, Information Developer
January 3, 2018

This blog post was authored by Sumeet Keswani. In Vertica, when you create a new database, there are no configured authentication methods. In this case, Vertica assumes that all users, including the dbadmin, have an implicit password authentication. Users can use this authentication method both for authenticating over a network interface and for over a...
Three 3D arrows, different colors pointing in different directions

DataGals Year in Review

Soniya Shah, Information Developer
December 22, 2017

The DataGals had an amazing 2017! Everyone on our steering committee - Lisa Donaghue, Styliani Pantela, Soniya Shah, Diem Tran, and Sharada Vesta would like to wish you a very happy new year! Check out our year in review below. We look forward to a successful 2018. Happy holidays from the DataGals!
Modern Database Analytics

External data is easier to manage than the Hadoop Stack

Soniya Shah, Information Developer
December 19, 2017

This blog post was authored by Steve Sarsfield. It has been a thrilling ride. In a few short years, Hadoop has seen astronomical rise, but recently, interest in Hadoop has peaked. Analysts like Gartner and Datanami are reporting that the hype in Hadoop is waning, with some hope that use cases for Hadoop will find...
Programmer

Vertica in the Clouds

Soniya Shah, Information Developer
December 18, 2017

This blog post was authored by Soniya Shah. The benefits of using cloud computing and storage are virtually endless. You can scale services up or down to fit your needs, customize applications, and access cloud services from everywhere. Using the cloud makes it easy to scale elastically and makes infrastructure both affordable and flexible. With...

Flattened Tables

Soniya Shah, Information Developer
December 4, 2017

This blog post was authored by Soniya Shah. Before release 8.1., Vertica users could denormalize their data by combining all fact and dimension table columns in a single 'fat' table. These tables facilitated faster query execution. However, this approach required users to maintain redundant sets of normalized and denormalized data, which incurred its own overhead....

Phrase Search with Vertica Text Search

Soniya Shah, Information Developer
November 27, 2017

This blog post was authored by Serge Bonte. Vertica Text Search Vertica already provides Text Search. Text Search allows you to quickly search the contents of a single CHAR, VARCHAR, LONG VARCHAR, VARBINARY, or LONG VARBINARY field within a table to locate a specific token. Vertica implements that capability using a dedicated Text Index to...

What’s New in Vertica 9.0: Hierarchical Partitioning

Soniya Shah, Information Developer
November 20, 2017

This blog post was authored by Michael Kronenberg. With Vertica 9.0, you can consolidate partitions into groups that minimize use of ROS storage. Reducing the number of ROS containers to store partitioned data helps facilitate DML operations such as DELETE and UPDATE, and avoid ROS pushback. For example, you can group date partitions by year....
Database Server Room

What’s New in Vertica 9.0: The UUID Data Type

Soniya Shah, Information Developer
November 16, 2017

This blog post was authored by Gary Gray. Vertica version 9.0 adds Universal Unique Identifier (UUID) to its collection of data types. Accompanying this new data type are updates to the client libraries and a new function to help you use UUIDs in your database. As its name implies, computers use UUIDs to uniquely identify...

What’s New in Vertica 9.0: Sentry Integration

Soniya Shah, Information Developer
November 13, 2017

This blog post was authored by Mitchell Tracy and Monica Cellio. Hadoop clusters can use authorization services to determine which users can access what data in Hive and, by extension, HDFS. In Vertica 9.0 we now support one of the most common such services, Apache Sentry. Apache Sentry is a project in the Hadoop ecosystem...

Data Pipelines: Vertica and Kafka

Soniya Shah, Information Developer
November 9, 2017

This blog post was authored by Tom Wall and Soniya Shah. At Vertica, we want to make it as easy as possible for your Vertica environment to coexist with other tools and technologies. We know that one size does not fit all. Sometimes you need a customized, end-to-end view of your system. Imagine you're on...

Transitioning Vertica Support

Soniya Shah, Information Developer
November 8, 2017

As part of our merge with Micro Focus, we are moving our support platform from my.vertica.com to Software Support Online. We want to make this alignment as smooth as possible for our customers and encourage you to read our Alignment Step by Step guide for Vertica Customers moving to SSO.

Estimate the Price of Diamonds Using Vertica Machine Learning

Soniya Shah, Information Developer
November 7, 2017

This blog post was authored by Vincent Xu. In this blog post, I’ll take you through the exercise I did to estimate the price of a diamond based on its characteristics, using the linear regression algorithm in Vertica. Besides Vertica 9.0, I used Tableau for charting and DbVisualizer as the SQL editor. From this exercise,...