Vertica

Creating Vertica Functions in Third Party Tools

Kathy Taylor, Information Technology Developer, Vertica
July 11, 2019

Third party SQL client tools that connect to Vertica often provide a SQL command window where you can type SQL commands and view the results. Most of these tools’ SQL command windows support issuing multiple commands in a single SQL block, using the semicolon as the command delimiter. Here is an example in : The...

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 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 exactly that. But,...

Display the Vertica Process Memory Allocated

Jim Knicely, Vertica Principal Solution Architect
April 10, 2019

For common Vertica cluster configurations, there should be a single running Vertica process on each node. You can use the Linux ps command to determine the process ID of the Vertica process. Once you have the process ID, you can display the amount of memory that has been allocated to the Vertica process using the...

Display Database Statement Counts by Type

Jim Knicely, Vertica Principal Solution Architect
April 9, 2019

There are many types of statements that can be executed in Vertica. Examples include queries, DDL (Data Definition Language), and utility statements. To summarize all the types of statements being executed, you can query the QUERY_PROFILES system table. Example: I’d like to view a count of each statement type across my cluster since the first...

Truncating a Timestamp

Jim Knicely, Vertica Principal Solution Architect
April 5, 2019

The built-in Vertica function DATE_TRUNC truncates date and time values to the specified precision. The return value is the same data type as the input value. All fields that are less than the specified precision are set to 0, or to 1 for day and month. Example: So did the current Millennium begin on January...

Fun April Fool’s Day Trick Using Directed Queries

Jim Knicely, Vertica Principal Solution Architect
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...

Vertica Joins: A Refresher

Sarah Lemaire, Manager, Vertica Documentation
February 23, 2016

As a Vertica user, you know that using joins can improve query performance by combining records from one or more tables. But sometimes, you need to develop complex joins. Vertica supports many different kinds of joins that perform different functions based on your needs.

What are Vertica Engineers Reading?

Sarah Lemaire, Manager, Vertica Documentation
January 6, 2016

Ever wonder what Vertica engineers do when they aren?t busy building and perfecting an awesome product?

Using Big Data Analytical Tools for Predicting Potential Global Distribution of an Amphibian Pathogen

Sarah Lemaire, Manager, Vertica Documentation
September 9, 2015

During the summer of 2015, I participated in an internship program with Vertica. Most interns assisted in software development, but my primary goal was to use Vertica, Vertica Place, and HP Distributed R to address an ecological problem

Vertica and Qlik Team Up to Hack for a Cause

Sarah Lemaire, Manager, Vertica Documentation
August 17, 2015

On November 17 2014, Vertica took part in the annual Qlik Hackathon in Orlando, Florida. The hackathon, which took place the day before the Qlik World Conference, brought together engineers, developers, and Qlik experts from all over the world. The challenge was simple: leverage features from Qlik and its partners to create an application to...

Cloning a Vertica Cluster to AWS

Bob_Strahan
July 27, 2015

This enhancement to the open-source package makes it quite easy to create a working replica of your existing cloud-hosted or on-premise Vertica cluster in Amazon Web Services."

Three 3D arrows, different colors pointing in different directions

Why Do My License Audits Show A Significant Size Reduction?

nunziato
July 24, 2015

When you run a database audit, you may notice that your Vertica audit size has reduced from the audit size calculated before you upgraded to version 7.1 SP2. Don't worry, you haven't lost any data. The size reduction is due to storage changes related to licensing.

Vertica Blog