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 January 2019

Generate a Random Integer Within a Range

Jim_Knicely 304 views 0 comments 0 points Started by Jim_Knicely January 31 Tips from the Team
Seeding a Random Integer

Jim_Knicely 271 views 0 comments 0 points Started by Jim_Knicely January 30 Tips from the Team
Seeding a Random Number

Jim_Knicely 288 views 0 comments 0 points Started by Jim_Knicely January 29 Tips from the Team
Limiting the Amount of Memory Available to a Query

Jim_Knicely 283 views 0 comments 0 points Started by Jim_Knicely January 28 Tips from the Team
Display a Rounded Number With a Specific Scale

Jim_Knicely 290 views 0 comments 0 points Started by Jim_Knicely January 25 Tips from the Team
View Vertica Features Recently Used

Jim_Knicely 306 views 0 comments 0 points Started by Jim_Knicely January 24 Tips from the Team
Monitoring COPY Statement Events (Part 2)

Jim_Knicely 301 views 0 comments 0 points Started by Jim_Knicely January 24 Tips from the Team
Monitoring COPY Statement Events (Part 1)

Jim_Knicely 295 views 0 comments 0 points Started by Jim_Knicely January 22 Tips from the Team
Using VSQL as a Calculator

Jim_Knicely 289 views 0 comments 0 points Started by Jim_Knicely January 18 Tips from the Team
Extracting Characters from the Left and Right Side of a LONG VARCHAR

Jim_Knicely 283 views 0 comments 0 points Started by Jim_Knicely January 16 Tips from the Team
Determining the Current K-Safety

Jim_Knicely 280 views 0 comments 0 points Started by Jim_Knicely January 15 Tips from the Team
Specifying CASCADE When Dropping a Table

Jim_Knicely 317 views 0 comments 0 points Started by Jim_Knicely January 14 Tips from the Team
Ordering the List of Values Returned from LISTAGG

Jim_Knicely 427 views 0 comments 0 points Started by Jim_Knicely January 11 Tips from the Team
Ignore NULL Values in Non-Correlated Subqueries

Jim_Knicely 281 views 0 comments 0 points Started by Jim_Knicely January 10 Tips from the Team
Drop More than One Table at a Time

Jim_Knicely 300 views 0 comments 0 points Started by Jim_Knicely January 9 Tips from the Team
Allowing Users to Query a View Owned by Another User

Jim_Knicely 285 views 0 comments 0 points Started by Jim_Knicely January 8 Tips from the Team
A View Owner Needs Access to the Underlying Objects

Jim_Knicely 314 views 0 comments 0 points Started by Jim_Knicely January 7 Tips from the Team
Preserving Objects Owned by a Dropped User

Jim_Knicely 272 views 0 comments 0 points Started by Jim_Knicely January 4 Tips from the Team
List Table Rows by ROS Container

Jim_Knicely 308 views 2 comments 0 points Most recent by Jim_Knicely January 4Tips from the Team
Tracking Save Points

Jim_Knicely 283 views 0 comments 0 points Started by Jim_Knicely January 2 Tips from the Team