Vertica Blog

OpenText Vertica 23.3 – the Smarter Data Lakehouse

Posted July 31, 2023 by Paige Roberts, Vertica Open Source Relations Manager

Read More

Unveiling the Most Recent Version of the Vertica Grafana Data Source Plugin

Amrita Akshay, Information Developer
October 12, 2023

With over 380K downloads, the Vertica Grafana Data Source plugin just got an upgrade! The plugin was migrated from the deprecated older Grafana toolkit to align with Grafana's new Create-Plugin tool. This accelerates the plugin development with their modern build set up that requires no additional configuration. Additionally, the Vertica SQL Go driver received an...
Quick Tip on a blue enter key on a keyboard

Setting Session Authorization to Troubleshoot

Sruthi Anumula, Senior Database Support Engineer
September 29, 2023

There are possible scenarios in which a dbadmin would want to run queries as another user to troubleshoot or test. You can use SET SESSION AUTHORIZATION to impersonate another user and run queries. Let's understand this with an example. Here we create a user named test, resource pool named userpool, and make this a default...
Lock

Looking into details of locking

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
July 23, 2019

(thanks @skeswani 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

Bryan Herger, Vertica Big Data Solution Architect at Micro Focus
July 22, 2019

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...
Net Promoter Score

Vertica Scores Big in Customer Satisfaction

Joy King, VP Product & GTM Strategy, Vertica
July 20, 2019

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

Subscribe For Email Updates

Sign-up and select Vertica in your preferences to receive our monthly Vertica newsletter.

Sign-up

Data Definition Language in red 3D text in a field of white 3D ones and zeros

Export CREATE OR REPLACE DDL for Database Views

James Knicely, Vertica Field Chief Technologist
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

James Knicely, Vertica Field Chief Technologist
July 18, 2019

The Vertica HASH function calculates a hash value over the function arguments, producing a value in the range 0
Helpful Tips in blue text with magnifying glass

Loading Data Stored in Scientific Notation to an Integer Column

James Knicely, Vertica Field Chief Technologist
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...

Explore Popular Topics

SQL
DBadmin
Advanced Analytics
machine learning
Best Practices
Cloud
VSQL
Eon Mode
Analytics
Partner Integrations
Vertica
Open Source
AWS
IoT
Time series
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 DbVisualizer: The...
Go programming language logo and little blue beaver mascot

The Vertica SQL Driver for Go

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...
Red and blue square dots fly from scattered into two neat rows arranged by color.

Auto-Projection Column Sort Order

James Knicely, Vertica Field Chief Technologist
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: https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/Projections/AutoProjections.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/AdministratorsGuide/ConfiguringTheDB/ProjectionParameters.htm Have fun!
hands in surgical gloves hold vial with small amount of blood

Is Data Warehouse as a Service Out for Your Blood?

Jeff Healey, Vice President of Marketing, Vertica Product Group in Micro Focus
July 3, 2019

Last weekend, I finally had the chance to watch the popular, yet alarming HBO documentary – The Inventor: Out for Blood in Silicon Valley. 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...
Hand with suit cuff flips shiny gold coin

Coin Flip User Defined SQL Function

James Knicely, Vertica Field Chief Technologist
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! dbadmin=> SELECT coin_flip, COUNT(*) FROM (SELECT coin_flip()...
Quick Tip - blue button

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

James Knicely, Vertica Field Chief Technologist
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...