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 2019

Set the Spread Daemon Timeout Back to the Default Value

Jim_Knicely 731 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Monitor the Current Value of Node Spread Daemon Timeouts

Jim_Knicely 663 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Min and Max Values for Spread Daemon Timeout

Jim_Knicely 673 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Adjusting Spread Daemon Timeouts

Jim_Knicely 681 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Include the ALTER and DROP privileges in a GRANT ALL Statement

Jim_Knicely 957 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Watch Out for Data Induced “Cross” Joins

Jim_Knicely 700 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Direct Output to /dev/null in VSQL

Jim_Knicely 701 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
NULL Values do not Count Against Your Vertica License!

Jim_Knicely 661 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Add a Column to All of a Table’s Projections

Jim_Knicely 1.2K views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
View the Query Plan for a COPY Statement

Jim_Knicely 671 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Close All Sessions for a User with a Single Command

Jim_Knicely 866 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Table Schemas for Global and Local Temp Tables

Jim_Knicely 1.1K views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team
Make Comparisons on Subqueries that Return Multiple Rows

Jim_Knicely 681 views 0 comments 0 points Started by Jim_Knicely May 2019 Tips from the Team