Vertica Blog

Vertica Blog

Vertica Blog

Programmer

Vertica in the Clouds

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

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

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

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

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

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

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

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

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

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

Try out the new Vertica Community Edition Virtual Machine!

This blog post was authored by Kathy Taylor. New to Vertica? Wondering where to start? Why not start with our new 8.1.1 Community Edition VM? It's free! Just download the VM and start it up in a VM player on your PC. Open the User Guide, start the exercises, and off you go! You'll be...

What’s New in Vertica 9.0: Security and Authentication

This blog post was authored by Phil Molea. Multi-realm Support Vertica 9.0 introduces multi-realm support for Kerberos authentication. This allows you to assign a different realm so that users from another realm can authenticate to Vertica. At times, customers may store users in a protected directory server (AD or Linux KDC) for their trusted realm....
Three 3D arrows, different colors pointing in different directions

What’s New in Vertica 9.0: Google Cloud Platform

This blog post was authored by Chris Daly. Announcing Vertica availability in Google Cloud Platform With the release of Vertica 9.0, the team at Micro Focus has brought you a ton of new updates and enhancements that are certainly worthy of getting excited about! If you haven’t had a chance, you should check out the...