Vertica Blog

The Vertica Academy Is Open for Learning

Posted September 9, 2019 by Joy King, VP, Vertica Product Management & Product Marketing

Read More

Introducing an Industry First – Vertica in Eon Mode for Pure Storage

This week at the Pure Accelerate conference, Vertica and Pure Storage of Vertica in Eon Mode for Pure Storage, the industry’s first and only analytical database solution with a separation of compute and storage architecture for on-premises analytic workloads. Why is this important to you? The rush to migrate analytic workloads to the cloud was,...

Vertica Big Data Conference Registration is Open!

We’re excited to announce that for the next Vertica Big Data Conference (BDC), held March 30 – April 2, 2020, at the Encore Boston Harbor Hotel. Don’t miss out on the early bird pricing rate of $695 (a $300 savings), along with buy 3 get 1 free group discounts!   What is the Big Data...
Cloud pattern in circuit board

Vertica Ranked #1 Cloud Data Warehouse

July has been quite an exciting month for Vertica. Our three keynote presenters are now confirmed for the Vertica Big Data Conference 2020 – Vertica founder and Turing Award winner Dr. Michael Stonebraker, kingpin of the famous MIT blackjack team Jeffrey Ma, and renowned analyst Ray Wang of Constellation Research. And, in addition to receiving...
Digital image of a trash can made of data points on blue background

Watch those Delete Vectors!

Vertica is very good at ingesting data, compressing it, and querying at high speed. The trade-off here is that the data is stored in large block files called ROS containers. These containers can grow to large sizes, sometimes over 10 GB, and this makes it impractical to decompress and edit the files during updates and...
Helpful Tips message on post-it note

Restore a Single Database View from a Backup

The Vertica Backup and Recovery (vbr) utility allows you to back up and restore either the full database, or one or more schema and table objects of interest. It’s a great tool for restoring a table if someone accidentally dropped it or deleted a significant amount of data by mistake. But what about a database...

Subscribe For Email Updates

Enter your email address to receive the monthly Vertica newsletter.

Helpful Tips text with hand and marker over data center background

Avoid 1:1 Relationships in Your Data Model

1:1 relationships exist in row-oriented databases because of performance concerns. As a columnar database, there is no reason in Vertica to separate large tables out into separate structures. That is, instead of joining two large fact tables together, combine them into a single table! Helpful Links: Have fun!
Lock

Looking into details of locking

(thanks  for query and advice) If you have a lot of concurrent queries, especially mixing DDL and DML, you might see lock contention. If you'd like to see how locks interact in your system, the following queries generate a temporary table with Gantt chart to show an ordered list of locks over time: Query (be...
Hand writing the text: Helpful Tips

Analyzing JSON Already Loaded into Vertica Regular Tables

Vertica flex tables allow you to query data in JSON format. But what if you've imported JSON objects into VARCHAR already? Here's how you can extract the JSON into flex tables without exporting and importing. Let's create a sample table with a JSON column to convert: Now let's create a flex table: Flex tables use...

Explore Popular Topics

Net Promoter Score

Vertica Scores Big in Customer Satisfaction

After more than a decade in enterprise sales, I confess that my least favorite experience is being forced to buy anything that requires me to engage with a salesperson. I do all my research online, read reviews from multiple sites, and talk with trusted friends and business colleagues to get their opinion on any of...
Data Definition Language in red 3D text in a field of white 3D ones and zeros

Export CREATE OR REPLACE DDL for Database Views

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

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

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...
Construction site crane building a blue SQL 3D text.

Creating Vertica Functions in Third Party Tools

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...
Go programming language logo and little blue beaver mascot

The Vertica SQL Driver for Go

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