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.

Min and Max Values for Spread Daemon Timeout

Jim_Knicely 184 views 0 comments 0 points Started by Jim_Knicely May 2019
Adjusting Spread Daemon Timeouts

Jim_Knicely 168 views 0 comments 0 points Started by Jim_Knicely May 2019
Include the ALTER and DROP privileges in a GRANT ALL Statement

Jim_Knicely 216 views 0 comments 0 points Started by Jim_Knicely May 2019
Watch Out for Data Induced “Cross” Joins

Jim_Knicely 188 views 0 comments 0 points Started by Jim_Knicely May 2019
Direct Output to /dev/null in VSQL

Jim_Knicely 193 views 0 comments 0 points Started by Jim_Knicely May 2019
NULL Values do not Count Against Your Vertica License!

Jim_Knicely 187 views 0 comments 0 points Started by Jim_Knicely May 2019
Add a Column to All of a Table’s Projections

Jim_Knicely 328 views 0 comments 0 points Started by Jim_Knicely May 2019
View the Query Plan for a COPY Statement

Jim_Knicely 192 views 0 comments 0 points Started by Jim_Knicely May 2019
Close All Sessions for a User with a Single Command

Jim_Knicely 240 views 0 comments 0 points Started by Jim_Knicely May 2019
Reading GZIP files from S3 into Vertica

SarahL 1.2K views 10 comments 0 points Most recent by Jim_Knicely May 2019
Table Schemas for Global and Local Temp Tables

Jim_Knicely 291 views 0 comments 0 points Started by Jim_Knicely May 2019
Make Comparisons on Subqueries that Return Multiple Rows

Jim_Knicely 197 views 0 comments 0 points Started by Jim_Knicely May 2019
Create a Python UDx to Order a List of Values

Jim_Knicely 233 views 1 comment 1 point Most recent by bishal April 2019
Displaying the Vertica Code Name

Jim_Knicely 227 views 0 comments 0 points Started by Jim_Knicely April 2019
Forcing a Merge Join

Jim_Knicely 383 views 0 comments 1 point Started by Jim_Knicely April 2019
Descending Sequences

Jim_Knicely 228 views 0 comments 0 points Started by Jim_Knicely April 2019
Display Session Sequence Cached Values Remaining

Jim_Knicely 241 views 0 comments 0 points Started by Jim_Knicely April 2019
Is this a Leap Year?

Jim_Knicely 250 views 0 comments 0 points Started by Jim_Knicely April 2019
How Old Am I (In Months)?

Jim_Knicely 257 views 0 comments 0 points Started by Jim_Knicely April 2019
Display the Vertica Process Memory Allocated

Jim_Knicely 294 views 0 comments 0 points Started by Jim_Knicely April 2019
Display Database Statement Counts by Type

Jim_Knicely 266 views 0 comments 1 point Started by Jim_Knicely April 2019
Use Time Series Analytics to Generate a List of Dates at a Specific Start Date

Jim_Knicely 452 views 0 comments 0 points Started by Jim_Knicely April 2019
Truncating a Timestamp

Jim_Knicely 252 views 0 comments 0 points Started by Jim_Knicely April 2019
Partition a Table By More Than One Column

Jim_Knicely 274 views 0 comments 0 points Started by Jim_Knicely April 2019
Accept the EULA When Installing Vertica

Jim_Knicely 283 views 0 comments 0 points Started by Jim_Knicely April 2019
Fun April Fool’s Day Trick Using Directed Queries

Jim_Knicely 278 views 0 comments 1 point Started by Jim_Knicely April 2019
Properly Identifying Identifiers

Jim_Knicely 267 views 0 comments 0 points Started by Jim_Knicely March 2019
Display a Query Title in VSQL

Jim_Knicely 269 views 0 comments 0 points Started by Jim_Knicely March 2019
Run the Same Query Over and Over Again in VSQL

Jim_Knicely 274 views 0 comments 0 points Started by Jim_Knicely March 2019
Find out When Vertica was Last Updated

Jim_Knicely 278 views 0 comments 0 points Started by Jim_Knicely March 2019