Welcome to the Vertica Forum

The Vertica Forum is getting a makeover! The site will be undergoing maintenance from Tuesday 8/13 to Friday 8/16. We appreciate your patience and cooperation during this time.

Tips from the Team

Announcements, news, and tips from Vertica employees.

Vertica Community Guidelines

Announcement JAvila 66 views 0 comments 0 points Started by JAvila August 13
Make a Cow Display Query Results in VSQL

Question Jim_Knicely 10 views 0 comments 0 points Started by Jim_Knicely August 16
Stop a Stubborn Query that Won’t Cancel

Answered Jim_Knicely 49 views 2 comments 0 points Most recent by Jim_Knicely August 16
Change Your User Password in VSQL with a Meta-Command

Jim_Knicely 52 views 0 comments 0 points Started by Jim_Knicely August 13
View the History of Connection Load Balance Operations

Jim_Knicely 34 views 0 comments 0 points Started by Jim_Knicely August 9
Load Balance Older Clients (That You Can’t Upgrade for Some Weird Reason)

Jim_Knicely 14 views 0 comments 0 points Started by Jim_Knicely August 8
Testing the Native Load Balancer

Jim_Knicely 19 views 0 comments 0 points Started by Jim_Knicely August 7
Diving into disk usage

Bryan_H 16 views 0 comments 0 points Started by Bryan_H August 6
Find and fix issues from Vertica query events

Bryan_H 20 views 0 comments 0 points Started by Bryan_H August 5
Find the Busiest Hour in the Day for I/O

Jim_Knicely 17 views 0 comments 0 points Started by Jim_Knicely August 2
Theoretical Maximum Number of Rows Per Table Per Node

Jim_Knicely 18 views 0 comments 0 points Started by Jim_Knicely August 2
Watch those delete vectors!

Bryan_H 31 views 3 comments 0 points Most recent by emoreno July 31
Streaming data in one line!

Bryan_H 26 views 0 comments 0 points Started by Bryan_H July 31
Restore a Single Database View from a Backup

Jim_Knicely 15 views 0 comments 1 point Started by Jim_Knicely July 29
Avoid 1:1 Relationships in Your Data Model

Jim_Knicely 20 views 0 comments 0 points Started by Jim_Knicely July 29
Looking into details of locking

Bryan_H 20 views 0 comments 0 points Started by Bryan_H July 23
User-Defined Functions to the Rescue

SarahL 420 views 5 comments 0 points Most recent by Jim_Knicely July 22
Analyzing JSON Already Loaded into Vertica Regular Tables

Bryan_H 18 views 0 comments 0 points Started by Bryan_H July 22
Hash Function Result Depends on Data Type and Sometimes Size

Jim_Knicely 17 views 0 comments 0 points Started by Jim_Knicely July 18
Loading Data Stored in Scientific Notation to an Integer Column

Jim_Knicely 22 views 0 comments 0 points Started by Jim_Knicely July 17
Auto-Projection Column Sort Order

Jim_Knicely 47 views 0 comments 0 points Started by Jim_Knicely July 5
Coin Flip User Defined SQL Function

Jim_Knicely 48 views 0 comments 0 points Started by Jim_Knicely July 2
Non-DBADMIN Access to System Tables (Table by Table)

Jim_Knicely 46 views 0 comments 0 points Started by Jim_Knicely July 1
Tracking VBR Invocations

Jim_Knicely 48 views 0 comments 0 points Started by Jim_Knicely June 28
Track License Usage Over Time

Jim_Knicely 51 views 0 comments 0 points Started by Jim_Knicely June 27
Improving the performance of rebalancing

SarahL 421 views 2 comments 0 points Most recent by Ravi June 24
Enable All Granted Roles on Login

Jim_Knicely 80 views 0 comments 0 points Started by Jim_Knicely June 20
Keeping Track of Data Exports and Imports

Jim_Knicely 76 views 0 comments 0 points Started by Jim_Knicely June 19
Eon Mode Now Available in Vertica 9.1

SarahL 358 views 5 comments 1 point Most recent by Jim_Knicely June 18
Generate DDL for Changed Configuration Parameters

Jim_Knicely 77 views 0 comments 0 points Started by Jim_Knicely June 17