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

Announcements, news, and tips from Vertica employees.

Analyzing JSON Already Loaded into Vertica Regular Tables

Bryan_H 622 views 0 comments 0 points Started by Bryan_H July 2019
Hash Function Result Depends on Data Type and Sometimes Size

Jim_Knicely 731 views 0 comments 1 point Started by Jim_Knicely July 2019
Loading Data Stored in Scientific Notation to an Integer Column

Jim_Knicely 677 views 0 comments 0 points Started by Jim_Knicely July 2019
Auto-Projection Column Sort Order

Jim_Knicely 583 views 0 comments 0 points Started by Jim_Knicely July 2019
Coin Flip User Defined SQL Function

Jim_Knicely 571 views 0 comments 0 points Started by Jim_Knicely July 2019
Non-DBADMIN Access to System Tables (Table by Table)

Jim_Knicely 651 views 0 comments 0 points Started by Jim_Knicely July 2019
Tracking VBR Invocations

Jim_Knicely 575 views 0 comments 0 points Started by Jim_Knicely June 2019
Track License Usage Over Time

Jim_Knicely 583 views 0 comments 0 points Started by Jim_Knicely June 2019
Improving the performance of rebalancing

SarahL 971 views 2 comments 0 points Most recent by Ravi June 2019
Enable All Granted Roles on Login

Jim_Knicely 639 views 0 comments 0 points Started by Jim_Knicely June 2019
Keeping Track of Data Exports and Imports

Jim_Knicely 600 views 0 comments 0 points Started by Jim_Knicely June 2019
Eon Mode Now Available in Vertica 9.1

SarahL 861 views 5 comments 1 point Most recent by Jim_Knicely June 2019
Generate DDL for Changed Configuration Parameters

Jim_Knicely 632 views 0 comments 0 points Started by Jim_Knicely June 2019
Generating Recursive COPY Commands

Jim_Knicely 662 views 0 comments 0 points Started by Jim_Knicely June 2019
Total Table Row Count Report by Schema

Jim_Knicely 1.6K views 0 comments 0 points Started by Jim_Knicely June 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
Monitor the Current Value of Node Spread Daemon Timeouts

Jim_Knicely 661 views 0 comments 0 points Started by Jim_Knicely May 2019
Min and Max Values for Spread Daemon Timeout

Jim_Knicely 672 views 0 comments 0 points Started by Jim_Knicely May 2019
Adjusting Spread Daemon Timeouts

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

Jim_Knicely 1.1K views 0 comments 0 points Started by Jim_Knicely May 2019
Watch Out for Data Induced “Cross” Joins

Jim_Knicely 733 views 0 comments 0 points Started by Jim_Knicely May 2019
Direct Output to /dev/null in VSQL

Jim_Knicely 706 views 0 comments 0 points Started by Jim_Knicely May 2019
NULL Values do not Count Against Your Vertica License!

Jim_Knicely 662 views 0 comments 0 points Started by Jim_Knicely May 2019
Add a Column to All of a Table’s Projections

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely May 2019
View the Query Plan for a COPY Statement

Jim_Knicely 672 views 0 comments 0 points Started by Jim_Knicely May 2019
Close All Sessions for a User with a Single Command

Jim_Knicely 931 views 0 comments 0 points Started by Jim_Knicely May 2019
Reading GZIP files from S3 into Vertica

SarahL 2.2K views 10 comments 0 points Most recent by Jim_Knicely May 2019
Table Schemas for Global and Local Temp Tables

Jim_Knicely 1.2K views 0 comments 0 points Started by Jim_Knicely May 2019
Make Comparisons on Subqueries that Return Multiple Rows

Jim_Knicely 682 views 0 comments 0 points Started by Jim_Knicely May 2019
Create a Python UDx to Order a List of Values

Jim_Knicely 751 views 1 comment 1 point Most recent by bishal April 2019