myVertica  

Vertica Blog

Tables

Rebalance a Large Partitioned Table

Your organization is collecting data as fast as your Vertica cluster can store it, so fast that you need to add a few nodes to your cluster. After you add those nodes, Vertica must distribute the data across all the existing and new nodes for best performance. We call this operation rebalancing.

Using Looker to Leverage Vertica Capabilities: ORC Reader, Flex Tables, and Place

Want some hints about how to use Looker to visualize data in your Vertica database? The Looker user community, known as Looker Discourse, has published three articles that explain how to use Looker with these Vertica features: ORC reader, Flex tables, and Geospatial functions and data

Enter the Flex Zone – Under the Hood

With HP Vertica’s latest release (HP Vertica 7 Crane”), we introduced HP Vertica Flex Zone, based on the patent-pending flex tables technology, which dynamically adapt to whatever schema is present in the data. Flex tables offer dramatic usability improvements over regular tables. In this post, we take a look under the hood and show how flex tables are similar to regular Vertica tables, with a little pinch of magic thrown in.

Enter the FlexZone – Let’s talk ETL

In December, HP released version 7 of the HP Vertica analytics platform which includes, among others, a great new feature called HP Vertica Flex Zone (Flex Zone). Flex Zone enables you to quickly and easily load, explore and analyze some forms of semi-structured data. It eliminates the need for coding-intensive schemas to be defined or applied before the data is loaded for exploration.

Enter the Flex Zone – Exploring Delimited Data

Here at HP Vertica, we had to solve a technical challenge that many of you might be facing: data analysis from legacy products.

Welcome to the Flex Zone – Dynamic Schemas

Much of the data analytics we perform occurs with data whose schema changes over time. Many organizations have developers who define the record types that are collected and analysts who comb through these records looking for important patterns. In today’s fast-changing business landscape, agility is the key to success: developers need to continually define new metrics for their analyst’s consumption.

Enter the Flex Zone –– An Exploration in Processing Twitter Data

With our HP Vertica 7 release, we announced HP Vertica Flex Zone, a new product offering that simplifies the way that you consume and then explore semi-structured data, such as Web logs, sensor data, and other emerging data types. In this blog post, our first “Flex Zone Friday” post, let’s look at how you can use HP Vertica Flex Zone to get a leg up on your latest data analysis problem, using Twitter data as the sample data type.