Vertica Blog

Vertica Blog

Under the Hood

young girl choosing recommended video playback button.

Content Analytics and Video Recommendation Systems with Vertica

Marko Štajcer, Director of Innovation & Development department at Poslovna inteligencija d.o.o.
June 11, 2019

Analyzing digital content and the behavior of viewing customers in real-time is essential to a lot of companies. Communication operators and content providers are offering many services that enable customers to consume video content using different fixed and mobile technologies through different devices, either in their homes or mobile. For these operators and providers, it...
Drawing of 4 blue pillars: Separation, Automation, Prediction, Protection

Vertica’s Architectural Direction – Separation of Compute and Storage

Chuck Bear, Vertica Chief Architect
June 10, 2019

For over a decade, Vertica has delivered industry-leading performance on analytic query workloads in on-premises “shared-nothing” environments. Due to several good (and several lucky) historical architectural decisions, Vertica in Eon Mode is also leading the market for elastic, on-demand databases in public clouds. This post will review the key features of the Vertica architecture, and describe Vertica’s...
Passenger balloon floating in blue sky

Announcing Vertica Version 9.2.1 – Take Analytics Efficiency to the Next Level

Paige Roberts, Vertica Open Source Relations Manager
May 10, 2019

This week, some very cool things have gone into the newest version of the Vertica Analytics Platform that make your analytics fly and save on your AWS budget. The theme for this release is Improving Vertica in Eon Mode Integration with Amazon S3, and there are a whole bunch of new features designed to do...
Business card that says Expert Tips,

Create a Python UDx to Order a List of Values

James Knicely, Vertica Field Chief Technologist
April 25, 2019

User-Defined Extensions (UDxs) are functions contained in external shared libraries that are developed in C++, Python, Java, or R using the Vertica SDK. The external libraries are defined in the Vertica catalog using the CREATE LIBRARY statement. They are best suited for analytic operations that are difficult to perform in SQL, or need to be...
Machine learning robot studying equations and graphs

1 – Why Would You Do Machine Learning in a Database?

Waqas Dhillon, Product Manager - Machine Learning, Vertica
April 22, 2019

Co-authored with Paige Roberts. A lot of modern scalable analytical databases like Vertica allow you to do machine learning data analytics from end to end, right in the database, rather than moving and transforming the data first into something like a Spark dataframe or a Python data structure. Whenever people hear about this capability, they...
Commercial passenger plane with Vertica painted on the tail

Blog Post Series: Using Vertica to Track Commercial Aircraft in near Real-Time — Part 7

Mark Whalley, Manager, Vertica Education
April 4, 2019

Preparing Vertica to consume messages from Kafka How time has flown (no pun intended!).  At long last getting back to continuing this project on tracking commercial aircraft… Having covered ADS-B, the Raspberry Pi, DUMP1090, Zookeeper and Kafka and then in the previous blog post, how to develop an Extract, Transform and Load (ETL) application to...

Fun April Fool’s Day Trick Using Directed Queries

James Knicely, Vertica Field Chief Technologist
April 1, 2019

Directed Queries in Vertica encapsulate information that the optimizer can use to create a query plan. Directed queries can serve the following goals: Preserve current query plans before a scheduled upgrade. In most instances, queries perform more efficiently after a Vertica upgrade. In the few cases where this is not so, you can use directed...

Do you have experience using Vertica?

Soniya Shah, Information Developer
March 20, 2019

The Vertica Product Management team is collecting feedback on what new features and functionality our customers would like to see added to the product. We’ve been actively gathering product-related feedback for nearly a year and have been using it to make more informed decisions about how we manage the Vertica product roadmap. Thank you for...

Elastic Throughput Scaling: Overview

Phil Molea, Sr. Information Developer, Vertica
February 5, 2019

Manvendra Panwar authored this post. Elastic Throughput Scaling (ETS) enables Vertica to increase concurrency through which we can achieve higher throughput. ETS can take advantage of redundant shard subscriptions to automatically identify the nodes in the cluster that can execute a query. More Nodes (N) than Shards (S): Achieving higher throughput • S nodes can...

Try Vertica in a Virtual Machine

Kathy Taylor, Information Technology Developer, Vertica
January 24, 2019

Curious about Vertica? Check out the Vertica Community Edition VM! It’s a free, quick, and an easy hands-on introduction. In the VM, you’ll find everything up and running. You won’t have any setup to do. You’ll find a single-node installation of Vertica Community Edition with the VMart example database, the Vertica client tools, and a...

Plotting data with vsql and gnuplot

Phil Molea, Sr. Information Developer, Vertica
December 6, 2018

Maurizio Felici authored this post. We all know how plotting data is a very useful – and widely adopted – technique. Linux (and MacOS) offer a wonderful command line tool to plot data called gnuplot. You can install and run gnuplot on one of your Vertica nodes so you don’t have to move data out...

Encode Projection Columns with Zstandard Compression: Quick Tip

James Knicely, Vertica Field Chief Technologist
December 3, 2018

Vertica 9.2 now supports the Zstandard Compression Encoding Type which offers higher compression than the BZIP and GZIP Encoding Types! Helpful Link: https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/SQLReferenceManual/Statements/encoding-type.htm Have fun!