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

Replacing an Empty String

SarahL 2.7K views 7 comments 0 points Most recent by Jim_Knicely November 2018Tips from the Team
Empty String Vs. NULL

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

SarahL 1.1K views 0 comments 0 points Started by SarahL May 2018 Tips from the Team
Tuple Mover (TM) Assigned More Resources in Vertica 9.1

SarahL 821 views 0 comments 0 points Started by SarahL May 2018 Tips from the Team
Monitoring the Ancient History Mark

SarahL 791 views 0 comments 0 points Started by SarahL May 2018 Tips from the Team
Determining Table Columns that Contain NULL Values

SarahL 1.1K views 0 comments 0 points Started by SarahL May 2018 Tips from the Team
Getting Better Performance via External Table Row Counts

SarahL 792 views 0 comments 0 points Started by SarahL May 2018 Tips from the Team
Remove Duplicate Values from a String

SarahL 1.1K views 1 comment 0 points Most recent by Jim_Knicely June 2018Tips from the Team
Who am I?

SarahL 792 views 0 comments 0 points Started by SarahL May 2018 Tips from the Team
When Modifying a SEARCH_PATH, Don’t Forget to Include PUBLIC

SarahL 914 views 0 comments 1 point Started by SarahL May 2018 Tips from the Team
Keeping DbVisualizer Alive

SarahL 1.2K views 0 comments 0 points Started by SarahL May 2018 Tips from the Team
Use the OVERLAY Function to Easily Insert a String Into Another String

SarahL 792 views 0 comments 0 points Started by SarahL May 2018 Tips from the Team
Eon Mode Now Available in Vertica 9.1

SarahL 862 views 5 comments 1 point Most recent by Jim_Knicely June 2019Tips from the Team
Using vsql Almost Anywhere

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

SarahL 1.2K views 5 comments 0 points Most recent by Jim_Knicely July 2019Tips from the Team
Get Rid of all Those Q’s

SarahL 882 views 1 comment 0 points Most recent by Jim_Knicely May 2018Tips from the Team
Forget the Column Name in a System Table?

SarahL 811 views 0 comments 0 points Started by SarahL May 2018 Tips from the Team
Capitalize Only the First Letter of Each Word

SarahL 853 views 0 comments 2 points Started by SarahL May 2018 Tips from the Team