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 October 2018

Re-Compute a Table Column’s Default Value

Jim_Knicely 301 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Derive a Table Column’s Default Value from another Column

Jim_Knicely 275 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Default a Column’s Value

Jim_Knicely 356 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Display View Column Data Types

Jim_Knicely 355 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Insert Text Into Text

Jim_Knicely 274 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Reset Your Session

Jim_Knicely 279 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Conveniently Display Key Projection Info

Jim_Knicely 273 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Checking the Validity of a Table Audit

Jim_Knicely 324 views 1 comment 1 point Most recent by Jim_Knicely October 2018Tips from the Team
Generate an Auto-Incrementing Alphabetical Series Using SQL

Jim_Knicely 282 views 0 comments 1 point Started by Jim_Knicely October 2018 Tips from the Team
Viewing Previously Generated Explain Plans

Jim_Knicely 285 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Display Null Query Result With an Alternate Text

Jim_Knicely 274 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Special Date/Time Formatting

Jim_Knicely 283 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Change the VSQL Result Set Border

Jim_Knicely 281 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Find Which System Tables Have a Particular Column Name

Jim_Knicely 293 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Find Which Tables Have a Particular Column Name

Jim_Knicely 284 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Database Storage - Raw and Compressed Size

Jim_Knicely 334 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Display Last SQL Run Time

Jim_Knicely 307 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Displaying the Administration Tools Process ID

Jim_Knicely 284 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Rotating Column Data Using SQL Analytics

Jim_Knicely 281 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team
Return Zero Instead of NULL

Jim_Knicely 314 views 0 comments 0 points Started by Jim_Knicely October 2018 Tips from the Team