Welcome to the Vertica Forum

Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Tips from the Team

Archives for February 2019

Revoke Access From Just One System Table

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

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

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

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

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

Jim_Knicely 913 views 0 comments 0 points Started by Jim_Knicely February 2019 Tips from the Team
Auditing Flex Tables

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

Jim_Knicely 1.1K views 0 comments 0 points Started by Jim_Knicely February 2019 Tips from the Team
Auditing Database DDL Operations

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

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

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

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

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

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

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

Jim_Knicely 1.4K views 0 comments 0 points Started by Jim_Knicely February 2019 Tips from the Team
Viewing External Table Definitions

Jim_Knicely 805 views 0 comments 0 points Started by Jim_Knicely February 2019 Tips from the Team