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

Export CREATE OR REPLACE DDL for Database Views

Jim Knicely, Vertica Principal Solution Architect
July 19, 2019

The EXPORT_OBJECTS Catalog Management Function generates a SQL script you can use to recreate non-virtual catalog objects on another cluster. When you export a database view, Vertica includes the CREATE VIEW DDL in the output. But what if you want the DDL to be CREATE OR REPLACE VIEW? You can make that change with the...

Vintage businessman concept pointing on the wall wearing futuristic helmet at office

Hash Function Result Depends on Data Type and Sometimes Size

Jim Knicely, Vertica Principal Solution Architect
July 18, 2019

The Vertica HASH function calculates a hash value over the function arguments, producing a value in the range 0 <= x < 2^63. When calculating a hash value, the HASH function takes into consideration the data type and size of the original value. Be careful when comparing hashed column values from different tables where the...

Helpful Tips in blue text with magnifying glass

Loading Data Stored in Scientific Notation to an Integer Column

Jim Knicely, Vertica Principal Solution Architect
July 17, 2019

Scientific notation is a way of expressing numbers that are too big or too small to be conveniently written in decimal form. Vertica can display numbers in scientific notation in decimal form with ease. That is, unless the value is a string! You first have to convert the VARCHAR to a NUMERIC and then to...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Construction site crane building a blue SQL 3D text.

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

Red and blue square dots fly from scattered into two neat rows arranged by color.

Auto-Projection Column Sort Order

Jim Knicely, Vertica Principal Solution Architect
July 8, 2019

Auto-projections are superprojections that Vertica automatically generates for tables, both temporary and persistent. Vertica uses the current value of the MaxAutoSortColumns configuration parameter to determine which table columns are included in the auto-projection sort order. Helpful Links: Have fun!

Hand with suit cuff flips shiny gold coin

Coin Flip User Defined SQL Function

Jim Knicely, Vertica Principal Solution Architect
July 2, 2019

In the past when my wife and I couldn’t decide which of two restaurants to go to grab dinner, we opened the Coin Flip app on one of our phones to let it decide. Now I let Vertica choose for us via a simple User Defined SQL Function! Helpful Links: Have fun!

Explore Popular Topics

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

Non-DBADMIN Access to System Tables (Table by Table)

Jim Knicely, Vertica Principal Solution Architect
July 1, 2019

The DBADMIN can assign a delegate the SYSMONITOR role to grant full access to system tables without granting full DBADMIN access. The SYSMONITOR role applies to all tables that have the flag IS_MONITORABLE set to true in the SYSTEM_TABLES system table. What if I want a non-DBADMIN user to have full access to only a...

Compass rose with true north pointing to "Helpful Tips" text

Tracking VBR Invocations

Jim Knicely, Vertica Principal Solution Architect
June 28, 2019

The Vertica Backup and Recovery tool (vbr) allows you to back up and restore either the full database, or one or more schema and table objects of interest. You can also copy a cluster and list backups you created previously. You can view vbr invocations by querying the DC_VBR_INVOCATIONS data collector table! Helpful Links: Have...

Vintage businessman concept wearing futuristic helmet at office

Track License Usage Over Time

Jim Knicely, Vertica Principal Solution Architect
June 28, 2019

The LICENSE_AUDITS system table lists the results of Vertica's license automatic compliance audits. You can query it to track your Vertica license usage over time! Looks like I’m going to need add some new Vertica license soon! Helpful Links: Have fun!

Data-Centric Security Rules

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

I just attended the for the first time. I spoke a little on a small panel with a couple of customers about and Format Preserving Encryption (FPE). Then I got to go to other presentations and learned a lot. Probably the number one presentation that stuck with me, was of , the presenter who put...