The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

Replacing an Empty String

[Deleted User] 7.8K views 7 comments 0 points Most recent by Jim_Knicely November 2018Tips from the Team
Empty String Vs. NULL

[Deleted User] 2K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
Which Column in my Flattened Table caused the “Subquery used as an expression returned more than one

[Deleted User] 1.6K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
Tuple Mover (TM) Assigned More Resources in Vertica 9.1

[Deleted User] 1.3K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
Monitoring the Ancient History Mark

[Deleted User] 1.2K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
Determining Table Columns that Contain NULL Values

[Deleted User] 1.6K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
Getting Better Performance via External Table Row Counts

[Deleted User] 1.2K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
Remove Duplicate Values from a String

[Deleted User] 2.1K views 1 comment 0 points Most recent by Jim_Knicely June 2018Tips from the Team
Who am I?

[Deleted User] 1.2K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
When Modifying a SEARCH_PATH, Don’t Forget to Include PUBLIC

[Deleted User] 1.4K views 0 comments 1 point Started by [Deleted User] May 2018 Tips from the Team
Keeping DbVisualizer Alive

[Deleted User] 2.1K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
Use the OVERLAY Function to Easily Insert a String Into Another String

[Deleted User] 1.3K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
Eon Mode Now Available in Vertica 9.1

[Deleted User] 3.7K views 5 comments 1 point Most recent by Jim_Knicely June 2019Tips from the Team
Using vsql Almost Anywhere

[Deleted User] 2K views 1 comment 0 points Most recent by Jim_Knicely May 2018Tips from the Team
User-Defined Functions to the Rescue

[Deleted User] 4.2K views 5 comments 0 points Most recent by Jim_Knicely July 2019Tips from the Team
Get Rid of all Those Q’s

[Deleted User] 1.8K views 1 comment 0 points Most recent by Jim_Knicely May 2018Tips from the Team
Forget the Column Name in a System Table?

[Deleted User] 1.2K views 0 comments 0 points Started by [Deleted User] May 2018 Tips from the Team
Capitalize Only the First Letter of Each Word

[Deleted User] 1.3K views 0 comments 2 points Started by [Deleted User] May 2018 Tips from the Team

Tips from the Team

Discussion List