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

Archives for February 2019

Revoke Access From Just One System Table

Jim_Knicely 271 views 0 comments 0 points Started by Jim_Knicely February 28 Tips from the Team
Viewing Internal Statements Executed by Vertica

Jim_Knicely 263 views 0 comments 0 points Started by Jim_Knicely February 27 Tips from the Team
Take a Peek at the Next Mergeout Job

Jim_Knicely 293 views 0 comments 0 points Started by Jim_Knicely February 27 Tips from the Team
Generate a Murmur Hash

Jim_Knicely 288 views 0 comments 0 points Started by Jim_Knicely February 25 Tips from the Team
Set All User’s Default Roles to All of their Granted Roles

Jim_Knicely 302 views 1 comment 1 point Most recent by qinchaofeng March 13Tips from the Team
View Tuple Mover Operation Run-time Intervals

Jim_Knicely 317 views 0 comments 0 points Started by Jim_Knicely February 21 Tips from the Team
Auditing Flex Tables

Jim_Knicely 273 views 0 comments 0 points Started by Jim_Knicely February 20 Tips from the Team
Tracking Table Row Counts Over Time

Jim_Knicely 320 views 0 comments 0 points Started by Jim_Knicely February 14 Tips from the Team
Auditing Database DDL Operations

Jim_Knicely 298 views 0 comments 1 point Started by Jim_Knicely February 14 Tips from the Team
Reset the ROUNDROBIN Load Balancing Counter

Jim_Knicely 285 views 0 comments 0 points Started by Jim_Knicely February 12 Tips from the Team
Random Host Load Balancing

Jim_Knicely 284 views 0 comments 0 points Started by Jim_Knicely February 11 Tips from the Team
Yet Another Way to De-Duplicate Table Rows

Jim_Knicely 306 views 1 comment 1 point Most recent by mkheir February 10Tips from the Team
Combining Functions to Extract Discrete Data From a String

Jim_Knicely 289 views 0 comments 0 points Started by Jim_Knicely February 7 Tips from the Team
What’s the Distance Between Two Zip Codes?

Jim_Knicely 365 views 2 comments 1 point Most recent by Jim_Knicely February 12Tips from the Team
Calculate a Year’s Chinese Zodiac Animal

Jim_Knicely 280 views 0 comments 0 points Started by Jim_Knicely February 5 Tips from the Team
Finding All Columns Storing Some Value

Jim_Knicely 387 views 0 comments 0 points Started by Jim_Knicely February 4 Tips from the Team
Viewing External Table Definitions

Jim_Knicely 281 views 0 comments 0 points Started by Jim_Knicely February 1 Tips from the Team