Vertica Blog

Vertica Blog

Vertica Blog

Programmer

Using Vertica and HyperLogLog

Soniya Shah, Information Developer
May 9, 2017

This is a guest blog post co-authored by Francois Jehl and Pawel Szostek. Francois is the lead of the Analytics Data Storage team at Criteo; Pawel is a software engineer in the Analytics Data Storage team at Criteo. Criteo is the global leader in digital performance advertising with 900B ads served in 2016. The R&D...

Machine Learning Mondays: Data Preparation for Machine Learning in Vertica

Soniya Shah, Information Developer
May 8, 2017

This blog post was authored by Vincent Xu. This post is part of our Machine Learning Mondays series. Stay tuned for more! Introduction Machine learning (ML) is an iterative process. From understanding data, preparing data, building models, testing models to deploying models, every step of the way requires careful examination and manipulation of the data....

Using Hadoop Rack Locality to Boost Vertica Performance

Soniya Shah, Information Developer
May 4, 2017

This blog post was authored by Monica Cellio. When database nodes are co-located on Hadoop data nodes, Vertica can take advantage of the Hadoop rack configuration to execute queries against ORC and Parquet data. Moving query execution closer to the data reduces network latency and can improve performance. Vertica automatically uses database nodes that are...

What’s New in Vertica 8.1: Connecting to Vertica Updates

Phil Molea, Sr. Information Developer, Vertica
May 1, 2017

Vertica 8.1 includes the following product enhancements to Connecting to Vertica. Functional Updates to \timing The \timing metafunction has been enhanced so you can use the following commands to toggle \timing on or off based on its current setting: •\timing – turns timing on or off depending on its current state. For example if timing...

What’s New in Vertica 8.1: Security Updates

Phil Molea, Sr. Information Developer, Vertica
April 27, 2017

Vertica 8.1 includes the following enhancements to Vertica security. Function to Verify Kerberos Configuration The function KERBEROS_CONFIG_CHECK allows you to test your Kerberos configuration of the Vertica cluster. Running this function checks: • Whether or not Kerberos services are available. • If a keytab file exists • If the Kerberos configuration parameters are set in...
Database Server Room

What’s New in Vertica 8.1: Machine Learning

Soniya Shah, Information Developer
April 25, 2017

This blog post was authored by Soniya Shah. Overall, you will notice that Machine Learning for Predictive Analytics, introduced in Vertica 7.2.2, is more accessible to use in Vertica 8.1, with the addition of several important functions. There are improvements to model management with access control ability to save and re-apply normalization parameters, missing value...

What’s New in Management Console 8.1

Lisa Donaghue
April 24, 2017

Vertica 8.1 introduced new monitoring and usability enhancements to Management Console (MC). MC now provides the ability to easily monitor catalog memory and configure Workload Analyzer. You’ll also find usability improvements to cluster creation and setup for Extended Monitoring. Watch our short video about What's New In MC in Vertica 8.1: https://www.youtube.com/watch?v=2yqzCAZGyeA&feature=youtu.be Read on to...

What’s New in Vertica 8.1: Supported Platforms

nunziato
April 18, 2017

With Vertica Release 8.1, we continue to enhance and broaden our platform support. New Operating Systems for Vertica Server Vertica continues to perform extensive testing as we qualify major Linux distributions for use with the Vertica Analytic Database. Our testing ensures both stability and performance when you use Vertica with a supported operating system. For...

What’s New in Vertica 8.1?

Chana Zolty
April 17, 2017

Watch this video to learn what’s new in Vertica version 8.1. New features include: - flattened tables - supported platforms update - Management Console features - Kafka connectivity update - machine learning functions - rack locality - Geohash conversions - security upgrades - wide column data query improvement

What’s up with rejected data?

Chana Zolty
April 12, 2017

This blog post was authored by Kanti Mann. In a perfect world, any and all data you attempt to load into your database would seamlessly and accurately move from point A to point B. Unfortunately, this doesn’t always happen. Occasionally, data fails to load into its destination table, and you’ll probably want to know what...

Why auto-scaling analytical databases aren’t so magical

Soniya Shah, Information Developer
April 6, 2017

This blog post was authored by Steve Sarsfield. There is a new feature in analytical databases that seems to be all the rage, particular in cloud data warehouse - Autoscaling. Autoscaling’s promise is that if you have a particularly hard analytical workload, autoscaling will spin up new storage and compute to get the job done....

Understanding AT TIME ZONE

Soniya Shah, Information Developer
April 4, 2017

TIMESTAMPTZ AT TIME ZONE and TIMESTAMP AT TIME ZONE return date input in another time zone. How Vertica executes AT TIME ZONE varies, depending on whether the input is a TIMESTAMPTZ or TIMESTAMP. At first glance, this might be confusing. More about that later. First, let's review AT TIME ZONE syntax: { TIMESTAMPTZ | TIMESTAMP...