Extending Vertica

Updating UDx Projects: Syncing the Vertica Plug-in for Eclipse with New Vertica Versions

The Vertica SDK Plug-in for Eclipse version 7.1.2 creates UDxs that are compatible with Vertica version 7.1.x. By replacing two files (BuildInfo.java and VerticaSDK.jar) in projects created with this plug-in, you can update your project to work with newer versions of Vertica. You get the replacement files (/opt/vertica/sdk/BuildInfo.java and /opt/vertica/bin/VerticaSDK.jar) from your currently installed Vertica […]

Introducing the Developing Vertica UDxs in Java Tutorial Series

What is a Java UDx and why would you want to develop one? Check out our new tutorial series in the wiki to find out!

Using JDBC Routable Query API for High Concurrency and High Throughput

Does your organization use high-volume short requests that return a small number of results on a single node? Do you deal with low latency and high concurrency queries, and want to achieve high throughput? You could benefit by using the Vertica JDBC Routable Query API that uses fewer system resources than distributed queries.

Using the Vertica ORC Reader with Business Intelligence Tools

What we are going to discuss is the new functionality introduced in Vertica 7.1 SP2 that allows customers to access files in HDFS stored in ORC format and achieve significant performance benefits compared to raw text files.

Enter the Flex Zone – Under the Hood

With Vertica’s latest release (Vertica 7 Crane”), we introduced 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 Vertica analytics platform which includes, among others, a great new feature called 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 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 Vertica 7 release, we announced 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 Vertica Flex Zone to get a leg up on your latest data analysis problem, using Twitter data as the sample data type.