Tips from the Team

Summarize the Values in a String

Jim_Knicely 1.8K views 1 comment 1 point Most recent by Jim_Knicely November 2019

Query spends more time on before plan

Answered VigneshN 5.5K views 3 comments 0 points Most recent by emoreno November 2019

Checking and improving column compression and encoding

Bryan_H 4.2K views 1 comment 1 point Most recent by Sharon_Cutter November 2019

How To get OS/kernel version in Vertica catalog tables

Answered Vertiguy 5K views 2 comments 0 points Most recent by ChuckB November 2019

Vertica 9.3 Supports UPDATE and DELETE Operations on Tables Having Live Aggregate Projections!

Jim_Knicely 6K views 2 comments 1 point Most recent by Jim_Knicely October 2019

DIRECT Is Now the Default Load Type

Jim_Knicely 5.1K views 2 comments -1 point Most recent by Jim_Knicely October 2019

How to alter a column data type from numeric(3,2) to numeric(5,4) in Vertica

Answered Vertiguy 7.3K views 1 comment 1 point Most recent by hsaxena20 October 2019

Get the Row Count from an Outer Table Join

Jim_Knicely 1.8K views 0 comments 1 point Started by Jim_Knicely October 2019

Parallel processing using partitions with Vertica UDx

Bryan_H 1.9K views 0 comments 0 points Started by Bryan_H October 2019

Extending Vertica with Python functions: adding NumPy FFT as a UDx

Bryan_H 2K views 0 comments -1 point Started by Bryan_H October 2019

Finding the "K" in K-means clustering with a UDx

Bryan_H 1.7K views 0 comments -1 point Started by Bryan_H October 2019

Tracking Raw Schema Size Over Time

Jim_Knicely 1.8K views 0 comments 1 point Started by Jim_Knicely September 2019

Easy Development Schema Cleanup (i.e. Have Vertica Drop a Bunch of Tables for You)

Jim_Knicely 1.7K views 0 comments 1 point Started by Jim_Knicely September 2019

Investigate Data Collector Table Data Produced by a Scrutinize

Jim_Knicely 1.8K views 0 comments -1 point Started by Jim_Knicely September 2019

Load Data Enclosed By and Embedded With Double Quotes

Jim_Knicely 2.4K views 0 comments 0 points Started by Jim_Knicely September 2019

Make a Cow Display Query Results in VSQL

Question Jim_Knicely 1.8K views 0 comments 1 point Most recent by Jim_Knicely August 2019

Stop a Stubborn Query that Won’t Cancel

Answered Jim_Knicely 6K views 2 comments 0 points Most recent by Jim_Knicely August 2019

Change Your User Password in VSQL with a Meta-Command

Jim_Knicely 2K views 0 comments 0 points Most recent by Jim_Knicely August 2019

View the History of Connection Load Balance Operations

Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely August 2019

Load Balance Older Clients (That You Can’t Upgrade for Some Weird Reason)

Jim_Knicely 1.7K views 0 comments 0 points Most recent by Jim_Knicely August 2019

Testing the Native Load Balancer

Jim_Knicely 1.7K views 0 comments 0 points Most recent by Jim_Knicely August 2019

Diving into disk usage

Bryan_H 1.9K views 0 comments 0 points Most recent by Bryan_H August 2019

Find and fix issues from Vertica query events

Bryan_H 2K views 0 comments 0 points Most recent by Bryan_H August 2019

Find the Busiest Hour in the Day for I/O

Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely August 2019

Theoretical Maximum Number of Rows Per Table Per Node

Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely August 2019

Watch those delete vectors!

Bryan_H 6.4K views 3 comments 0 points Most recent by emoreno July 2019

Streaming data in one line!

Bryan_H 1.9K views 0 comments 0 points Most recent by Bryan_H July 2019

Restore a Single Database View from a Backup

Jim_Knicely 1.8K views 0 comments 1 point Most recent by Jim_Knicely July 2019

Avoid 1:1 Relationships in Your Data Model

Jim_Knicely 1.8K views 0 comments 0 points Most recent by Jim_Knicely July 2019

Looking into details of locking

Bryan_H 1.9K views 0 comments 0 points Most recent by Bryan_H July 2019

Tips from the Team

Discussion List