How to Access Flexible, Cloud-Optimized Analytics on AWS

Posted July 1, 2019 by Ben Smith, Senior Product Marketing Manager

Roger Huebner, Distinguished Engineer
July 11, 2019

We are happy to announce the alpha release of the Vertica SQL Driver for Go. Go, also called GoLang, is a statically-typed, high performance language, syntactically similar to C. Originating at Google, it has grown rapidly in popularity over the past decade and has become a language of choice for highspeed components. The Vertica SQL...

hands in surgical gloves hold vial with small amount of blood

Is Data Warehouse as a Service Out for Your Blood?

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
July 3, 2019

Last weekend, I finally had the chance to watch the popular, yet alarming HBO documentary – . If you haven’t seen it, it’s a true story that centers on Elizabeth Holmes, ex-Theranos CEO, who dropped out of Stanford to build a company that promised to revolutionize blood testing using a small amount of blood from...

Table Row Counts by Schema

Jim Knicely, Vertica Principal Solution Architect
June 13, 2019

I had a colleague ask today how she could generate a report showing the total table row counts by schema. This should be easy, right? After all, the PROJECTION_STORAGE system table has a ROW_COUNT column. But it turns out it’s a little complex considering there are segmented and unsegmented projections and delete vectors in Vertica....

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

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Paige Roberts presenting to a full room with a Zynga case study slide showing

DBTA Data Summit – The Rise of DataOps

Paige Roberts, Vertica Open Source Relations Manager
June 4, 2019

The recent DBTA Data Summit provided a lot to think about. I did a short talk in the “Analytics in Action” track about how data analysts, architects and engineers can turn the endless waves of disruption we keep getting hit with into opportunities to boost bottom line. There were some very cool talks by other...

Set the Spread Daemon Timeout Back to the Default Value

Jim Knicely, Vertica Principal Solution Architect
May 24, 2019

The default value for the Spread Daemon timeout is 8 seconds when the IP addresses of all cluster nodes start with the same two bytes. If all the IP addresses do not start with the same two bytes, then the default is 25 seconds. When you know your network or nodes may be unable to...

Monitor the Current Value of Node Spread Daemon Timeouts

Jim Knicely, Vertica Principal Solution Architect
May 24, 2019

When you know your network or nodes may be unable to respond for a specific amount of time due to network delays or temporary pauses of a VM, you can increase the spread timeout period to longer than this time using the SET_SPREAD_OPTION function (available starting in Vertica 9.2.1-0). You can view the current value...

Explore Popular Topics

DBadmin
SQL
Best Practices
machine learning
VSQL
Advanced Analytics
Cloud
AWS
Eon Mode
Checklists
Security
Time series
Vertica 9
Projections
Hadoop

Min and Max Values for Spread Daemon Timeout

Jim Knicely, Vertica Principal Solution Architect
May 24, 2019

Adjusting Spread Daemon Timeouts for Virtual Environments

Jim Knicely, Vertica Principal Solution Architect
May 24, 2019

If you are running Vertica in a virtual environment, you’ve probably seen nodes leave the cluster even though they are still running. If network delays or temporary pauses of a VM last longer than the spread timeout period, you may see up nodes leave the database. In these cases, you can increase the spread timeout...

Woman asks questions of panel at IOT world with audience

IOT World 2019 – Backing Up the Buzz

Jeff Healey, Sr Director, Vertica Product Marketing at Micro Focus
May 24, 2019

Connected and autonomous vehicles. Smart Cities. Smart Buildings. Predictive maintenance. Lots of robots. This must be , where more than 12,000 IOT enthusiasts joined at the Santa Clara Convention Center to learn if IOT had “jumped the shark” or if we are just now learning how businesses can ultimately gain advantage from trillions of connected...

Take Flight at JM Wine Cellars, may 30th, 4 - 6 PM, JM Cellars, Woodinville, with RSVP button

Is this Wine Good? Wine Quality with Machine Learning

Christina Neble, Senior Partner Business Manager
May 22, 2019

How can you really tell if a wine is good? It’s a commonly known fact that the price of wine does not have a direct correlation to the quality or taste. What if we use some analytics to help make a clear determination if a wine is “good?” My friend and Data Scientist, , shared...

Helpful Tips in blue text with magnifying glass

Include the ALTER and DROP Privileges in a GRANT ALL Statement

Jim Knicely, Vertica Principal Solution Architect
May 20, 2019

When you issue a GRANT ALL statement on a database object such as a table, the ALTER and DROP privileges are excluded. Staring in Vertica 9.2.1, you can include the ALTER and DROP privileges as part of a GRANT ALL statement by specifying the EXTEND clause. Helpful Link: Have fun!

Helpful Tips text with hand and marker over data center background

Watch Out for Data Induced “Cross” Joins

Jim Knicely, Vertica Principal Solution Architect
May 20, 2019

I recently worked with a client who reported that a query in Vertica would not return data. That is, the query ran forever. The query was pretty simple, joining two 100 billion+ tables together. After some investigation, we realized that the query could potentially return trillions and trillions of records! Why? Because the join keys...