Welcome to the Vertica Forum

The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Tips from the Team

Announcements, news, and tips from Vertica employees.

Vertica Community Guidelines

Announcement JAvila 267 views 0 comments 2 points Started by JAvila August 13
Parallel processing using partitions with Vertica UDx

Bryan_H 4 views 0 comments 0 points Started by Bryan_H 1:34AM
How To get OS/kernel version in Vertica catalog tables

Answered Vertiguy 23 views 1 comment 1 point Most recent by Bryan_H 1:24AM
Extending Vertica with Python functions: adding NumPy FFT as a UDx

Bryan_H 20 views 0 comments 0 points Started by Bryan_H October 10
Query spends more time on before plan

Answered VigneshN 20 views 1 comment 0 points Most recent by SruthiA October 6
Finding the "K" in K-means clustering with a UDx

Bryan_H 16 views 0 comments 1 point Started by Bryan_H October 3
Tracking Raw Schema Size Over Time

Jim_Knicely 13 views 0 comments 0 points Started by Jim_Knicely September 25
Have VSQL Beep Upon Command Completion

Jim_Knicely 16 views 1 comment 0 points Most recent by LenoyJ September 7
Easy Development Schema Cleanup (i.e. Have Vertica Drop a Bunch of Tables for You)

Jim_Knicely 10 views 0 comments 0 points Started by Jim_Knicely September 7
Investigate Data Collector Table Data Produced by a Scrutinize

Jim_Knicely 19 views 0 comments 0 points Started by Jim_Knicely September 4
Load Data Enclosed By and Embedded With Double Quotes

Jim_Knicely 17 views 0 comments 0 points Started by Jim_Knicely September 4
How to alter a column data type from numeric(3,2) to numeric(5,4) in Vertica

Question Vertiguy 37 views 0 comments 0 points Started by Vertiguy August 19
Make a Cow Display Query Results in VSQL

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

Answered Jim_Knicely 93 views 2 comments -1 point Most recent by Jim_Knicely August 16
Change Your User Password in VSQL with a Meta-Command

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

Jim_Knicely 45 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 18 views 0 comments 0 points Started by Jim_Knicely August 8
Testing the Native Load Balancer

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

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

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

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

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

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

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

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

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

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

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

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

Jim_Knicely 22 views 0 comments 0 points Started by Jim_Knicely July 18