Tips from the Team

Announcements, news, and tips from Vertica employees.

Hash Function Result Depends on Data Type and Sometimes Size

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

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

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

Jim_Knicely 1.1K views 1 comment 0 points Most recent by Jim_Knicely July 2019
Non-DBADMIN Access to System Tables (Table by Table)

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

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

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

[Deleted User] 2.6K views 2 comments 0 points Most recent by Ravi June 2019
Enable All Granted Roles on Login

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

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

[Deleted User] 4.2K views 5 comments 1 point Most recent by Jim_Knicely June 2019
Generate DDL for Changed Configuration Parameters

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

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

Jim_Knicely 2.4K views 0 comments 0 points Started by Jim_Knicely June 2019
Set the Spread Daemon Timeout Back to the Default Value

Jim_Knicely 1.3K views 0 comments 0 points Started by Jim_Knicely May 2019
Monitor the Current Value of Node Spread Daemon Timeouts

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

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

Jim_Knicely 1.2K 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.8K views 0 comments 0 points Started by Jim_Knicely May 2019
Watch Out for Data Induced “Cross” Joins

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

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

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

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

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

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

[Deleted User] 8.5K views 10 comments 0 points Most recent by Jim_Knicely May 2019
Table Schemas for Global and Local Temp Tables

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

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

Jim_Knicely 1.9K views 1 comment 1 point Most recent by bishal April 2019
Displaying the Vertica Code Name

Jim_Knicely 1.2K views 0 comments 0 points Started by Jim_Knicely April 2019